Re: #Name? error in Access 97
Posted by:
Dan Ashton
Date: March 12, 2006 07:18AM
Just been messing around with my tables and have managed to solve the problem for my situation. My table had two fields that contained a space within their names ('Job Quote' and 'Job Estimate'). These two fields were defined side-by-side in the SQL for the CREATE TABLE statement. If I moved one of them to to be the last field defined in the CREATE TABLE statement, then loaded the data into the table, everything seemed to work perfectly within Access. I have no idea why.
Subject
Views
Written By
Posted
16644
February 15, 2006 03:30PM
6435
February 27, 2006 05:24AM
Re: #Name? error in Access 97
5044
March 12, 2006 07:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.