Unique constraint is to blame.

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #152,424

by mmoffitt

4/23/04 9:51:43 PM

Unique constraint is to blame.

At least in Access 2000 and before. Show hidden objects off the tool menu. Look at the MSysObjects table. There's a unique constraint on the Name + ParentId. All the foo in the .mdb has the same parentid, so if you name a query and a table the same thing - well, last one in wins.

bcnu,
Mikem

Beware Access 2003. - (acagle) - (8) - April 23, 2004, 01:48:19 PM EDT

Access 2002 does that too. - (altmann) - April 23, 2004, 03:10:55 PM EDT

Unique constraint is to blame. - (mmoffitt) - April 23, 2004, 09:51:43 PM EDT

Correct. Tables and queries share the same namespace. - (rickw) - (3) - April 26, 2004, 12:07:28 PM EDT

Re: Correct. Tables and queries share the same namespace. - (acagle) - (2) - April 26, 2004, 01:07:56 PM EDT

Yeah...me too... - (rickw) - (1) - May 5, 2004, 01:55:48 PM EDT

ICLRPD (new thread) - (Another Scott) - May 5, 2004, 01:59:55 PM EDT

Access Weird Behavior #233. - (acagle) - (1) - April 28, 2004, 12:29:59 PM EDT

Note: It's a bug. - (acagle) - April 28, 2004, 12:42:11 PM EDT

iwethey.org

I've spent an unreasonable amount of thought on the line Janet sings in Rocky Horror: "His lust is so sincere". Now, on the surface, that's a big "DUH!" because that's the nature of lust. But wait: Brad has earlier sung about how hot he is for her, and it's pretty clear he's just being conventional. Brad's lust is not sincere.

Now, I could swill green mead and gnaw raw meat with sincere lust. As for kimchee and lutefisk, well, those would be just for effect. And if I'm just going for effect, I might as well wear a tie. And pants.

-- mhuber
60 ms