Database Dillema

[Rob Brown]

Hi.

I'm building a database application and want to be able to perform security related admin tasks from the front end.

The back-end is an Access database and the front end is VB5.

I want to have a form within my project which allows members of the admin group to perform the following tasks:

Change a password (Current User Only).

Add a new user.

Delete a user.

I also want to be able to present a form at startup requiring the user to log-in.

This is my first time database programming so any help would be much appreciated.

Best Regards.

Rob Brown.

[lenin]

Rob,
there is a lot here to answer. I will provide a brief overview.

To connect to a database you should probably use a DSN ( Data Source Name ).

Once oyu establish a connection you can build up an SQL string based on the content of the form, so, for example if the admin login is

select * from admin where username = "name" and password = "pasword"

This can be submitted as a command object ( not sure if this is available in VB5 ), which will return a recordset.

If the count on the recordset is > 0 you know you have a valid login.

sorry for the brevity of this, I'm not familiar with what is available for VB5. Perhaps a quick look at the database hints on this site nay be a starter.

Lenin.