OleDbDataAdapter-Error on "SELECT * FROM Position"

[tschoepi]

Hi there,

if I try to access a table named Position in an Access-Database via
OleDbDataAdapter I get an error. If I rename the table to e.g.
Positions it works.
Any idea how to solve this problem?
(There are about 5.000 databases out there at our customers with a
table in it named Position!)

Thanks a lot for your help

Markus

P.S.: The error only occurs with an OleDbDataAdapter (via Microsoft
Jet 4.0 OLE DB Provider). With an OdbcDataAdapter it works.

 

[Cor]

Hi Tchoep

Normaly with "Select * from [Position]"

I hope this helps,

Cor