Linking to ACCESS Tables in unshared folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Christy Wyatt said:
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
Click to expand...

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

Keith.
www.keithwilby.com
 
dude you need to use Access Data Projects for sure

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