"stephendeloach via AccessMonster.com" <u32891@uwewrote:
>I have created a database with different forms/reports on it. It will be on a
server for 2 more people to access it. My question is.. Is there anything I
may need to do/know before I put it on the server for another user to use it?
Also, while the other user is using it, I will be adding more forms and
reports to the database. Will this conflict with the information the other
user is adding?
Access 2000 and newer won't allow you to share the database while you are developing
in it.
You want to split the MDB into a front end containing the queries, forms, reports,
macros and modules with just the tables and relationships. The FE is copied to each
network users computer. The FE MDB is linked to the tables in the back end MDB
which resides on a server. You make updates to the FE MDB and distribute them to
the users, likely as an MDE.
See the "Splitting your app into a front end and back end Tips" page at
http://www.granite.ab.ca/access/splitapp/ for more info. See the Auto FE Updater
downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite nicely.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm