469,950 Members | 1,381 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

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 2873
ADezii
8,800 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
By using this site, you agree to our Privacy Policy and Terms of Use.