Back end/Front End

[Luciano]

Hi,
I wish to have a Back end/Front End approach of my Access 2007 database.
I linked my tables with the Split-Wizard. I guess I have some other actions
to do, because it doesn't work. May-be, I have to modify some VBA-code so
that Access can approach these linked tables?

I wrote some code in a global module:

Sub OpenReservationsQry()
Set ws = DBEngine.Workspaces(0)
Set db = DBEngine.Workspaces(0).Databases(0)
Set qrReservaties = db.OpenRecordset("tblReservations", DB_OPEN_DYNASET)
End Sub

Public Sub OpenFlights()
Set ws = DBEngine.Workspaces(0)
Set db = DBEngine.Workspaces(0).Databases(0)
Set tbVluchten = db.OpenRecordset("tblFlights", DB_OPEN_TABLE)
End Sub

 

[Dale Fye]

Should be no code changes required.

Have you moved the backend database to another location on your computer or
network (since you did the split)? If so, you will need to run the Linked
Table Manager (not sure where you find this in 2007) to point the front-end
to the backend.

Next, I would check to see that all of the tables that need to be linked are
linked.

HTH
Dale