Syntax error

R

Ron

I am trying to save a multi project file as a Microsoft Access Database.
When the export map contains the fields: % Complete, Actual Start, Actual
Finish, Total Slack and Unique ID I get a message "[Microsoft][ODBC
Microsoft Access Driver] Syntax error in field definition." and the export
fails. If I remove these fields and leave only fields such as: Start,
Finish, Duration everything works fine. I made some custom field that had a
space in the field name and when these are included in the map the export
again fails. When I rename these fields without the space the export is
successful. It appears it is the space in the field name that is the syntax
errors causing the failure. Is there some work-around or a way to rename the
fields?

Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top