Access 2010 Runtime - Link to backend database

[nikmav]

Hello. I'm very new to Access and having trouble sourcing information that makes sense.

I have a database that is split into a front and back end.

The back end is to reside on a shared network location (yet to be determined but we'll call it \\SERVER\DBSHARE for now).

The front end will be installed on the client workstations.

The Client workstations have mixed versions of Access 03 and Access 07 but all have the Access Runtime 2010 installed.

The problem is when you open the front end it spits an error out saying it can't locate the backend. As this is the Runtime version there is no Link manager to set the path.

I'm assuming (and this may be wrong) that there is a way, somewhere be it the package manager, code, pathfile to be able to say something like "Path to Backend is \\SERVER\DBSHARE\be.accdb"

Does anyone know if there is some way to set the path so that the backend can be linked when using Access Runtime 2010?

Thanks

 

[JamesMcS]

You'll have to use the full version of Access to create linked tables to the network DB, then it should work OK in the runtime.

If you're unsure of the location of the BE, you can set the Connect property of a linked table using VBA, but that's another story....

 

[nikmav]

I thought that might be the case. So you mean install the full version access on one machine split the database and save out the BE to the network drive then copy that front end to the rest of the workstations?

 

[JamesMcS]

Yeah, or just use the machine you used to develop the DB in the first place - either way, full Access is the only option here.