back end server requirements

[Krazy Darcy]

Hi,
I am looking at splitting my database and having task oriented front ends ie
for Art work details entry, Running searches/queries, cataloging props etc.

My questions are 2:
1. What software does the machine hosting the back end require - does it
need MS access running on it ?
2. how easy is it to change the linking of front end to back end if I
shift the back end and can it be done relativly easily. At the moment the
whole "kit&caboodle" is on one machine but may later the back end may be
shifted to a differant machine off my graphics workhorse

thanks for your time.

 

[Tom Wickerath]

1.) No.

2.) You can relink manually (Tools > Database Utilities > Linked Table
Manager) or you can implement a VBA based solution to automatically relink
tables:

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

You might want to check out this article:
Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________