 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / November 2006Partially Converted Database
I recently went to synch my database to the network. When this happened, my computer shutdown. When I restarted the computer and went to reopen my database, I received an error that my database is in an unexpected state. It states that the database has been converted from a prior version of Microsoft Access using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu. This has left the database in a partially converted state. Does anyone know of this? How can I revert this back to its original state? Try creating a new (blank) database, and importing from the problem one: File | Get External  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. >I recently went to synch my database to the network. When this happened, my > computer shutdown. When I restarted the computer and went to reopen my [quoted text clipped - 8 lines] > its > original state? Thanks for your response. I just tried that but it still won't open that partially converted database. > Try creating a new (blank) database, and importing from the problem one: > File | Get External [quoted text clipped - 11 lines] > > its > > original state? You could try Microsoft stand-alone utility: http://support.microsoft.com/kb/273956/en-us No promises, but worth a shot. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Thanks for your response. I just tried that but it still won't open that > partially converted database. [quoted text clipped - 17 lines] >> > its >> > original state? Ok, so I tried the stand-alone utility and I am able to recover some data but I am not able to recover the most recent. Is there another way to recover this data? I even tried to access the replicated database and because it was affected by the synch., I am still not able to open it. If I could save and access the replicated version, I would be able to get access to the lost data. I have spent so much time on this database that I really don't want to have to restart the design and data entry from August. Thanks again for your help on this. > You could try Microsoft stand-alone utility: > http://support.microsoft.com/kb/273956/en-us [quoted text clipped - 22 lines] > >> > its > >> > original state? Sounds like you have tried most of the things you can do for yourself. There are commercial repair places that may be able to help, e.g.: http://www.everythingaccess.com/ SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Ok, so I tried the stand-alone utility and I am able to recover some data > but [quoted text clipped - 41 lines] >> >> > its >> >> > original state? Thanks for your help. I actually have another question. I had my backup file which is not the most up to date version. I could potentially use this one to restart but the permissions are set to admin but I am not able to create forms and their is probably some other restrictions. In addition, I created a replica from the back up and I cannot make design changes on it. How can I change the permissions so that I could at least restart using the backup database and the newly replicated database? > Sounds like you have tried most of the things you can do for yourself. > [quoted text clipped - 46 lines] > >> >> > its > >> >> > original state? Perhaps you could create a new, blank, unsecured database. Then open the secured one, and export the objects to the new unsecure one. You could ask in the group microsoft.public.access.security Or you may be able to get an answer from this document: http://support.microsoft.com/kb/207793/en-us SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Thanks for your help. I actually have another question. I had my backup > file [quoted text clipped - 67 lines] >> >> >> > its >> >> >> > original state? Thanks, that is exactly what I ended up doing. I still have some minor design changes to make but the data is pretty much in tact. Thanks again for your time!!! > Perhaps you could create a new, blank, unsecured database. > [quoted text clipped - 76 lines] > >> >> >> > its > >> >> >> > original state? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.