Access

[Adam]

How I can change, give and reset password and give access to users by
VBA for the win2000
For example, I have Data base in the Access wit Users and I can give
and change autorize to sth in the Windows 2000

 

[Guest]

hi,
window 2000 is an operation system not an application.
are we talking about excel? granting permissons like
access?
no
you can password protect an excel file.
On the File menu, click Save As.
On the Tools menu, click General Options.
In the Password to open box, type a password, and then
click OK.
Passwords are case sensitive. Type the password exactly as
you want users to enter it, including uppercase and
lowercase letters.
In the Reenter password to proceed box, type the password
again, and then click OK.
Click Save.
If prompted, click Yes to replace the existing workbook
with the open workbook.

 

[Kevin]

If your asking ..."you can use an Access database to
authorize users trying to access your spreadsheet", yes
you can. You can query an Access DB using DAO methods. I
have done a fair amount with this in Access, but not Excel
so I am not sure what all you would have to do. Search
Help using the keyword SQL.

To check for an authorized user, popup an Input box then
after the user enters the password, query the database and
then compare the users entry against what the query brings
back.

Hope that helps!

Kevin

 

[Jamie Collins]

If your asking ..."you can use an Access database to
authorize users trying to access your spreadsheet", yes
you can. You can query an Access DB using DAO methods.

Using ADO and the OLEDB 4.0 provider for JET in Excel VBA code, one
can execute DDL sql relating to security: groups, users, passwords.
See:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp

Jamie.

--