Little known fact - you can execute stored procedures with an Access VBA code command like the examples below. We use this format all the time and it has...

Tom,

As mentioned by others in this thread, your problem will turn out to be a combination of issues which when addressed one by one will provide a cumulative solution to...

I have the beginnings of a solution to this problem, and I can describe it - altholugh I don't have the time to code the solution.

Don's questions are deails I'd...

Hans,

Can you define what form a pattern may take?  Can you give me some examples?

-Rob

This SQL will do what you want, and it is reasonably quick.  We use it to search DBs up to 3G, and it takes less than a minute on a...

I guess it was - it was more of an education than an answer sort of along the lines of don't give them food, teach them to fish.

We tried this, and found that exporting directly to Excel is a dog.  It takes for ever.  You are better off just exporting to CSV, which runs really quickly, then...

Journeyman is on the right track here, and I only offer a slight tweak.

The principal Journeyman is showing is that you need to split you original Query into two functional...

My big question is why are you downloading data to Access?  Why not just connect the Access front end directly to the SQL data?  It works very nicely, and can be done...

This is a very broad question!!  If you need help in setting up SQL server, my company can do an on-site or on-line session with you to get you started.

-Rob...

Easiest way to do this is to is to script two copies of the entire database, one from before changes were made and one after, then use Microsoft Source safe...