On Mon, 5 Oct 2009 08:25:02 -0700, Fox
wrote:

Yes, this would work but the new user will not have access to relink tables.
So that is the reason for all the code. For some reason when you split the
tables you can only name a network location and you can not name a relative
path.....Got it almost working but one table does not want to
co-operate....the rest of the tables are responding to the code found but
this one little ugly step child will not co-operate! S
Thanks for your help.
Janet

Hi Janet,

If you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker at:
http://www.jstreettech.com/downloads

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

That last part about auto-relinking to a local back-end might help
you. It isn't exactly what you want, because it links to the *same*
folder as your application, but you may find it useful.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com