If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
Table 'MSysAccessObjects' already exists
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 |
#13
|
|||
|
|||
Table 'MSysAccessObjects' already exists
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 |
#14
|
|||
|
|||
Table 'MSysAccessObjects' already exists
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 |
#15
|
|||
|
|||
Table 'MSysAccessObjects' already exists
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/ |
|
Thread Tools | |
Display Modes | |
|
|