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

[odrap]

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?

[ADezii]

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.

'The following code dynamically Link to the tblTest Table in C:\Test\Test.mdb.
'It will be called tblTest_New within the Current Access Database.
DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\Test\Test.mdb", acTable, "tblTest", "tblTest_New"