>First off, I want to apologize for posting this question here...I know this is a FoxPro forum. I am just hoping that someone here can help me with a few questions.
>
>I have accepted a contract for the development of a small system that I will develop after business hours. I am going to do this in Access. Why in Access? Well, we had decided on VFP, but another business that might some day merge with the client has a system in Access; so for possible future integration, among other reasons.
>
>Anyways, I have a few basic questions: In Access, it appears that all forms, reports, data, etc. is self-contained in a MDB file. What is done for multi-user access? Is the MDB run off the server computer by all workstations? Can I access data from multiple directories? For example, have large look-up tables on the local drive and the main data on the network server.
>
>Thanks for any info,
>
>Joe

Yes, put the MDB file on the server and all users will run from it. It is a good idea to split the application into at least two MDB's, one for the data and one for the code (forms, menus, reports, queries, etc.). This way, you can replace the MDB that contains the code -- say, to update a form or add a report -- without having to replace the data too [g]. Access provides an easy way to link the forms, reports, etc. to an external MDB.

HTH,
Rick