?
Solved

Access 2007 Link table Code

Posted on 2012-03-20
5
Medium Priority
?
167 Views
Last Modified: 2014-12-11
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
Comment
Question by:Spikemom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 75
ID: 37744539
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
 

Author Comment

by:Spikemom
ID: 37744586
Thank you, I will try this tomorrow and let you know. One thing, do I need to make an ODBC connection
0
 
LVL 75
ID: 37744611
Not if you are connecting to an Access database ...?

mx
0
 
LVL 9

Accepted Solution

by:
Armen Stein - Microsoft Access MVP since 2006 earned 2000 total points
ID: 37749036
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
 

Author Comment

by:Spikemom
ID: 40493928
I've requested that this question be deleted for the following reason:

No longer using this system
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question