Exporting to external unsecure database

[Ramesh]

Hi

Is it possible to export a table from a database with user level security to
an external unsecure database? I need to do this to allow another program
to access the data. I have admin user access to this secure database.

Thanks
Ramesh

 

[Wayne-I-M]

Hi Ramesh

Have you tried it. Did it work?

 

[John W. Vinson]

Is it possible to export a table from a database with user level security to
an external unsecure database?

Sure, just so you're logged on in the database with read privileges.

John W. Vinson [MVP]

 

[Ramesh]

Thanks John and Wayne for your response.

But the problem i have is that the exported database also is secure.
Attempting to open it asks for a username and password. This program which
needs to read the data has no provision to do that.

Any way out?

Ramesh

 

[John W. Vinson]

Thanks John and Wayne for your response.

But the problem i have is that the exported database also is secure.
Attempting to open it asks for a username and password. This program which
needs to read the data has no provision to do that.

Any way out?

But you said:
^^^^^^^^^^^^^^^^^
You should not be exporting *the database*. You should be exporting *the data
in your table*. You have read access to that data... so you can export it. I
guess I fail to see the problem.

If you're in fact appending to a secure database, is it secured with a
database password or with Access workgroup security? If the former, there's a
Pwd argument to the OpenDatabase method; if the latter, if you're in the same
workgroup you should be able to work with your workgroup privileges.

What is "the program which needs to read the data", and - if you're exporting
it anyway - why can't you export it to a form that the program CAN read?

John W. Vinson [MVP]

 

[Ramesh]

John,

I am able to export the data in my table to another file. But opening the
file also requires a user and password .. and that s my problem. I need to
export to another file which should not require a user name and password.

The situation is this. I have a secure database which has phone numbers in
it. I have a messaging program which can the phone numbers read from an
unsecure database and send text messages. I need to put these numbers into
a database where it is accessible to this program without requiring a user
name and password.

Hope I ve been clearer this time.

Thanks
Ramesh

 

[John W. Vinson]

John,

I am able to export the data in my table to another file. But opening the
file also requires a user and password .. and that s my problem. I need to
export to another file which should not require a user name and password.

The situation is this. I have a secure database which has phone numbers in
it. I have a messaging program which can the phone numbers read from an
unsecure database and send text messages. I need to put these numbers into
a database where it is accessible to this program without requiring a user
name and password.

Ok... maybe I'm completely missing the point here...

but why not create an unsecured database and export to that?

John W. Vinson [MVP]