Using Append/Update Query with Passwords

[Guest]

I have inherited two separate Data Bases which are very similar. The Table
of the second Data Base is Linked. Both Data Bases have the same password
that is required on opening.
There is an Append Query & an Update Query that can be used to transfer
specific information or Update to the second Data Base.
The problem is that when you run either query, it says you are about to
append/update; then when you answer Yes, the message appears "Not A Valid
Password"
Is there any way around this as the process works fine when the Passwords
are removed?

Thanks for any help

 

[Arvin Meyer [MVP]]

Try setting up User-Level security and your problem may be solved:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm