Ram
|
| Posted: 04/24/2005, 12:36 PM |
|
Sorry but when I posted the earlier question, I thought the title meant what my title was and I put in "IT Consulting"....makes me feel kinda silly. Anyway, here it goes.
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.
|
|
|
 |
Ram
|
| Posted: 04/24/2005, 1:33 PM |
|
I think I solved it. The field names in Access had spaces and I think that was causing an issue. I also had a field name called [Job #] which I think was causing an issue. Anyway, I changed it so that there are no spaces and removed the # and the application works fine.
|
|
|
|
|
