[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • 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 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
 
Armen Stein - Microsoft Access MVP since 2006Commented:
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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