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.