Access sharing best practice?

[DB88]

Hello,



I am new to Access database development. I would like to put the database I created on a shared drive. What are best practices? Do I need to "prepare" the database for simultaneous users?

I dabbled in Access a few years ago and recall that a database can be split (seperate the structure from the records). Is that a requirement for simultaneous users? If yes, does the database structure need to be finished? Right now we are building as we go (I know, terrible practice and not my idea)

Thanks

[burrina]

http://office.microsoft.com/en-us/ac...010279159.aspx

HTH

[June7]

Splitting is best practice for multi-user db. Each user should run their own copy of the frontend.

A db is NEVER finished.

Just don't try to change the backend while people are working with it. This is why programmers and IT staff are often night owls.

If backend changes impact frontend structure, need a means to deliver revised frontend to users. Review http://forums.aspfree.com/microsoft-...ue-323364.html