Please help

  • Thread starter Thread starter sassygirl
  • Start date Start date
S

sassygirl

I am a new user in Access. I cant usually catch on fast. But I am working for
a company and they are using MS Access 07, and they have a database designed
in 2003 they need it switched over, this database was designed by someone
else and I just have a copy of it and it keeps on looking at the old
directories it was created in. We dont want it to do that. We just want to
start using this database to start entering in our new data. Can someone
please talk the time to help me. Really would appreciate it..
 
It sounds like you migth have a split database on your hands here. Can you
tell us if the db consists of one or two files? If you have two files then
the second file needs to know where the first file resides. This is also
referred to as Backend and Frontend. The backend consists of all the tables
and the frontend consist of all other objects such as forms, reports and
queries.

To relink your db to the correct tables take the following steps:

1. Open the file where the forms etc are in (maybe you can use the shift
button to open it. Press shift and Enter). Look if you see any forms. If so
than this is the frontend.
2. Now look in the ribbon in the tab [Database tools] and click on [Linked
table manager].
3. Tou will now see a dialog that will ask you where the backend resides (in
which directory)
4. Go to that directory and doubleclick the backend file.
5. Access will now relink your tables to the new directory
6. Close the dialog

You'll only have to re-do this everytime you move the backend to a new
directory

-----
If you only have one file than there must be a hardcoded path in your VBA
modules. In that case press Alt-F11 which will take you to the VBA window.
There you can use the binoculars to do a find and replace for the 'old' path
with the new 'path' (directory).

hth
 
Back
Top