Link to home
Start Free TrialLog in
Avatar of Spikemom
SpikemomFlag for United States of America

asked on

Access 2007 Link table Code

I have a database called Contract Review. I split the dbase (tables out ) . I now want to link them in (code) when the database opens. Not sure of the code . This is a multi user dbase and I'm hoping this will speed it up.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Well, here is the df-facto standard code for relinking:

http://access.mvps.org/access/tables/tbl0009.htm

You can tweak it as necessary ...

mx
Avatar of Spikemom

ASKER

Thank you, I will try this tomorrow and let you know. One thing, do I need to make an ODBC connection
Not if you are connecting to an Access database ...?

mx
ASKER CERTIFIED SOLUTION
Avatar of Armen Stein - Microsoft Access MVP since 2006
Armen Stein - Microsoft Access MVP since 2006
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I've requested that this question be deleted for the following reason:

No longer using this system