-
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.
-
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.
