PC Review


Reply
Thread Tools Rate Thread

Connection string for make table query into secured database

 
 
Deirdre
Guest
Posts: n/a
 
      24th Mar 2008
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
 
Reply With Quote
 
 
 
 
Tom van Stiphout
Guest
Posts: n/a
 
      25th Mar 2008
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

 
Reply With Quote
 
Ray C
Guest
Posts: n/a
 
      25th Mar 2008
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

 
Reply With Quote
 
Deirdre
Guest
Posts: n/a
 
      13th Apr 2008
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

 
Reply With Quote
 
Ray C
Guest
Posts: n/a
 
      14th Apr 2008
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection String to Secured Database Greyhound Microsoft Access Security 2 9th Oct 2008 03:54 PM
ODBC connection string for make-table query (Access 97) Mr B Microsoft Access Queries 1 2nd Aug 2006 04:59 PM
Link table from a secured database to another secured database wa7ed via AccessMonster.com Microsoft Access Security 4 8th Dec 2005 04:58 AM
I want to make common connection string for database Alex Smith Microsoft C# .NET 2 22nd Jun 2005 03:08 PM
I want to make common connection string for database Alex Smith Microsoft ASP .NET 3 22nd Jun 2005 02:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 AM.