Discussion Locked

Access 2000 data gone

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Yes I know I have done a foolish thing, but I renamed an Access database (from 2000-01 to Bookings) and now I can't open the darned thing. The icon has changed to a windows type icon and Access says it can't find it when I ask it to "open as" Access. In properties it is called a "file". I have tried everything I can think of. When I open in wordpad, the data is unreadable. Can this be fixed?

3 replies

by jimbb

Looks like the extension is gone. An Access file is supposed to be called something.mdb, bookings.mdb in your case.

In case you don't see the extensions, in your Windows Explorer select view|options, and uncheck "Hide MS-DOS file extensions" (for win9x, I'm not sure of the correct menus for W2000 and so)(but a similar option is there).

Jim

by kateynoodle

Thanks, I actually worked this out after I got back to my desk! It has been a tough week and I was really tired yesterday when I changed the name and really tired today when I couldn't open it!!!
Thanks anyway and enjoy your points!!

This discussion is closed to new replies.