Split Database

[Kevin O'Connell]

I'm working with a customer that needs changes to an Access Application and I'm current mapping out potential improvements. I have a copy of their Access Application but its 'split' into 2 databases as it's a multi-user envirnoment.

In real operation, the split client db (Quotation.mdb) links to a server db (Quotation_be.mdb).

I need to make the application work on my laptop and therefore need to change the mapping in the client so that it recognises that it's associated buddy is now on my laptop and not of the server. The original designer is gone and I just need to view the Application locally.

When I try to launch the client from my laptop, it won't open and displays the message: 'R:\New Quotation\Quotation_be.mdb' is not a valid path.

How do I edit the client to change the pointers/links??

 

[Elana]

Hold down the SHIFT key as you are opening the database. Then once you're in the database window, re-link the tables using the Linked Table Manager.

 

[Robert Dunstan]

You need to use the 'Linked Table Manager'

In A2K it's in Tools---->Database Utilities. Click 'Select All' and tick 'Always prompt for new location'. The wizard will then ask for the new location of each table and refresh the links.

I also noticed that the link is mapped to a network drive. You may want to consider using UNC for the link. This way your customer will not need to have their pc's mapped to a specific drive. When the wizard asks for the filename above, instead of selecting the network drive enter it as \\ServerName\New Quotation\Quotation_be.mdb. Just substitute 'ServerName' for the real computer name.

Just a thought though

HTH
Rob

 

[doss]

Also, I would not advise that you just go in willy-nilly making changes to the original database....

Usually what we do is have our "Working Copy" which contains all tables, queries, forms, reports, etc. Once we are done and convinced that everything still works we split the database and put it up on the network.

 

[Kevin O'Connell]

Many Thanks

Many thanks.

The SHIFT got me in and the rest was as ye said.
I now have a full working copy on my laptop.

The additional advice is also much appreciated.

Kevin