Well, ya learn something new every day.

I hammered away at this and realized:

If I created a primary key in the table, then Access allowed me to add records. Without...

The Wrox book had a pretty good introductory chapter on replication:

Beginning SQL Server 2000 Programming

by Robin Dewson

Oh. Now I see. So the only way to economize is to make sure that every data change is the final change we want, not just an intermediate...

Aha! I didn't realize that indexes and assignment of primary keys would not change along with table names. This is, uh, somewhat counter-intuitive.

I took the path of least...

Since we're having a little fun with our favorite quotes, here's another one to add to the collection.

Woody Allen: Nothing worth knowing can be understood with the human mind.

🙂

Well, I did actually read all of "War And Peace" once.;)

But, no, I'm not gonna want to read all 180K records. So let me modifiy my question:

Would SELECT [field1],...

If a SELECT * gives you a full table scan, would a SELECT [field1], [field2] FROM MyTable be significantly faster if all you really needed was the first 2 fields?...

Thank you! That worked perfectly!:)

Here's the basics.  This will loop thru all the records in a table and display them one at a time.

<%SET Connect=Server.CreateObject("ADODB.CONNECTION")