Test Linked Tables

[Tom Gunderson]

I have a secured application, split fe/be, backend is an Access mdb.

In several UN-secured databases, I run code at startup to test the linked
tables in the front end. This code is from "Total Access Sourcebook " by
FMS (great utility for code and examples), and returns a simple true/false.
The code requires the user to at least "read-design" permissions on the
linked table, as it runs the following line, checking for an error or not:

varTmp = tdfTmp.Fields(0).Name

Anyway, in my secured app, I'm only distributing a "deploy only" mdw, which
includes a 'remote site administrator' (see the Access Security FAQ); so
neither my users, nor the 'remote site admin' have any read design
permissions, thus this test always fails.

So.... Any ideas on how to test that my linked tables are valid?

For the time being, I've implemented a check where I try to create a
recordset from one of the linked tables, if it fails with an error# 3023
(Couldn't find file 'c:.......') then I offer up the form to allow the user
to find and re-link to the backend. It works, but is this the best way?

Any ideas appreciated! Thanks!

 

[Joan Wild]

I'd say if it works go with it. However giving them permissions on the
links does not give them permissions to the tables in the backend. I don't
see the problem.

 

[Tom Gunderson]

I wasn't clear in my first post, the code from FMS requires "read design"
permissions on the tables in the SOURCE database. It does NOT need "Read
Data", but still, I plan on deploying with NO permission on the tables in
the source db. I'll just use my code that creates a recordset. It's
probably slower than the route FMS takes, but this is a small db...

I actually now have the provervial 'bigger fish to fry', as I can't get my
code to "refresh links" working. I'll re-read the FAQ (again) and go
through step-by step... but I may be posting on that later today...

Thanks for the input.

FYI. I noticed your name on a lot of archives on google, so thanks for a lot
of info, answers, and work for that as well...

Tom