• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Dreamweaver Access recordset error

Hello
I have an access table with three fields
CurrID            Key Auto Number
CurrName      Text
CurrRate      double number
I am trying to create a recordset in Dreamweaver but when I try to test this recordset I get an error message
Syntax error in FROM clause.
the sql is
SELECT *
FROM Currency
The record set is saved OK
Why does Test throws this error.
Any ideas please?
Regards
John
0
johnhardy
Asked:
johnhardy
1 Solution
 
MikeTooleCommented:
I think that Currency is a Keyword. Try this instead:
Select * From [Currency]
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Or adopt and use a nameing convention where your tables would be named something like tCurrency or tblCurrency ... this avoid reserved words altogether.
0
 
johnhardyAuthor Commented:
Thanks quite correct
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now