Move Database

[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

 

[orange]

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

Create a subfolder in your My Documents folder called Access Tables.
1.
Using Windows Explorer, or similar, Go to My Documents where your database is located now.
Select the database file such as YourDatabase.mdb; go to the Edit option on Toolbar,
Copy to Folder option, then when given the option Select the My Documents\Access Tables folder
and click OK.

or
2.
Having created your Access Tables sub folder, go to windows explorer and expand the My Documents
folder and sub folders list.
Highlight your filename.mdb where it is now, keep the mouse button down and drag the file to
the My Documents/Access Tables folder

When you next go to Access to Open your database, DO NOT look for the File in the FileList.
Go to More and select the existing database (new location) by going to My Documents, then to sub folder Access Tables then select your database.mdb.

Once you open it and save it, it will be available in the proper location in the File list.
Good luck.

 

[Arvin Meyer [MVP]]

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

 

[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

 

[Arvin Meyer [MVP]]

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.

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"

 

[Donald Jacobs]

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