Connection string for make table query into secured database

[Deirdre]

I need a connection string that will work in a make table query from a
database (access 2003) without security into a database with user level
security (also access 2003). Can anyone help? I have researched, but
everything I have tried hasn't worked. Thanks

 

[Tom van Stiphout]

On Sun, 23 Mar 2008 17:13:00 -0700, Deirdre

There are several examples at www.connectionstrings.com
-Tom.

 

[Ray C]

The first step is you'll need to have access to the .mdw file of the secured
database in order to be able to do that. And secondly, you'll need to have a
valid username and password. And thirdly, your unsecured database must be
connected to the .mdw file. Do you have these?

 

[Deirdre]

I have access to the mdw file (I created it), I also have a valid user name
and Password. However, my unsecured database is not connected to this
particular mdw file (and I really didn't want to have to do that - I'm trying
to find another way - I don't want this particular db to rq username and db)
it is connected to the default access mdw file.

 

[Ray C]

It's still unclear what you're trying to do.
Is your maketable query running inside the unsecured db?
Will your new table reside inside the unsecured db or the secured db?

Ray