Split database- linking tables

[SBOFCL]

I am trying to split my database and separate all the data tables and a
frontend with forms, reports, etc. I am able to link my tables with no
problem. But then I try to delete the links to then link to another with
test data, but I am not able to delete the linked tables. I get the
following error message:
" is not a valid name. Make sure that it does not include invalid characters
or punctuation and that it is not too long.

I've done this hundreds of times but am just getting used to Access 2007.
It works fine trying to link to other databases. Just not the database and
tables I need.

Am I missing something simple?

 

[Jeff Boyce]

Try this...

Create a new empty database.

Link to the back-end tables.

Does it work? If so, the other "front-end" may be corrupted. You'll need
to import all the objects from it, as well as link to the back-end/data.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.