using the network

S

sq

I setup my program with security group and users, but it will not work on the
network from a different computer. What am I doing wrong?
 
S

sq

I read everthing that was on that site but either missed it, or just can't
understand it. I will try to explain my situation a little better. I now have
a data base, that five other people can get into from there computers. I
wanted to be able to track users and hopefully track the changes they made in
the data later. The data change is when someone checkout a record, or checkin
the record, very simple. Each person has a shortcut to the database from
there computer. It works very well. Now that I have set up security you can
not open the database from another computer on the network. I know it must
be simple but I can't figure it out. Thanks for any help.
 
T

Tom Wickerath

I suspect that you are not correctly joined to your workgroup infomation file
(*.mdw) when attempting to open your database from another computer.
Hopefully, you created your own .mdw file, instead of making changes to your
System.mdw file. Are you including the /wrkgrp switch plus the full path to
the .mdw file in the target of a shortcut used to open your application?
I wanted to be able to track users and hopefully track the changes they made in
the data later. The data change is when someone checkout a record, or checkin
the record, very simple.
Click to expand...

You can certainly accomplish this goal without the need to implement ULS
(User Lever Security) in Access. You simply need to use code like this:

API: Get Login Name
http://www.mvps.org/access/api/api0008.htm

to get the user's NTUserID. Then, you use code to insert this value into a
field for each record that the user checks in or out. If you need to maintain
a history of all users activity, as opposed to the most recent activity, then
try implementing this type of method:

Creating an Audit Log
http://allenbrowne.com/AppAudit.html

If you still want to go with the ULS method, that's fine. My suggestion is
to repost your question to the Security newsgroup. There are others there who
are more likely to be able to diagnose the problems more quickly than I can,
since I tend to avoid using ULS all together. Here is a link to that
newsgroup:

http://www.microsoft.com/office/com...spx?dg=microsoft.public.access.security&exp=1

Just be aware that support for Access ULS has been dropped in Access 2007,
at least in the new .accdb file format (which you must use to get all the new
features).


Good Luck,

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top