data access issue

[drkhelmt]

I'm working with multiple databases that do not have linked tables. I do not view linking tables as a viable solution as performance will be an issue in the future.

My file server has the following directories:
Accounting (viewable by all, writeable by accounting staff- me)
Sales (writeable by the sales force and accoutning, viewable by all)

In Sales, I have sales.mdb, which has a report -status. Part of status has subform- poNumbers whose record source is a simple SELECT... FROM IN statement that reads the PO table in po.mdb.
In Accounting, I have po.mdb.

If I run the report in the sales.mdb, I get the PO numbers just fine. If the salesforce runs the report, they do not get any PO numbers. If I give the sales force wirte access to the Accounting directory, they get the PO numbers. Is there a simple way to get around this while not giving the salesforce write access?

Any help is appreciated!

Andrew
a.k.a. Dark Helmet

"What's the matter Colonel Sandurz? Chicken?

 

[PHV]

Anybody connecting to \path\to\database.mdb must have have full rights on \path\to due to \path\to\database.ldb

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[drkhelmt]

Thank you PHV but, would it be possible to use a username/password work around?

Andrew
a.k.a. Dark Helmet

"What's the matter Colonel Sandurz? Chicken?