FYI, I found these KB articles that might deal with this (although they mention pertaining only to SQL 7/2000, this is a JET issue and that is outside of SQL)....

vivek.verma (9/11/2010)

---

Hi Wayne, many thanks for your reply. I am a newbie programmer and I have dealt more with programming rather then database and sql queries. In my present job...

Hey... it works! Thanks Jeff.

The fastest way...

Steve Jones - Editor (9/13/2010)

---

I shut down the thread. There's no winning that one. I suspect that the last few positive comments were friends, or the same person, putting up...

FYI, we now need 22.4 posts/day to make 20k by Nov 18.

Stefan Krzywicki (9/13/2010)

---

CirquedeSQLeil (9/13/2010)

---

Stefan Krzywicki (9/13/2010)

---

WayneS (9/13/2010)

---

Alvin Ramard (9/13/2010)

---

I'm staying out of that Bit thread, and I'm not the author of that saying, so feel free to post it if...

I tried to stay out...

(I think I'm going to regret getting drawn into this...)

Lennie,

It's not until these last two posts of yours that you mention that this field is set to NOT NULL.

Also......

@scott - excellent point (wish I had made it!)

Yes, doing just...

If you are inserting a large amount of data, you will probably find it faster to add the index afterwards.

Brandie,

Thanks for the tip.

I don't think this is the issue. If I open up a query window in SSMS and directly enter :

select * from OpenRowSet (...)

I get the...

... which is always a good idea for any code you get off the internet.

Please respond back and let...

Threadizens,

I posted Friday about an issue in getting OpenDataSource to work on a server. I can't figure out why I'm getting this issue, and would really appreciate any input you'll...