Access Crosstab query in VB.NET

G

Guest

I'm trying to get an Access Crosstab query to fill a VB.NET datagrid. I'm getting an error that states "not a valid file name".. the query runs fine when I run the same SQL in Access. Can a dataAdapter be filled with data from a crosstab query
 
H

Herfried K. Wagner [MVP]

* "=?Utf-8?B?R3JlZyBCdXNieQ==?= said:
I'm trying to get an Access Crosstab query to fill a VB.NET
datagrid. I'm getting an error that states "not a valid file name".. the
query runs fine when I run the same SQL in Access. Can a dataAdapter be
filled with data from a crosstab query?
Click to expand...

You will more likely get an answer here:

<
 
P

Paul Clement

¤ I'm trying to get an Access Crosstab query to fill a VB.NET datagrid. I'm getting an error that states "not a valid file name".. the query runs fine when I run the same SQL in Access. Can a dataAdapter be filled with data from a crosstab query?
¤

You may want to post the contents of your query. If I had to take a guess, you're probably using an
Access or ODBC reserved word as a column name. The easy fix is to enclose the column name within
brackets.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting Access query criteria 3
Crosstab query error 1
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Parameter Value in Crosstab Query 4
Parameter Queries in Crosstab Query 2
Access Query Optimizer error 5
Form based on crosstab query 1
Create table from a crosstab query 2

Top