(new) Databases

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

DB2 Cert Monster - (tablizer) - (20) - June 27, 2003, 02:22:54 AM EDT

Real Tables, meet Tablizer. Tablizer, meet Real Tables. -NT - (Arkadiy) - (7) - June 27, 2003, 11:44:52 AM EDT

ROFL -NT - (deSitter) - (6) - June 27, 2003, 12:09:56 PM EDT

ha ha, very funny. Laff it up, furball -NT - (tablizer) - (5) - June 27, 2003, 01:23:09 PM EDT

Re: ha ha, very funny. Laff it up, furball - (deSitter) - (4) - June 27, 2003, 10:06:44 PM EDT

Like I said, IN PRACTICE most sites just use the defaults - (tablizer) - (3) - June 28, 2003, 12:38:07 AM EDT

Beg to differ... - (folkert) - (2) - June 28, 2003, 10:31:15 AM EDT

I don't think we are communicating - (tablizer) - (1) - June 29, 2003, 12:49:34 AM EDT

point == missed - (folkert) - June 29, 2003, 12:18:09 PM EDT

Compare... - (folkert) - (3) - June 28, 2003, 08:30:17 PM EDT

You have to know enough about databases - (boxley) - June 28, 2003, 09:34:13 PM EDT

re: Compare... - (tablizer) - (1) - June 29, 2003, 01:03:57 AM EDT

It was meant the way you read it. :) -NT - (folkert) - June 29, 2003, 01:56:44 PM EDT

So, anybody want to buy a slightly used DB2 cert study book? -NT - (tablizer) - (7) - July 12, 2003, 12:42:02 AM EDT

How much? -NT - (folkert) - (6) - July 12, 2003, 12:19:49 PM EDT

$22 + shipping. Got paypal? - (tablizer) - (5) - July 13, 2003, 02:48:24 AM EDT

do I hear $18? -NT - (tablizer) - (4) - July 19, 2003, 12:02:17 AM EDT

$16 + Shipping - (folkert) - (3) - July 19, 2003, 10:49:59 AM EDT

I probably would not know shipping $ ahead of time.Plan B... - (tablizer) - (2) - July 23, 2003, 02:44:27 PM EDT

NO NO NO NO NO NO. I won't short you, Bryce. - (folkert) - (1) - July 23, 2003, 09:26:53 PM EDT

People still use cheques? (new thread) - (Meerkat) - July 24, 2003, 05:54:31 AM EDT

Virtual (i.e. federated) database, anyone? - (tseliot) - (6) - June 24, 2003, 08:31:11 PM EDT

define a database - (boxley) - June 24, 2003, 11:27:01 PM EDT

What do you mean? - (ben_tilly) - (4) - June 24, 2003, 11:42:15 PM EDT

No; "federated" as in "diverse stores". - (tseliot) - (3) - June 25, 2003, 01:55:48 AM EDT

In other words - (orion) - (1) - June 25, 2003, 11:33:19 AM EDT

You're reading it right. -NT - (tseliot) - June 25, 2003, 11:52:42 AM EDT

I've seen some... - (admin) - June 25, 2003, 11:39:43 AM EDT

International Addresses - (ChrisR) - (7) - June 15, 2003, 01:05:26 AM EDT

schema, US, Canadian, Other 256 varchar -NT - (boxley) - June 15, 2003, 02:12:40 AM EDT

So we your peons are wildlife, or what? - (CRConrad) - June 15, 2003, 08:27:02 AM EDT

Re: International Addresses - (JayMehaffey) - (4) - June 15, 2003, 12:57:07 PM EDT

Suggestions WRT int'l addressing - (kmself) - June 15, 2003, 04:56:30 PM EDT

postal codes - (cforde) - (1) - June 16, 2003, 01:24:10 AM EDT

And then an Australian chips in... - (Meerkat) - June 16, 2003, 08:51:56 AM EDT

Further notes. - (static) - June 20, 2003, 08:18:47 AM EDT

Paradox/BDE questions/problem - (jbrabeck) - (2) - June 9, 2003, 04:17:02 PM EDT

Only from the new XP box, or all machines? Some links... - (CRConrad) - (1) - June 9, 2003, 05:18:08 PM EDT

Sorry - Problem only on XP box. Thanks for links. -NT - (jbrabeck) - June 9, 2003, 05:26:18 PM EDT

More Access problems -- this time with SQL Server, too! - (acagle) - (9) - May 27, 2003, 04:10:12 PM EDT

No solution for that context... - (ChrisR) - May 27, 2003, 04:21:07 PM EDT

Hmmmmm. . . . . . - (acagle) - May 28, 2003, 12:37:19 PM EDT

DAMN IT, this is infuriating. - (acagle) - (6) - June 9, 2003, 01:27:22 PM EDT

MDAC > 2.5? - (deSitter) - (5) - June 9, 2003, 01:32:12 PM EDT

Re: MDAC > 2.5? - (acagle) - (4) - June 9, 2003, 03:31:00 PM EDT

Re: MDAC > 2.5? - (deSitter) - (3) - June 9, 2003, 04:08:23 PM EDT

Re: MDAC > 2.5? - (acagle) - (2) - June 9, 2003, 05:51:43 PM EDT

Re: MDAC > 2.5? - (deSitter) - (1) - June 10, 2003, 11:18:20 AM EDT

Re: MDAC > 2.5? - (acagle) - June 10, 2003, 12:05:25 PM EDT

MS SQL Server - Generate Scripts programmatically? - (kmself) - (4) - May 20, 2003, 06:57:06 PM EDT

Define not run - (broomberg) - May 20, 2003, 07:27:11 PM EDT

I generally do it the other way. - (ChrisR) - (1) - May 21, 2003, 01:18:38 AM EDT

No experience with this problem in MS-SQL, but - (broomberg) - May 21, 2003, 06:48:28 AM EDT

An error list might be helpful. - (mmoffitt) - May 23, 2003, 10:55:01 PM EDT

This space reserved for future topic. - (ChrisR) - (1) - May 15, 2003, 08:51:31 AM EDT

Heh. -NT - (admin) - May 15, 2003, 09:16:13 AM EDT

As time goes by.... - (ChrisR) - (3) - May 14, 2003, 11:34:43 PM EDT

Well, oddly enough... - (admin) - (2) - May 14, 2003, 11:36:13 PM EDT

Found it. - (admin) - (1) - May 14, 2003, 11:40:39 PM EDT

Got your reply. Thanks!!! (new thread) - (ChrisR) - May 15, 2003, 08:49:42 AM EDT

Workbench for Firebird datapump question - (boxley) - (1) - May 14, 2003, 09:17:14 PM EDT

Try dragging table name to table name first - (altmann) - May 15, 2003, 02:30:15 AM EDT

Welcome to IWETHEY!