password

[Princy]

Friends,

How to reset or change the admin password of MS Access 2003 database?
(I am using VFP 8.)

I tred ALTER USER admin PASSWORD pass1 ``. This command generated an error
message "Syntax error in ALTER TABLE command"

The reason is that I tried to compact a MDB database and it does not work
with password protection. So I need to remove the password and then compact
and then set password back.

If not sure of VFP coding, it would be great if you can direct me on how to
do that in VB with some explanation.

Any help would be appreciated

 

[Jerry Whittle]

Too much work. Download the free Jetcomp 4.0 utility to compact and repair.
Under the Tools menu you can specify the User and Password before compacting.
Read all about it here:

http://support.microsoft.com/kb/295334/EN-US/