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.
SpikemomAsked:
Who is Participating?
 
Armen Stein - Microsoft Access MVP since 2006Connect With a Mentor PresidentCommented:
Hey MX, I'd like to think that our free J Street Access Relinker code will become the new defacto standard.  And no tweaking necessary.  :)

http://www.JStreetTech.com/downloads

And yes, the ODBC comment is throwing me off too.  Spikemom, if you are just linking to a split Access back-end, you don't need ODBC.  It's just a linked table that you set up the first time in Linked Table Manager.

Cheers,
Armen
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
SpikemomAuthor Commented:
Thank you, I will try this tomorrow and let you know. One thing, do I need to make an ODBC connection
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not if you are connecting to an Access database ...?

mx
0
 
SpikemomAuthor Commented:
I've requested that this question be deleted for the following reason:

No longer using this system
0
All Courses

From novice to tech pro — start learning today.