Copying a split database

[Guest]

Hey all,

We have a split Access database working on a network drive for a health
authority. I've been asked to extend the database to the rest of the trust
but each of the other 4 boroughs must have their own copy of the database.
This is the condition they've set due to sharing information etc.

Anyway I've tried copying the database and setting it up but I keep getting
a message referring back to the original BE. I've even deleted the old links
and created new ones, same results.

Please help me I'm at the end of my temper.

Ian

 

[Arvin Meyer [MVP]]

The original developer may have used code to make connections and hardcoded
the path. Go into one of the code modules (any one) and type the name of the
back-end being referred to in the Find dialog (Edit ... Find) after setting
the Search option to Project. You should be able to find it then and change
the code to the new path.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access