Exporting to external unsecure database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramesh - 25 Jul 2007 15:19 GMT

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

Reply to this Message

Wayne-I-M - 25 Jul 2007 15:46 GMT

Hi Ramesh

Have you tried it. Did it work?

Signature

Wayne
Manchester, England.

> Hi
>
[quoted text clipped - 4 lines]
> Thanks
> Ramesh

Reply to this Message

John W. Vinson - 25 Jul 2007 17:34 GMT

>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]

Reply to this Message

Ramesh - 26 Jul 2007 05:04 GMT

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

>>Is it possible to export a table from a database with user level security
>>to
[quoted text clipped - 3 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 26 Jul 2007 06:46 GMT

>Thanks John and Wayne for your response.
>
[quoted text clipped - 3 lines]
>
>Any way out?

But you said:

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

^^^^^^^^^^^^^^^^^
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]

Reply to this Message

Ramesh - 27 Jul 2007 08:11 GMT

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

>>Thanks John and Wayne for your response.
>>
[quoted text clipped - 30 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 27 Jul 2007 16:24 GMT

>John,
>
[quoted text clipped - 7 lines]
>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]

Reply to this Message