User access on a company intranet

[Rick Brandt]

They do have full permissions to the folder that the front end of the
database is located but not on the backend.

Everyone should have their OWN local copy of the front end. Only the back
end should be shared.

Do I need to put the
backend in a folder that they have full access?
Yep.

If I do this do I
need to relink the tables.

Yep.

 

[Guest]

Thanks for your help everything is up and running. One last question is
there any way to log when someone logs into the database and logs out?

 

[Guest]

When you say local copy is this a copy on their desktop stored on their hard
drive or can it be in a folder that they have full permission to get into on
the server?

 

[Joan Wild]

You can create a table to hold the username, date/time in/out.

You can have a form open on startup (hidden if you like), and use the
load/unload events to write to the table using the CurrentUser() function
and the Now() function.

 

[Rick Brandt]

When you say local copy is this a copy on their desktop stored on
their hard drive or can it be in a folder that they have full
permission to get into on the server?

Could be either, but on the local drive would be better performance wise.

 

[Guest]

Do I created this table in the Secured1.mdw or in my regular database? If I
placed it in my database how will it know the user? Do you know of any code
I can look at for this? Thanks for everything, I'm still learning.

 

[Guest]

I tried to write a macro where on On Load the macro set the value for User in
my table to "Current()" and time to "Now()" but I get the following error
message "the object doesn't contain the Automation object 'sysUsageLog' (my
table). you tried to run a Visual Basic procedure to set a property or method
for an object. However, the componetnt doesn't make the property or method
available for Automation operations. Check the component's documentaion for
information. I placed the table with my other database tables. Also, is
there a way to log the computer they are using on the server?