Linking to ACCESS Tables in unshared folder

[Christy Wyatt]

I have three databases, one for the psychology department, one for the
supervisors out in the cottages (read only summary reports), and one for data
entry only for the cottage staff to punch behavior reports. The cottage one
is completely locked down so that all they get is a pop-up form and the data
goes into a hold table for appending into the main database.

We absolutely do not want anyone but the psych dept to find or see the
folder with the 32,000 record database in it, but we have to link to those
tables to make it all work. When I link to the tables in a database in an
unshared folder, the cottage staff get a notice regarding lack of permission
when opening the data-entry only database. If I share the folder they will
see it, and could maliciously delete it.

Christy Wyatt

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Keith Wilby]

I have three databases, one for the psychology department, one for the
supervisors out in the cottages (read only summary reports), and one for
data
entry only for the cottage staff to punch behavior reports. The cottage
one
is completely locked down so that all they get is a pop-up form and the
data
goes into a hold table for appending into the main database.

We absolutely do not want anyone but the psych dept to find or see the
folder with the 32,000 record database in it, but we have to link to those
tables to make it all work. When I link to the tables in a database in an
unshared folder, the cottage staff get a notice regarding lack of
permission
when opening the data-entry only database. If I share the folder they
will
see it, and could maliciously delete it.

Christy Wyatt

You could always remove their "delete" permissions to the file.

Keith.
www.keithwilby.com

 

[Tom Wickerath]

dude you need to use Access Data Projects for sure

Access MDB is obsolete; and it has been for a decade