Carl said:
Hey...I was wondering if anyone could tell me how to allow my DB to
allow multiple users to input data. I'm currently using the security
feature, I don't know if that prevents it. Thanks!
Carl
Technically Access is multiu-user by default. You "could" simply put the file
in a shared network location and multiple people can open it and enter/edit
data.
However; technical specifications aside, it is *very highly recommended* that
shared Access applications be "split". One file that contains only the tables
is shared on the network and additional files that contain links to the tables
in the shared file as well as all of the forms, reports, queries, etc., are
given to each user and stored on their local disk drives. The split file setup
has many advantages and greatly reduces the chances of the file getting
corrupted.
Now; since you have applied user level security your users would have to use the
workgroup file you used to apply security. You could have them make that
workgroup file their default, but again that is not recommended as it forces
them to login in for all files they use, not just yours. The preferred approach
is to provide a shortcut for each user that specifies the correct workgroup file
as a command line argument...
"Path to MSAccess.exe" /wrkgrp "Path to MDW file" "Path to MDB file"
