I wrote about this 2 weeks ago. Compact and Repair on source (linked) DB seemed to fix it. Not any more. Here's the current scoop:
When trying to look at our data using simple forms, the error message "Invalid Argument" appears and #Name? appears in a bunch of the fields.
We have tried Compact and Repair multiple times.
I created a totally new DB, imported all the objects - queries, reports, macros, objects etc. - exact same result.
When we run a certain query, the data appears momentarily, but the error message "Invalid Argument" appears on top of it in a window. When I click OK, all the data turns again into #Name?
We created a new query using the *, calling all fields, all records. Worked fine.
Added a simple criterion on a text field, back to the "Invalid Argument" error.
I took away the criterion, made it a Make-Table query, at runtime got the error message.
Made it back into a select query, tried to export to a text file, got the same message.
So it appears there's something bad in the table where it won't let itself be properly queried or exported. Do these additional clues give anyone an idea what's wrong with our DB?
With kind thanks to any DB Master who helps solve this puzzle,
Dan
Orlando, FL
When trying to look at our data using simple forms, the error message "Invalid Argument" appears and #Name? appears in a bunch of the fields.
We have tried Compact and Repair multiple times.
I created a totally new DB, imported all the objects - queries, reports, macros, objects etc. - exact same result.
When we run a certain query, the data appears momentarily, but the error message "Invalid Argument" appears on top of it in a window. When I click OK, all the data turns again into #Name?
We created a new query using the *, calling all fields, all records. Worked fine.
Added a simple criterion on a text field, back to the "Invalid Argument" error.
I took away the criterion, made it a Make-Table query, at runtime got the error message.
Made it back into a select query, tried to export to a text file, got the same message.
So it appears there's something bad in the table where it won't let itself be properly queried or exported. Do these additional clues give anyone an idea what's wrong with our DB?
With kind thanks to any DB Master who helps solve this puzzle,
Dan
Orlando, FL