S
sweeneysmsm
I have an Access 2003 database to split into a front and back end. I expect
to use the wizard to accomplish that task. The database is on one computer on
my client’s network (no server; just networked computers).
This is my plan so if my steps are not correct, please let me know. (I’m
going to make a copy of the unsplit db just to protect myself.)
1) Use the wizard to split the database. Leave the back-end in the shared
folder. (I am assuming here that the splitting process will leave a front-end
and back-end that are linked to each other on the computer where the present
database is located.)
2) Copy the front end and bring it home where I have Access extensions
installed and a CD burner. (Workplace does not have a CD burner on the
computer where Access is loaded..)
3) Use the Access extensions to make a package to install the front end and
a runtime version of Access.
4) Install the package on each of the computers which need to access the
database from other computers on the network.
5) Please make any relevant comments on the above.
6) The other question I have concerns a desktop shortcut. I am wondering if
there is any special syntax for the Shorcut’s Target. (I know that if I have
a special workgroup [which I don’t in this case] I need to bring together the
Access application, the database, and the workgroup.] Is there anything
special I have to do with Front-End/Back-End etc in a shortcut?
Someone also very kindly shared this link with me
http://www.mvps.org/access/tables/tbl0009.htm
Do I need to use something like this if I have only one Front End and one
Back End or will the splitting wizard take care of this for me? I hope that
the latter is the case as I do not understand much of the relinking code.
Thank you for any insight you can give me.
Mary
to use the wizard to accomplish that task. The database is on one computer on
my client’s network (no server; just networked computers).
This is my plan so if my steps are not correct, please let me know. (I’m
going to make a copy of the unsplit db just to protect myself.)
1) Use the wizard to split the database. Leave the back-end in the shared
folder. (I am assuming here that the splitting process will leave a front-end
and back-end that are linked to each other on the computer where the present
database is located.)
2) Copy the front end and bring it home where I have Access extensions
installed and a CD burner. (Workplace does not have a CD burner on the
computer where Access is loaded..)
3) Use the Access extensions to make a package to install the front end and
a runtime version of Access.
4) Install the package on each of the computers which need to access the
database from other computers on the network.
5) Please make any relevant comments on the above.
6) The other question I have concerns a desktop shortcut. I am wondering if
there is any special syntax for the Shorcut’s Target. (I know that if I have
a special workgroup [which I don’t in this case] I need to bring together the
Access application, the database, and the workgroup.] Is there anything
special I have to do with Front-End/Back-End etc in a shortcut?
Someone also very kindly shared this link with me
http://www.mvps.org/access/tables/tbl0009.htm
Do I need to use something like this if I have only one Front End and one
Back End or will the splitting wizard take care of this for me? I hope that
the latter is the case as I do not understand much of the relinking code.
Thank you for any insight you can give me.
Mary