Help Split Data base?

  • Thread starter Thread starter Russell Brandl
  • Start date Start date
R

Russell Brandl

Help,
OK, I split an MDB file located on a server. Made the FE a MDE. Then made a
Shortcut to the original FE on the server machine located on a client and
then copied the MDE file to the client.
It seems to not update the data in a central location?
If I launch the database from the server MDE, Client copy of the MDE, or the
Shortcut to the FE MDB file the data is not updated to all??
Thanks
Russ
 
Help,
OK, I split an MDB file located on a server. Made the FE a MDE. Then made a
Shortcut to the original FE on the server machine located on a client and
then copied the MDE file to the client.
Click to expand...

What is the purpose of the shortcut? The user should be using their
own copy (preferably mde) of the frontend; the original .mdb frontend
should be kept for modifications, but the users should never see it.
It seems to not update the data in a central location?
Click to expand...
If I launch the database from the server MDE, Client copy of the MDE, or the
Shortcut to the FE MDB file the data is not updated to all??
Click to expand...

Open the frontend .mdb and check: use Tools... Database Utilities...
Linked Table Manager. See if it can refresh the links to the backend.
If the linked tables are linked via a mapped drive letter, every user
must use the SAME drive mapping - it may be preferable to use the
Linked Table Manager, check the Always Prompt For New Location, and
navigate to the backend through the Network Neighborhood. This will
link to \\server\path\filename rather than to K:/path/filename, and
will work on any machine with access to the backend, no matter the
mapping.
 
Back
Top