Hi All,
I have been using MS Access 2002 to attach (link) to DBA tables for the past 6 weeks with great success via ODBC.
This morning, I tried to access a table I have already linked to, MTICMSTR and I receive this error message;
“MTIC_PROD_SPECS[ 1] is not a valid name. Make sure that it doesn’t include invalid characters or punctuation and that it is not too long.”
I have rebooted the server, CHKDSK'd it and run DISKEEPER (a defrag ustility).
I have also re-indexed that particular file in DBA to no avail.
The really wierd thing is I have used this exact configuration for 6 weeks without a problem.
I can still access all the other files in DBA without a problem.
Has anyone seen this eror B4 and can you help me fix it?
Thanks!
James Taylor
http://www.AICompany.com Web Design, Web Hosting and Search Engine Optimization