Delete link table error mesage

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.
 
R

rbeach

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.
 
R

rbeach

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.
 

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