Software

Ask something
Discussion Locked

Access 2000 DB will NOT open

0 helpful
8 replies

by ideafixer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an access 2000 Database I recently upgraded from 97. It worked fine for a few hours then stopped working. What I mean is, when you double click on the database icon, nothing happens.

I tried:

Rebooting client machine
Importing from a databse to the database - Nothing Happened
Renaming the file
Repair
Detect and repair
Renaming the file

Any ideas?

8 replies

by linni_babii

I think you should just uninstall the whole program then installing it again, if that still don't work then i suggest you back up any data and format the computer.

by richtee

When a Access 97 mdb is converted to Access2K it can be renamed and saved in a different location. If the 'icon' you are double clicking is actually a shortcut, it may not be pointing to the new Access2K mdb.

Launch Access2K | File | Open | Locate the CONVERTED mdb from Windows Explorer and try launching it from this window.

Hope this helps.

by sue.ritter

No need to uninstall and reinstall. I have this same problem sometimes because I run Access 97 and 2000. If you used to run 97 the link is probably trying to open your DB in 97 which isn't there anymore. Launch 2000 and open your DB, then close it and try your link.

by ideafixer

I tried all of the suggestions. Nothing worked. I used SQL/Server to import the main tables then used a back up copy of the database that worked. I updated the tables in that backup copy and deleted the problomatic database. It has been 1.5 daysand the database has been running smoothly

This discussion is closed to new replies.