In Access 97 and 2K there was a similar problem when Access had a link table and it could not figure out what was the Primary Key from SQL Server....

Thank you, but I found my problem:had to create another variable to store the value I wanted to compare to, and use the expression @varStatus == @constCheckStatus. This did the...

What is the remote server? Another SQL instance, an AS/400 or Oracle?.

The "Bad Data" error is on the subscriptions, correct?. I had that same problem yesterday on my subscriptions, but got corrected by opening them and refreshing the data on the...

Download and install the .NET Framerwok 1.1 SDK.

Next register manually the two services with the following batch file:

cd "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322"

aspnet_regiis.exe -i

pause

regsvr32 aspnet_isapi.dll

pause

exit

And that should do it.

Cesar

I did not know this behaviour.

Thank you Shawn!!

Try using dynamic sql, creating a variable where you store the SQL statement, and then call the xp_executesql.

Something like this:

sSql = "SELECT name, address, street FROM table1 WHERE name =" +...

About the IBM iSeries Access for Windows, I think is only bundled with IBM's AS/400 software. I've have never seen it for download. Online only patches and PTFs.

About the fasted method,...

I'm sorry, I meant any T-SQL script. I have never used VB scripts.

But try returning a dataset instead of a table.

What error do you get?

We have few that the dataset's Command Type is set to "text", and in there is any regular script....

Another way will be to write a vb script that either asks the user if he/she wants to refresh the data, or just check for the day of the week...

Bear with me since these applied to SQL 2000, but don't know if is true for 2005.

You don't see the libraries because in the default setup of the linked server...

Remove the @ sign from the parameter definition: that is what is confusing the parser.

About the online resource, I don't have any good one. Most of my knowledge comes from...

Try making it a dynamic MDX statment typing it like:

="with member [Measures]. bla bla bla... select (strtoset ( '" & Parameters!P2.Value & "' , Constrained )) bla bla bla..."

Be carefult...

The problems in the past that I had with blank pages were related to margins set too narrow,  where lines or fields "overflow" forcing a new blank page. Change the margins...