Ram
|
| Posted: 04/24/2005, 12:34 PM |
|
Hi:
I am a new user to code charge studio. I just tried using it with a basic Access Database to generate a search page based on one table. I selected only one search field (job#).
The database is an Access database. While building the project, I am using the following connection string. (which was built using application builder)
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Newest Scheduling System.mdb;Persist Security Info=False
It generates and publishes the site but when I try to access it, I get the following error message.
Form: Grid MMI_2005_Schedule
Error: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. (Microsoft JET Database Engine)
Why would this be? Any suggestions?
Thanks.
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 04/25/2005, 4:41 AM |
|
Ram,
The error message is pretty self explanatory but reason of it is not clear. So you can print the generated sql as described in CCS help http://docs.codecharge.com/studio/html/ProgrammingTechn...Output.html?toc
And test that query in Access, you should get more exact error message that helps you to find the reason of error.
_________________
Regards,
Nicole |
 |
|
|
