Hello again,

I’ve decided to implement Microsoft Access’s security features, mainly because I needing to know who currently has the database open and if possible be able to date and times of visits

What I’m hoping someone can advice me with is being able to create a form that show’s everyone that currently had the database open and another form that can record past visits.

I know we can go into the code and enter “?CurrentUser” and see current users within the database.

Any help would be greatly appreciated

Thanks

Corey

Hmmm, here is what I would do to just track visits.

Create a table that stores UserName and DateVisited.

Then on your main form that opens when you open the database, on the On Load or On Open event, capture:

Dim stUser As String
Dim dtDate As Date

stUser = CurrentUser
dtDate = Now()

Then pass them to the table

In this what you want? Or do you want to know who is creating and modifying records in your database?

HTH




mmcdonal