I have two local DBs, one is blank and the other has test data within it. The blank database has no security applied to it, but the Testing DB has a security.mdw file applied to it. I have full access to the security settings and know all the passwords so i can edit the security settings without any issues.
My trouble is when I try linking the test MDB file to the blank MDB file. I keep getting a permissions issue. I am not sure what the file is authenticating the connection as since I never get prompted for a userID/password during the linking process. I tried adding my domain userID to the security of the Test MDB but that did not work. Any suggestions would be great.
+++I attached a screen shot of the error meesage+++