Hi Everyone,

I'm trying to look and see what the .connect string is to a linked
table. I want to make sure the user has security to it, and warn them
if they don't.

I want to do this without resorting to error trapping a dlookup().

There's lots of code on using .connect in a "foreach" loop on a
collection of objects to reset connections. But, I'm completely
confused on how to use it when I just want to see the Connect string
on a single known, named table.

I've tried just simply saying:
CurrentDb.tabledefs("linkedtablename").Connect

But that doesn't work.

I'm not opposed to using an object, but I'm a complete dummy with
them. And, I don't know how to put in "tablename" in the example code
I've read.

Please help!

Thanks,

Jon
p.s. What happened to http://www.mvps.org/access? I'm getting a 503
error.

On May 19, 2:26*pm, jonceramic <joncera... (AT) gmail (DOT) com> wrote:
I take it back. This does work...
CurrentDb.tabledefs("linkedtablename").Connect

And then you can use
len(CurrentDb.tabledefs("linkedtablename").Connect ) < 0 to see if it's
a linked table.

I was just screwing up in my immediates window, and not typing "print"
beforehand.

Jon

On May 19, 2:32*pm, jonceramic <joncera... (AT) gmail (DOT) com> wrote:
BTW, this shows the string whether the user has access or not.
Grrrrr...

jonceramic wrote:
Nobody ever said Access was designed for enterprise-level security ...

The only way I know to discover if the user has permissions to the linked
table is to attempt to do a read of the table.

What is the database engine involved? If it is MS SQL Server 2005 (and
probably later) you can use a pass through query to get permissions on
specific tables, but if the user has no permission to the database server or
the specific database on the server, it still errors.

SELECT * FROM fn_my_permissions('TheTableName', 'OBJECT')
WHERE Permission_Name = 'Insert'

If you leave off the WHERE clause, you can get multiple records returned for
different permissions - Insert, Update, Read, Delete, etc.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 5/19/2011 4:16 PM, Bob Barrows wrote: