Link to Back End via Code

[Guest]

I have a fully functional Access 2002 database I have developed. It is
normalized, split with front end and back end. My client wants to give the
user’s the option to put the Back end database on a shared server and then
have the front end installed on each workstation.
User's will not have access to

My thought was to have the front end ask the user the very first time the
location of the backend. So this will accommodate both the standalone users
and the shared server users. Is this possible and where can I learn more
about this?

I'm not an expert in VB code, so a simple reliable solution would work best
for me.

 

[Marshall Barton]

I have a fully functional Access 2002 database I have developed. It is
normalized, split with front end and back end. My client wants to give the
user’s the option to put the Back end database on a shared server and then
have the front end installed on each workstation.
User's will not have access to

My thought was to have the front end ask the user the very first time the
location of the backend. So this will accommodate both the standalone users
and the shared server users. Is this possible and where can I learn more
about this?

I'm not an expert in VB code, so a simple reliable solution would work best
for me.

This is about as simple as a complete solution as you can
get unless you teach the users to use the Link Table
Manager.

http://www.mvps.org/access/tables/tbl0009.htm