Connect two .MDB files, but one has Security.mdw file applied to it

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+++
Permissions-Error.jpg
szadrogaAsked:
Who is Participating?
 
Michael VasilevskyConnect With a Mentor Solutions ArchitectCommented:
Yeah you could also call the function in an AutoExec macro, see here:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23081084.html
0
 
Michael VasilevskySolutions ArchitectCommented:
How are you linking?
0
 
szadrogaAuthor Commented:
I opened the blank DB and chose Linked Tables...this gave me the option to Browse for the other MDB file which i can locate.  When I try to open the other .MDB file i get the permission error message because that DB has the MDW file applied to it.  Isnt there a way to hard code a connection string with a username and password.  I have a valid username/password to connect into it, but i never get prompted for it when trying to link using the Linked Tables...
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Michael VasilevskySolutions ArchitectCommented:
Then you'll probably want to use something like the code here:

http://www.mvps.org/access/tables/tbl0010.htm

Your connection string will look something like:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Desktop\...;User Id=Username;Password=Password;"

The Linked Table manager, Link Table function, and Import objects function will not allow you to pass a username and password. Alternatively you could join the Testing DB mdw workgroup with your blank database as well.
HTH,

MV
0
 
szadrogaAuthor Commented:
Can you further explain the process of joining the Testing DB mdw workgroup with my blank DB?
0
 
szadrogaAuthor Commented:
Also if i were to code the string, where would i enter the code.  I guess i would create a new module...Would the function be something similar to database open()?
0
 
Michael VasilevskySolutions ArchitectCommented:
the mvps.org site tells how to do it. The string goes in the ConnectString field of a new table callled tblReconnectODBC . Then call the function fReconnectODBC on the startup form OnOpen event. There is no Database OnOpen event as far as I know.
Let me know if you need any other details!
Best,

MV
0
 
szadrogaAuthor Commented:
So i have to create a new Startup form in order to be able to place the code within the OnOpen event?
0
 
szadrogaAuthor Commented:
ok, i think i am on the right track.  I really appreciate all the help, i will award the points.
0
All Courses

From novice to tech pro — start learning today.