Move Database

D

Donald Jacobs

I created a database (table) and it got stored in My Documents folder.
I want to store it in a folder under the My Documents named Access
tables. I moved it there and now Access cannot find it when I try to
open it. Obviously I did something wrong. I've moved it back to its
original location and now it is accessed. However I would like to get
in under the Access tables. The save as option is grayed out.

Can anyone give me some instructions on how to do this other than
starting all over.

Don Jacobs
 
A

Arvin Meyer [MVP]

Depending upon your version, go to file open and navigate to the new
location.
 
D

Donald Jacobs

Thanks for the pointer. I tried that earlier (I think) with no success.
However this time it worked. I also found out by snooping around how
to stop the Microsoft Access dialog box from being displayed.

One additional question. How do I delete entries in the Microsoft
Access dialog box which are no longer on my computer.

BTW, I have access 2000 running under XP with SP2.

Thanks. Don Jacobs
 
A

Arvin Meyer [MVP]

Donald Jacobs said:
Thanks for the pointer. I tried that earlier (I think) with no success.
However this time it worked. I also found out by snooping around how to
stop the Microsoft Access dialog box from being displayed.

One additional question. How do I delete entries in the Microsoft Access
dialog box which are no longer on my computer.
Click to expand...

The easiest way is to open current databases until you've move the offender
off the list. If you are familiar with the Registry, you can also edit the
registry to remove them. They should be in

HKCU\Software\Microsoft\Office\8.0\Access\Settings\MRU1 through how many you
have defined. Be careful though "the registry is a place for gurus and
fools"
 
D

Donald Jacobs

Thanks for the info. Since I fall in the "fools" category I'll just let
them alone.
Don Jacobs
 
Top