Saving new records to the database

[C.Garber]

Hello

I have created a database for our sales persons to keep their clients on. I created a master table to collect all of the data as to create a merged database so we can ctrl find to check if a new customer belongs to a sales person. I created a form for each sales person that reports the information entered to a query which reports to the "merged table". The database is in a network shared folder. All works well...however, when more than one person is in the database, the information entered by the person that opened it is the only information the database will save. If other users try to enter information "through their form" an error message states that the user does not have privilages and the information entered may be lost. How can I or can i arrange for more than one person to enter data at the same time?

 

[Larry Linson]

Without knowing what you have, and how you have it structured, it is
difficult to know what you have done that PREVENTS more than one person from
entering data at the same time. I suspect that it is a matter of the design
of your database because there is neither an inherent limitation nor a
"switch" to throw that allows/prevents multiuser updates.

For good general information on multiuser issues, there's an introductory
presentation on Access in a Multiuser Environment that I did for my user
group that you can download from http://appdevissues.tripod.com. It will
identify topics that I thought worthwhile to discuss, and a bit more.

The best collection of detailed information and links on the subject of
Access in the multiuser environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

If you would follow up here with more detail on the structure of your data
and your application, perhaps someone would be able to offer some concrete
suggestions.

Larry Linson
Microsoft Access MVP