HELP..Unable to open database after unsuccessful backup

[Guest]

We are using Access 2003 over a network; all three computers are Windows XP
Pro SP2 and our database is not split (I now know that this is a very bad
idea). I was attempting to backup our database with the tools menu option;
and the network was interrupted. The backup failed and Access crashed. I
tried to re-open the database and I received the following error; "Microsoft
Access was unable to create the database window. Please upgrade to a newer
version of Microsoft Internet Explorer". I have tried to open the database on
all three computers and I receive the same message on all. I do have a
backup; but from 10 days ago; so I am trying to find out if there is another
solution. Any help would be greatly appreciated!! Thank you.

 

[Todd Shillam]

We are using Access 2003 over a network; all three computers are Windows
XP
Pro SP2 and our database is not split (I now know that this is a very bad
idea). I was attempting to backup our database with the tools menu option;
and the network was interrupted. The backup failed and Access crashed. I
tried to re-open the database and I received the following error;
"Microsoft
Access was unable to create the database window. Please upgrade to a newer
version of Microsoft Internet Explorer". I have tried to open the database
on
all three computers and I receive the same message on all. I do have a
backup; but from 10 days ago; so I am trying to find out if there is
another
solution. Any help would be greatly appreciated!! Thank you.

Try creating a new MDB file and import tables from the corrupted
file--sometimes this works. Then you can restore your old application from
the backup and re-import the tables from the new MDB--walla!

Good luck,

Todd

 

[Guest]

Thank you Todd! I have a stupid question; when importing and exporting the
tables; are the forms and queries also imported and exported? I am pretty
sure that the tables are the core and the other items are linked to the
tables; but what if your tables aren't correctly related? Thankx again!

 

[Todd Shillam]

Thank you Todd! I have a stupid question; when importing and exporting the
tables; are the forms and queries also imported and exported? I am pretty
sure that the tables are the core and the other items are linked to the
tables; but what if your tables aren't correctly related? Thankx again!

I'm assuming your program was working and there haven't been any changes
(structurally) since the file went belly-up. Provided you haven't change the
queries and relationships, it shouldn't matter--the relationships, queries,
and forms, are still there in your backup if you haven't change anything in
the interum. Otherwise, no--you don't import forms, queries, or other
database objects (just the tables). All you should need to do is delete the
tables int the restored file from backup, then import from the new file's
tables.

Best regards,

Todd

 

[Ken Snell [MVP]]

From your original post, you say that the database was not split. Therefore,
you will need to import all the objects (tables, queries, forms, etc.) from
the "corrupted" database into a brand new database.

That will be much easier on you than trying to reload data from the
"corrupted" file into a backup copy of the file.