|
 |
access thread: Importing Data From Protected Database
Message #1 by brose@u... on Fri, 11 May 2001 16:55:38
|
|
I am using an Access database that has been protected using the security
wizard. I would like to create a new database and import all the stuff
from the protected database to the new one. When I try ding this it says I
do not have permission. How do you import data from a protected database?
Is there a way to give it the login information? Please help. Thanks so
much.
Message #2 by "Anthony Delcy" <DELCYAN@l...> on Fri, 11 May 2001 12:06:25 -0400
|
|
You just to put the user and password in the provider string. See the
following example. It is in Oracle because I couldn't find the MS Access
one.
Provider=3DOraOLEDB.Oracle.1;Password=3DPPR;Persist Security Info=3DTrue;Us
er ID=3DPPR;Data Source=3Dmisdb1
Try this and let me know.
Anthony
Anthony Delcy
MIS
delcyan@m...
>>> <brose@u...> 05/11 4:55 PM >>>
I am using an Access database that has been protected using the security=20
wizard. I would like to create a new database and import all the stuff
from the protected database to the new one. When I try ding this it says
I
do not have permission. How do you import data from a protected
database?
Is there a way to give it the login information? Please help. Thanks so
much.
Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Fri, 11 May 2001 11:04:05 -0700
|
|
You've got to authenticate yourself to Access as someone with rights to the
protected mdb. Open the protected mdb directly, using whatever your normal
procedure is for that. Then go to File -> New and create your new blank mdb
file (this will have the effect of closing the protected one). Then start
your import and you should be fine.
HTH,
-Roy
-----Original Message-----
From: brose@u... [mailto:brose@u...]
Sent: Friday, May 11, 2001 9:55 AM
To: Access
Subject: [access] Importing Data From Protected Database
I am using an Access database that has been protected using the security
wizard. I would like to create a new database and import all the stuff
from the protected database to the new one. When I try ding this it says I
do not have permission. How do you import data from a protected database?
Is there a way to give it the login information? Please help. Thanks so
much.
Message #4 by brose@u... on Mon, 14 May 2001 14:05:50
|
|
Thank you so much. This is what I was looking for. It worked without any
problems.
> You've got to authenticate yourself to Access as someone with rights to
the
> protected mdb. Open the protected mdb directly, using whatever your
normal
> procedure is for that. Then go to File -> New and create your new blank
mdb
> file (this will have the effect of closing the protected one). Then
start
> your import and you should be fine.
>
> HTH,
>
> -Roy
|
|
|
View Cart
