youf kind help please

[Guest]

i have my own database which currently i am the only one who is using . i
plan to share it with my collegues , using "user level security wizard".what
else i have to do in order for others to be able to open the same database
from there pc's.

acutally , i have tried one thing , after making the work group thru " user
level security wizard". i kept the database in a shared folder in my computer
.. but , when my collegue wanted to open this folder it says, you dont have
permission etc..but before this he used to use the same folder in my pc to
open other files.

what should i do, i need your help please.

 

[MacDermott]

Is your database something you need to protect from people who have access
to your computer, but shouldn't see/use the database?
If not, skip the security...

 

[Guest]

Is your database something you need to protect from people who have access
to your computer, but shouldn't see/use the database?
If not, skip the security...

Actually, for each pc there only one user, i.e. i am the only one using my
pc , my colleuges got pc for each one.the only thing is that , i want each
user to log in in his name in order to keep record on who made changes or who
added somthing.

 

[MacDermott]

In that case, I'd suggest you use the fOSName() function (you can find it at
www.mvps.org/access/API) to capture the name of the machine from which the
change is made.
Access security is over-kill for your purpose.