Delete link table error mesage

  • Thread starter Thread starter rbeach
  • Start date Start date
R

rbeach

When attempting to delete a link for any of my tables I receive the error:

" is not a valid name. Make sure that it does not include invalid characters
or punctuation and that it is not too long.

I cannot remove any linked tables in any database. I have created a new
database and linked tables to the new database and receive the same error
when attempting to remove the link.

Has anyone experienced this and how do I fix this.
 
There is also an error when I add a table to my database and do a compact and
repair. I created a new database and added 1 link table. If I do a compact
and repair I receive a MSysCompactError table with the following:

ErrorCode: -1002
ErrorDesc: '|' is not a valid name. Make sure that it does not include
invalid characters or punctuation and that it is not too long.
ErrorTable: MSysRelationships

I do not have any relationships. There is only one linked table in the
database.

Any assistance is appreciated.
 
After review, I have found that there was an apostrophe (') in one of the
folder names within the path to the database back end. Once the Network Admin
changed the folder name, the database works correctly. This was just improper
naming conventions used on the network.
 
Back
Top