Okay, that's weird. Works if I create SQL for the query in Access then paste it into the Query window. Otherwise, doesn't seem to work. Maybe the...

Multi-valued fields are evil.

Break the multi-valued field into a separate table and use that.

Helpful explanation. Makes thing easy!

Note: I have a Report parameter that is of type Date (so when it runs you can pick a date from it...), it's called "prmOrderMonth"

This...

Jeff,

Okay, THANKS. Got part of it working... at least the linked server shows up... I can't query it, but I can see it. =) (About as much fun as...

Just wondering, where are the 64-bit ACE drivers available? I seem to have the 32-bit ones, and SQL Server is throwing a fit. (I suppose I could do an...

Here[/url]'s Jeff's article. Definitely worth a couple of reads.

Feel free to obscure any sensitive data... what is helpful is a representative structure of the data... and something we can...

CREATE TABLE scripts?

INSERT scripts?

can't fix what we can't see.

This is one way of parsing out the tweets... it's not perfect, but it's closer than you are now.

DECLARE @TextString VARCHAR(1000) = 'got me a text file with tweets in...

Welcome to SSC,

A few things...

You should get more responses if you post to a new thread instead of a prehistoric one.

For a newbie, nice post,...

Access databases (.mdb at least, not totally sure about .accdb) were notorious for corrupting if you didn't treat them nicely. I wouldn't trust an .mdb for anything that required...

Can you post a sample of what you're trying to parse out? Munge the data if necessary... Just helps to see what you're dealing with.

If you right-click on the parameter that you want to allow nulls and view the properties, you can specify that the parameter can allow nulls.

If you are basing your dataset...

If you're importing from an .MDB file, use the Jet 4.0, not the ACCDB nightmare. The Jet one actually works.

Check the server collation value. It could be case-sensitive.

http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/

http://stackoverflow.com/questions/14270993/case-sensitive-variable-names-in-sql-server

Christopher Adamson's Star Schema: The Complete Reference is really good. It's database agnostic, but he does a really good job of explaining concepts like Slowly Changing Dimensions and how to...