By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

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

P: 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
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,597
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.