invalid path for split database

[jrlh]

I have a split database. Unfortunately, when the database
was split, I saved the back-end tables to my hard drive.
The front-end data entry form is located on our local
network. The problem with this is that I am the only one
able to enter data in the form, because the form is linked
to the tables in my hard drive. If I try to access the
data entry form using someone else's login, it does not
work. Is there a way to change the directory for the back-
end tables once they are set up? I would like to have the
back-end tables located on the network along with the
front end.

Thanks,

Jennifer

 

[Douglas J. Steele]

You can used the Linked Table Manager (depending on what version of Access
you're using look under Tools | Add-ins or Tools | Database Utilties), or
you can add code like the sample in
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

 

[Jamie]

Hi Jennifer,

You could try this:

1. Create a backup of the front-end and open it. (work on a back-up just in
case something goes wrong)

2. Select each linked table in the database window and delete it.

3. Select File - Get External Data - Import from the main Access menu and
browse to your back-end database.

4. Select all the required tables and import them. (After import you
essentially have an mdb that hasn't been split.)

5. Split your database as you did before this time placing the back-end on
the network. I would also suggest that when you select a folder for your
back-end that you do so via your network neighborhood rather than via a
mapped network drive. Using mapped network drives can lead to problems when
drive letters vary across the network.

6. If all has gone as planned then you should be able to distribute a copy
of this front-end to each user and they should all be able to enter data
etc.

Regards,

Jamie
www.jamiessoftware.tk

 

[jrlh]

I have tried using the Linked Table Manager, but it still
is not working. I have updated the path for the table in
the Linked Table Manager to the local network drive (as
indicated in the parentheses behind my table name). I
have also moved the file from my hard drive to the
network, but when I click on the data entry form, I still
get an error message stating that it is trying to find the
file on my hard drive. I'm not very adept at
reading/using VB code, so I think that figuring out a way
to to this with the Linked Table Manager is the best
option. If you have any further suggestions, I would
really appreciate it. I'm pretty new at this, so if you
can be as descript as possible it would help a lot. FYI -
I have Access 2000.

Thanks!

Jennifer

 

[jrlh]

Thank you so much! It worked like a charm!

-----Original Message-----
Hi Jennifer,

You could try this:

1. Create a backup of the front-end and open it. (work on a back-up just in
case something goes wrong)

2. Select each linked table in the database window and delete it.

3. Select File - Get External Data - Import from the main Access menu and
browse to your back-end database.

4. Select all the required tables and import them. (After import you
essentially have an mdb that hasn't been split.)

5. Split your database as you did before this time placing the back-end on
the network. I would also suggest that when you select a folder for your
back-end that you do so via your network neighborhood rather than via a
mapped network drive. Using mapped network drives can lead to problems when
drive letters vary across the network.

6. If all has gone as planned then you should be able to distribute a copy
of this front-end to each user and they should all be able to enter data
etc.

Regards,

Jamie
www.jamiessoftware.tk




.