Help needed in linking to tables using Access 2007

B

Bill F

I am using Access 2007 with Windows Vista. I am getting the following
compaction error after linking tables from another data base and performing a
compaction - repair:

ErrorCode -1002

ErrorDescription - '|' 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

This occurs when both dbs are either in Access 2007 format or when both are
in Access 2000 format.

I can import the tables instead of linking them and there is no problem.
After the tables are linked and the db is compacted, the linked tables will
not delete.

Any help would be appreciated.
 
M

Michael

Hi Bill,

Not sure if this helps...
Are all the relationships correct in the database that contains the tables
you want to link? Do all the tables have a primary key?

The database you want to link the tables to, does it have tables and
relationships too? Do they conflict with the linked database?

Sorry that's all I can think of...
Cheers
Michael
 

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

Similar Threads

Help creating a search form in Access XP 0
Split database- linking tables 2
Link to excel table which has keys in both row and col headers: isthis possible? 0
Unable to delete linked table in Access 2007 20
Access 2007/sql2008 ODBC issue 1
Linked Table Manager in Access 2007 0
linking tables and relationships 3
Access 2007 - SharePoint relink lists command 3

Top