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