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

On Sun, 23 Mar 2008 17:13:00 -0700, Deirdre
<(E-Mail Removed)> wrote:

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

>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

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" wrote:

> 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

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" wrote:

> 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" wrote:
>
> > 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

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


"Deirdre" wrote:

> 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" wrote:
>
> > 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" wrote:
> >
> > > 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