HomeActive Query BuilderConnection to Access

Connection to Access


we have some problem with acces, lets say we have a table
with the follwing structure:
Table Name = Table1
AutoID - AutoNumber
Type - Text
Timestamp -Date/Time
Value - Number
when we open this table with the QueryBuilder everything is ok, when selecting the columns witht he query builder I have noticed that the Timestamp and the Value columns are being selected like this: Table1.[Timestamp],Table1.[Value] but all the other columns are selected like this Table1.Type

when changing the query to be without the [] around the Timestamp and the Value columns the QueryBuilder throws an error
why is that and how can we solve it
ronk | email
November 23 2008, 03:43 AM
Dear Ron,

Thank you for your notice. This problem will be solved in the next minor version. While these fields will be quoted automatically, you'll have no problems with loading of MS Access queries without quotes.
Sergey Smagin | email
1 day, 22 hours since original post
This topic is closed