All due respect - but what you've described in 4 paragraphs IS what a UNION syntax would do. It would return the DISTINCT values (or in your wording, all...

Let's see if we can tweak Brian to post in here by using one of his recent buzzwords - protection in depth. He could probably get us a lot...

noeld (12/4/2007)

---

By the way a quick way to determine index usability is by knowing you data. If the index "selectivity" is > 10% chances are is not going to...

Not sure why this would have changed - but what do your autogrowth/sizing parameters look like?

Also - did the auto-close get "flipped on"? That could create some really interesting...

No evidence of any 3.5 drivers on the machine.... Not sure what to tell you about that.....

Backup represents more than a single write operation. It's about 3 passes through the data, so the 12GB turns into a lot more traffic (there's at least a writing...

double-posted - answered over here

I came across that article a little while ago. The scariest part to me was that these servers were usually also not patched in any way, so they were...

Ahmed Yarub Hani (12/4/2007)

---

I found the problem!!

Both test machines were using the same public ip, that's why it didn't connect

I think that I can't connect the source ip to the...

unfortunately - yes.

You need Enterprise, "for Office" or Team suite editions to get the SQL project integration.

Your best bet is to use ADOX to create link tables to SQL2000, which you can then reuse in your application.

The MSDN sample code for this is located here:

http://msdn2.microsoft.com/en-us/library/aa164914(office.10).aspx

You'll need...

Where is the VB code supposed to be running from? Are you talking VBA (VB for Application) code running from within the Access DB?

Well - as scott mentioned - it's probably the network link being the bottleneck.

One way might be to see if you can turn the 1600lb gorilla into 2-800lb gorillas, or...

Well - for your first pointer - why not post the code? Preferrably with the DDL of the tables involved? It sounds like there might be a few...

How would TRUNCATE even factor in? Do you actually have something big enough to be considered for partitioning that has NO foreign key constraints? And "eligible" to be...