Solved

Access 2007 Link table Code

Posted on 2012-03-20
5
133 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
  • 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 500 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

919 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now