472,144 Members | 1,940 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,144 software developers and data experts.

How to define the path to the linked tables in MS Access 2007

3
I have a database written in MS Access 2.O that i'm intend to convert to MS ACCESS 2007.
The database is a multiuser application which consist of a application database as the frontend and a Data Database as the backend. In my MS Access 2.0 program the code is present to make the link between the data database on the backend and the application database on the frontend. Both computers are part of a local network. I know that MS Access 2007 can arrange the splitting of my database in a data database and a application database, but how do we make the link from de frontend to the backend with code in MS Access 2007, as done in my M Access 2.0 version?
Is the following a better solution?
Put the datatables in a sql server database and make the connection from the application database to the data database in the sql server ?
What the connection looks like in this situation?
Jul 17 '07 #1
1 2990
ADezii
8,830 Expert 8TB
I have a database written in MS Access 2.O that i'm intend to convert to MS ACCESS 2007.
The database is a multiuser application which consist of a application database as the frontend and a Data Database as the backend. In my MS Access 2.0 program the code is present to make the link between the data database on the backend and the application database on the frontend. Both computers are part of a local network. I know that MS Access 2007 can arrange the splitting of my database in a data database and a application database, but how do we make the link from de frontend to the backend with code in MS Access 2007, as done in my M Access 2.0 version?
Is the following a better solution?
Put the datatables in a sql server database and make the connection from the application database to the data database in the sql server ?
What the connection looks like in this situation?
The easiest way to Link to an External Database with code is via the TransferDatabase Method of the DoCmd Object. Sample code is posted below.
Expand|Select|Wrap|Line Numbers
  1. 'The following code dynamically Link to the tblTest Table in C:\Test\Test.mdb.
  2. 'It will be called tblTest_New within the Current Access Database.
  3. DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\Test\Test.mdb", acTable, "tblTest", "tblTest_New"
Jul 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by mukeshhtrivedi | last post: by
7 posts views Thread by franc sutherland | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.