On Fri, Sep 19, 2008 at 9:47 PM, NoOp <[EMAIL PROTECTED]> wrote: > On 09/19/2008 08:02 AM, Mark Knecht wrote: >> Barbara, >> My associate in Australia replied overnight that there is a >> password. However I cannot figure out in Base where I enter the >> password. Where do I do that? >> >> Thanks, >> Mark >> > > Don't know, but I just opened up MS Access '97 and the help file on > passwords shows: > > <quote> > About linking tables from a password-protected database > > To link a table from a Microsoft Access database that is > password-protected, you must supply the correct password. If you supply > the correct password, Microsoft Access stores the database password with > the information that defines the link to the table. After the link has > been defined, any user who can open the database that the table is > linked to can open the linked table. When a user opens the linked table, > Microsoft Access uses the stored password to open the database where the > table is stored. If the password is changed for the database where the > table is stored, the next time the linked table is opened, the new > password must be supplied before Microsoft Access will open it. > > Microsoft Access stores the database password in an unencrypted form. If > this will compromise the security of the password-protected database, > you should not use a database password to protect the database. Instead, > you should define user-level security to control access to sensitive > data in that database. > </quote> > > Interesting... so I wondered if things had improved in a later version > and booted into a WinXP machine with MS Access 2002 and looked at help > there; same. > > So I wonder why your associate would use a passoword in MS Access to > begin with.
He didn't use a password, it's built into the program. Again, as background, I'm using a program called Trading Solutions which builds neural networks for modeling the stock market and how to trade it. Trading Solutions uses Microsoft Access *internally* to store the data. The user never interfaces with Access but we do see files in the directory, one of which is a *.mdb file. We never directly use this file, it's just there for the Trading Solutions GUI to use. I wanted to look inside. >From the information you posted above it now makes sense to me how he got the password. He looked inside the file using something other than Access and found it because it's not encrypted. Armed with that he can tell Access to open the file outside of the Trading Solutions GUI. I do not understand why he said OO can read it when it's complaining about the password, but if Base cannot ask for a database password then to me this is a Base problem. I'd probably be better off to get a version of M$ Office with Access in it and stop bothering all you nice people. - Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
