Table 'MSysAccessObjects' already exists

I can't blame it on an IT department, Bill, since this is work I do on my
home computer on a volunteer basis.

Bruce

"Bill Mosca" wrote:

Excellent idea, Bruce. Our IT department keeps daily backups for a week on
my Access databases which is more than long enough. My SQL Server databases
have at least a month's worth of backups should the need arise.

It really surprises me that your guys overwrite everything nightly. I've
never worked in a place that did that.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/M..._Professionals




"Brucels" wrote in message
...
Thanks to everyone for their advice. After trying a number of the
suggestions
with no success, I had to break down and spend money (fortunately, not my
own) for some recovery software, which worked pretty well, although not
all
of the queries survived.

The main thing I have learned from this exercise is that I need to set up
a
different system for backing up this database (which I developed and
maintain
for an organization to which I belong). I have implemented a daily backup
procedure which will keep each day's version, rather than overwriting the
previous day's backup with the current one.

Best,
Bruce

Bruce

Hey, you can always pretend. grin

I suggest you download QuikSync freeware. It will save you a lot of grief
and lost work if you blow something up. It's no longer available through
Iomega, but I've seen it available elsewhere.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/M..._Professionals




"Brucels" wrote in message
...
I can't blame it on an IT department, Bill, since this is work I do on my
home computer on a volunteer basis.

Bruce

"Bill Mosca" wrote:

Excellent idea, Bruce. Our IT department keeps daily backups for a week
on
my Access databases which is more than long enough. My SQL Server
databases
have at least a month's worth of backups should the need arise.

It really surprises me that your guys overwrite everything nightly. I've
never worked in a place that did that.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/M..._Professionals




"Brucels" wrote in message
...
Thanks to everyone for their advice. After trying a number of the
suggestions
with no success, I had to break down and spend money (fortunately, not
my
own) for some recovery software, which worked pretty well, although not
all
of the queries survived.

The main thing I have learned from this exercise is that I need to set
up
a
different system for backing up this database (which I developed and
maintain
for an organization to which I belong). I have implemented a daily
backup
procedure which will keep each day's version, rather than overwriting
the
previous day's backup with the current one.

Best,
Bruce

Thanks for the davice, Bill. I am already using Karen's Replicator, which I
like for its simplicity. I added a job which backs up this particular
database every night, but does not overwrite the previous version. From time
to time, I will have to clean out older versions, but at least I will always
have a previous version to go back to to. I now need to review what other
files need to have the same type of backup.

Bruce

"Bill Mosca" wrote:

Bruce

Hey, you can always pretend. grin

I suggest you download QuikSync freeware. It will save you a lot of grief
and lost work if you blow something up. It's no longer available through
Iomega, but I've seen it available elsewhere.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/M..._Professionals

Hi,

Thats good your problem has been solved. I would like to suggest a access
repair software for future use. If anytime your access database get corrupted
or mdb file damaged then you can repair it with the help of stellar phoenix
access recovery software. This software is able to repair forms, modules,
macros, query, tables etc. You can download demo version from he
http://www.repair-access-file.com

Thanks

"Brucels" wrote:

Thanks for the davice, Bill. I am already using Karen's Replicator, which I
like for its simplicity. I added a job which backs up this particular
database every night, but does not overwrite the previous version. From time
to time, I will have to clean out older versions, but at least I will always
have a previous version to go back to to. I now need to review what other
files need to have the same type of backup.

Bruce

"Bill Mosca" wrote:

Bruce

Hey, you can always pretend. grin

I suggest you download QuikSync freeware. It will save you a lot of grief
and lost work if you blow something up. It's no longer available through
Iomega, but I've seen it available elsewhere.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/M..._Professionals

Vish wrote:

Thats good your problem has been solved. I would like to suggest a access
repair software for future use. If anytime your access database get corrupted
or mdb file damaged then you can repair it with the help of stellar phoenix
access recovery software. This software is able to repair forms, modules,
macros, query, tables etc. You can download demo version from he

You are an employee of the company mentioned in that URL. Please be
honest about your affiliation.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/