By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Checking Table Links on Backend with no permissions

P: n/a
Is there a way to check the validity of front-end table links on a
backend file where all permissions to data have been revoked. To get
at the data, the front end uses RWOP queries.

What I'm trying to do is to avoid having to always delete table links
and recreate them at startup since this takes quite awhile.

I know you can try to open a recordset, but this fails because unless
the user is the owner, they have no permissions on the backend tables.

So, I'm looking for an alternative way. I also know you can check the
connect string, but if a backend file is moved, the front end will
still have the connect string from the previous location, so just
checking it doesn't tell you if it is invalid.

Maybe a way to handle this is to somehow check the RWOP queries. If
they have data (i.e. records are returned), this might indirectly prove
the validity of a link.

I've never seen a post for doing it this way, but seems like it should
work.

Comments, suggestions.

Thanks.

Jan 2 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.