• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

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.
0
Spikemom
Asked:
Spikemom
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
Not if you are connecting to an Access database ...?

mx
0
 
Armen Stein - Microsoft Access MVP since 2006PresidentCommented:
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
 
SpikemomAuthor Commented:
I've requested that this question be deleted for the following reason:

No longer using this system
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now