If you get 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."when you try to delete a linked table or edit a query then you have just discovered a bug in Access 2007. I'm sure you have guessed but the problem lies somewhere within the linked table path. Either the name of the database or the path to the database has a character that Access 2007 doesn't like. I know this causes a problem with the apostrophe ' character and the square brackets [ ] and I'm sure many others also.
The fix:
Simply remove the offending character and relink the tables through VBA.
You can also create a new db and import all objects except for the linked tables.
No comments:
Post a Comment