Please reply VB6

[alvarog]

Hi,
I am developing an application in VB6 accessing an Access 97 database. Now I am going to start developing the security part of the application and I have several questions:

1- Can I use access security from VB6: Adding new users, deleting, etc. Also new user groups. In other words can I control the security from VB6 the same way that I do
it from access.

2- Also I am going to need to count the number of users that are accessing the database every time a new user tries to sign on in the application. I am trying to limit the
maximum number of user to 5. (I am using dataenviroment in case you need to know).

I really hope some body can help me,

Thanks in advance…

Alvaro

To the best of my knowledge, you cannot use Access security procedures from a VB program. Normally, when I use an Access database with VB I just put a database password on the Access database and then pass the password to the database when I open the connection. This allows me to proxy the users into the database.

To keep track of the users using the database, many ways to do that. Easiest would be to simply increment and decrement a field in a table.

Hope this is of some help.