IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / your update ran OK, thanks Norm but
Post #107,565
by boxley
6/27/03 2:18:14 PM
Reply
New your update ran OK, thanks Norm but
same problem so I will assume the relationship is in error. There is a newbie(to us) called Diane who will take problem over, She unfortunately is a HP nix admin who knows as much as I do about crapcess so hopefully she can figure it out.
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]

questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]

As the Poets have mournfully sung.
Death takes the innocent young,
The rolling in money,
the screamingly funny,
And those who are very well hung.
W.H. Auden
Post #107,590
by orion
Picture of orion
6/27/03 5:18:27 PM
Reply
New Access relationships
Under the tools menu is the Relationships command, which shows the relationships of the tables. See what fields are linked between those two tables. This is not hard to do, and I know you can do it. So far the only two fields I know about are serial number fields. There could be others. Like for example, what is the Primary key to the table? There may be a relationship set up between the primary keys of the two tables that is shorting out your query.

One thing you could do, is make a new database, import those two tables to it, and then try running your query on that. It won't copy the relationships.

Something else I thought of is that the database might be damaged in some way, if this is a brand new database it is unlikely, but if it has been around for a long time you may want to repair and compact the database, then see if the problem goes away. But before you do that, be sure to back it up first. Sometimes the repair and compact might remove data that is damaged, and last thing you need is losing data.



"I wonder how much of this BS Corporations will continue to shallow before they start looking into alternatives to Microsoft software?" -[link|http://z.iwethey.org/forums/render/content/show?contentid=106839|Orion]
     Have an Access problem - (boxley) - (34) - June 27, 2003, 11:40:35 AM EDT
         The SQL is correct. - (tseliot) - (5) - June 27, 2003, 12:49:43 PM EDT
             run toy data - (tablizer) - June 27, 2003, 01:32:51 PM EDT
             how would I TRIM the above statement? - (boxley) - (3) - June 27, 2003, 01:33:13 PM EDT
                 Try this: - (orion) - (2) - June 27, 2003, 01:51:48 PM EDT
                     your update ran OK, thanks Norm but - (boxley) - (1) - June 27, 2003, 02:18:14 PM EDT
                         Access relationships - (orion) - June 27, 2003, 05:18:27 PM EDT
         Could be a relationship problem - (orion) - (1) - June 27, 2003, 01:37:13 PM EDT
             only relationship, single user -NT - (boxley) - June 27, 2003, 01:41:02 PM EDT
         Well the documentation is misleading? :-) - (ChrisR) - (2) - June 27, 2003, 02:27:15 PM EDT
             the cut and paste was correct - (boxley) - (1) - June 27, 2003, 04:55:32 PM EDT
                 I've changed it in my example - (orion) - June 27, 2003, 05:21:09 PM EDT
         Is "field indexed *with duplicates allowed*" on BOTH tables? - (CRConrad) - (22) - June 27, 2003, 05:52:26 PM EDT
             Re: Is "field indexed *with duplicates allowed*" on BOTH tab - (orion) - (19) - June 27, 2003, 06:41:35 PM EDT
                 The only primary key is on the master table - (boxley) - (2) - June 27, 2003, 07:20:48 PM EDT
                     Re: The only primary key is on the master table - (orion) - (1) - June 27, 2003, 08:22:20 PM EDT
                         the only link is the serial fields - (boxley) - June 27, 2003, 09:35:46 PM EDT
                 That is a major assumption on your part - (tseliot) - (15) - June 27, 2003, 09:35:31 PM EDT
                     Actually, for oce Norm is far more right than wrong; you... - (CRConrad) - (2) - June 28, 2003, 09:30:20 AM EDT
                         We're not disagreeing here. - (tseliot) - (1) - June 28, 2003, 01:13:30 PM EDT
                             Ah... *that* "assumption"! :-) - (CRConrad) - June 28, 2003, 02:58:36 PM EDT
                     ALL tables need PK's. - (mmoffitt) - (11) - June 30, 2003, 11:40:08 PM EDT
                         Sorry; What's an "sp"? - (tseliot) - (2) - July 1, 2003, 10:31:18 AM EDT
                             Probably 'Stored Procedures'.... - (ChrisR) - (1) - July 1, 2003, 10:36:51 AM EDT
                                 In Access they are "Queries" - (orion) - July 1, 2003, 12:32:23 PM EDT
                         Are you disagreeing with me? I can't tell. - (tseliot) - (7) - July 1, 2003, 04:18:35 PM EDT
                             Dunno if I disagree. - (mmoffitt) - (6) - July 3, 2003, 11:23:33 AM EDT
                                 Toy and scale are not the issues. - (tseliot) - (5) - July 3, 2003, 02:10:46 PM EDT
                                     Then you don't need a thirty-line table at all... - (CRConrad) - (2) - July 3, 2003, 03:51:15 PM EDT
                                         Thank you. -NT - (mmoffitt) - July 3, 2003, 10:56:12 PM EDT
                                         Should I answer? - (FuManChu) - July 4, 2003, 01:18:46 PM EDT
                                     But, but, a tool of any value has a serial number and they.. - (a6l6e6x) - (1) - July 3, 2003, 09:56:56 PM EDT
                                         In this particular case - (FuManChu) - July 4, 2003, 01:24:29 PM EDT
             Started with no index on either field - (boxley) - (1) - June 27, 2003, 07:15:57 PM EDT
                 It's probably not a factor in your problem... - (tseliot) - June 27, 2003, 09:37:44 PM EDT

Dein Glück... ist nicht mein Glück... ist mein Unglück.
221 ms