Database Security

[paulreed]

Have been looking at the excellent sample database - Database Security, but am unable to run it on the 'corporate' system at work as a reference is made to 'Microsoft DAO 3.6 Object Library' which is not available.
Most of the database functions fine, except it does not record the 'log-off' times within the table.

Is there another way of acheiving this function without using external libraries?

 

[spacepro]

Have you tried to uncheck dao 3.6 and select dao 3.51 object library instead?

 

[Pat Hartman]

Or DAO 4.0

 

[paulreed]

The code includes the line;
'Requires the reference to Microsoft DAO 3.6 Object Library to be set.'

Is there some action I need to take? If I look at 'references' from the tools menu, I have DAO 3.6 installed and ticked, but the 'logged out' data is still not being recorded in the tblLogTimes table

 

[o1110010]

The code includes the line;
'Requires the reference to Microsoft DAO 3.6 Object Library to be set.'

Is there some action I need to take? If I look at 'references' from the tools menu, I have DAO 3.6 installed and ticked, but the 'logged out' data is still not being recorded in the tblLogTimes table

Maybe move DAO 3.6 as high on the list of references as you can. Then have a go at it.

 

[paulreed]

I have now sorted out the Reference, by deselecting ver 3.6, and selecting 3.5 as above, but when I try to do any function within user password setup, the code errors with; Complile Error - method or data member not found.
and highlights;

Private Sub List10_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[UserID] = " & Str(Me![List10])
Me.Bookmark = rs.Bookmark

'Recordset' is highlighted in yellow.

 

[Pat Hartman]

It is better to go to a newer version than an older one. You are running into code that uses a feature of 3.6 that is not supported in 3.51. If you don't have Jet 4.0, you can download either 3.6 or 4.0 from the Microsoft download site.

 

[spacepro]

I have had another look at the sample db and the code doesn't write the time logged out to the userid. I haven't actually used this sample but if you get stuck, post the code in the modules & vba forum or post to this thread, maybe others can help. I will have a look at the code and see if I can help, alternatively do a search of the forum and you will find other sample db's.


BTW set your reference back to dao 3.6.

Andy

 

[paulreed]

Spacepro

I'm pleased that you too are experiencing the same difficulty, I thought it was just me!!
I have looked at a number of similar samples, but this seems a really comprehensive and 'user friendly' solution - its just a shame that this bug prevents it from running 100%.

If you, or any other member can find the bug, I would appreciate your postings.
I have attached the security database for those who don't have it.

Thanks

Paul Reed