Link Table problem with invalid name in Access 2007

[colintis]

Hi guys,

Is there anyone who had and resolved a problem with linked tables? The database works normally while I do the work with Access 2003, but when my PC had upgrade to use Access 2007, I cannot see the table list through the Link Table Manager, and when I tried to delete the link tables it popped out an error message saying:

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

The database can import the link tables from the same back-end database, but those tables are renamed instead of replacing the old one. How can I resolve this question? Thanks

Colin

[NeoPa]

See Access 2007 Linked Table Manager Not Working Correctly and Link Tables in VB. One of them should help you.

[colintis]

I tried both methods, but still the Link table manager still not showing anything. I guess I will solve this solution by re-importing the link tables whenever there's need..

[MMcCarthy]

I cannot see any reason for this.

Did you convert your database from 2003 to 2007 or did you just open it in 2007?

Did you create the original backend using the database splitter option or did you do it manually? The database splitter option is known to have issues which is why most developers will do it manually.

If you create a new link to the backend does that appear on the linked table list the next time you open the database?

[colintis]

@msquared
I have convert the database from both 97 and 2003 to 2007, both databases have their backends also convert to 2007, but its still not able to view from the link table manager.

I also had a full 97 database and used the splitter option after convert into 2007 with the same result. What is the mean by doing manually? Do you mean creating a new database and import all tables from the originally one, msquared?

No, even creating new links to the backend still are not appearing, I also have trouble with implementing a link table from a excel spreadsheet, the Access went to the error and restart the database. The worksheet was successfully imported from the older version of Access, and its strange that I can get it import the link table from another backup database.

Also, when I import the tables and stuffs from the old database, I didn't see the "MS...." table mentioned from the link given by NeoPa.

[NeoPa]

Front-End / Back-End (FE/BE) may help to explain what doing it manually is about.

[MMcCarthy]

@colintis
This is starting to sound more like a problem with the Access 2007 installation. Have you got all the office updates downloaded? I think Office 2007 is on sp2

[colintis]

yes its on sp2, while the Access 2007 is installed from the IT department in another city by remote control. Also, the access version used in my PC keeps changing between 97 and 2007 due to work needed, everytime after running access in 97 ver, 2007 will perform an install process when I swap over again.

[MMcCarthy]

As a test, create two brand new database files in Access 2007. In the first db1.mdb create a test table (doesn't have to contain much). In the second try to link to the table in the first database. Then save and close.

Now if the second database holds this link OK then we know the problem is not with Access 2007 or vice versa.

[colintis]

@msquared
I had create 2 database in both .mbd and .accdb version (2 on each), make a few records in table1 and link them from database2. I saved, closed and opened database2 and click on the link table manager, but still the list inside is blank. If so should I be do a re-install to Access 2007?

I'm not sure if the program is affect for swapping between Access 97 and Access 2007. As everytime when I open a database in 2007 after opening with 97 in previous, it will proceed the install wizard before open.

[James Sh]

It might be. If your IT department has a virtual machine (VMWare, Citrix, etc.) you could use to run Access 97, it might solve your problems.