> I have to unload data from a MS ACCESS data base and > reload them into a RBW > database .... > But Access DB is password protected and nobody knows > the password. > And I am not familiar with Access.
Access security is a complicated issue -- there are several different levels. What message do you get when you try to open the database? Is the user able to use the database themselves? If so, they must have rights to it, and if they don't have a database password they are probably using user level security. This type of security uses a second Access file (*.MDW, I think) to maintain a list of encrypted usernames and passwords. You need to reference this database in the shortcut that launches the database, otherwise you will get some kind of "no rights" message. If the user sent you the MDB but not the MDW file that could by your problem. If they are just using a database password, it's stored at the beginning of the MDB file in a (slightly) encrypted format. There are tools available on the internet for cracking the user level security Access databases. To get back a database password, I found some C code on the web -- let me know if you want it. [Of course, you should first make sure that the client actually owns the database and has the legal right to remove the password]. -- Larry __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
