Security.

[hardy1976]

Problem....

I have a secured database, lets call it "A" with a query "Q"

I now need to access the query "Q" from a unsecured database.

Is this possible if so how?!

I ned the unsecured database to suck the info from the secured database, rather than the secured database pushing the data into the unsecured database.

Any ideas gratefully recieved.
H

 

[KenHigg]

I think a suck is more commonly referred to as a pull

 

[hardy1976]

thats the one lol push and pull!!! LOL

 

[Banana]

This is just off the top of head, but I do believe OpenDatabase method allows you to open secured database by supplying a password. Could have a pop up message for the user to type in then send it to get that query.

HTH.

 

[Len Boorman]

Basically you want an unsecured database to extract data from a secured database.

That totally destroys the principle of a secured database.

If it can be done then either the security was not set correctly or access security has a hole in it about as big as the universe.

len

 

[hardy1976]

Len,

I understand what you are saying however I will not be bypassing security - I'll simply setup a user who has access to the relavant data, that I want them to access (if that makes sense!)

H

 

[hardy1976]

Why does DBEngine.SystemDB = "a new location" not point to my new location and still point at the default "c:\prog files\ms\access etc?!?!?"

 

[statsman]

I think you're going about this backwards.

If you have the necessary permissions on the secured database, you should be able to export the query results to an outside table or spreadsheet.

 

[hardy1976]

I hear you statsman - however its an extra step that I'd ideally like to negate.