[AccessD] No Relationships When Linked To Passworded BE

Andy Lacey andy at minstersystems.co.uk
Wed Jan 9 04:33:41 CST 2008


Hi folks.

Is anyone else experiencing this, or am I doing something wrong? This is A97
BTW. I've been working on password-protecting the client's BE and was ready
to roll-out when I've just found this. Take a non-password-protected BE
with, say, 2 tables with a relationship between them. Create a blank MDB and
link to those tables. Show relationships and there they are. Now add a
password to same BE. Create a new MDB and link to those tables (giving
password). Show relationships and - nothing.

The relationships are still in operation. Do something to the linked tables
to prove it. But the FE doesn't "see" them. I discovered this when my little
data dictionary routine failed to print the relationships, and when I
tracked it through the code the .Relations collection is completely empty.

Anyone else seen this? Anyone know how to overcome it?

--
Andy Lacey
http://www.minstersystems.co.uk

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list