Multiuser network access database

[abujafar]

I just completed a database that user meant to be used by one user on a single computer. I was just informed that it will be accessed from a computer on a peer to peer network and will be accessed by multiple users at the same time.

I am not accustomed to creating multi user database on a network.

Any advice on steps I should take and things I should consider will be greatly appreciated, e.g security, performance.

I am using Access 2003.

 

[Singh400]

I guess the first step would be to split the database in Front-End and Back-End. There's a tool that will do this for you (in the options menu).