RE: Connection string for make table query into secured database

Tech-Archive recommends: Speed Up your PC by fixing your registry

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
.

Relevant Pages

  • Re: MDE
    ... - You are using the incorrect MDW file used to secure the database. ... MDE open or not) select teh menu option Tools> Security> User and Group ... if you don't see the other User Accounts you created when the ...
    (microsoft.public.access.security)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: Whos in the .ldb first?
    ... If the .mdw file you secured the database with isn't there, ... good indication that your security wasn't set up correctly. ... >>have full permissions on the FOLDER that the database is ...
    (microsoft.public.access.security)
  • Re: security not requesting log in
    ... If you had done this, then no matter what mdw file she used, ... Another step you should have performed is to secure the database file. ... and delete all the security files and create a new file. ... opens immediately to the main screen and shows her as Admin. ...
    (microsoft.public.access.security)
  • Re: security not requesting log in
    ... If you had done this, then no matter what mdw file she used, ... Another step you should have performed is to secure the database file. ... and delete all the security files and create a new file. ... opens immediately to the main screen and shows her as Admin. ...
    (microsoft.public.access.security)