Link table problem

Link table problem

Post by Richard L » Sun, 14 Sep 2003 16:05:41


Here's the problem. On a test Windows 2000 machine, I copied over an Access
2000 database which, in addition to some native tables, also contains 7
linked DBase tables. Access will open/display 6 of the linked DBase tables.
When you attempt to open the 7th table, the cursor will change to busy for a
moment, and that's it -- no error message or anything.

On both my development machine (from which I copied the data, also running
Windows 2000 and Access 2000) and the client's machine, all 7 DBase tables
will open fine. No problems. And I doubled checked -- the paths are all
the same. All the DBase tables are from the same application.

I also tried to delete and recreate the link to the problem table on the
test machine. No problem deleting the link. But I'm not able to recreate
the link. In the Link dialog, when I select the DBase file and click on the
Link button, nothing happens.

I copied the data from the development machine, several times via LAN,
floppy and even a ZIP file, just in case the file was being corrupted
somehow in the process of copying. Didn't help any.

The test machine is a clean install of Windows 2000 with SP 4 and .Net
Framework 1.1. After my program encountered the problem with the database,
I eventually installed Access 2000 to check the database with. That is when
I discovered this problem. I also tried installing Office SR-1. That
didn't help. I also did an Office Setup repair. Didn't help either.

There doesn't seem to be anything special about the table. 64 records, the
DBF file is 52K.

Anyone have any ideas?

Richard Rosenheim
 
 
 

Link table problem

Post by Richard L » Tue, 16 Sep 2003 20:48:26

Here's a follow-up. I took a clean Windows 2000 Server install, installed
IE 6, then W2K SP 3, and then finally Office 2000. I was able to open and
display that linked DBase table in Access.

I then took a clean Windows 2000 Server install, installed IE 6, then W2K
SP4, and then finally Office 2000. The problem with the one linked DBase
table reoccurred -- Access would change the cursor to busy briefly, then
nothing.

Richard Rosenheim



Access
tables.
a
the
database,
when
the

 
 
 

Link table problem

Post by YnVydF9raW » Tue, 29 Aug 2006 23:32:01

When I try to link a table in Access 2002 to a database with 30000 tables it
only shows me one table. For those in the office with Access 2003 it works
fine, albeit slow, and shows all the tables.

Is this a bug in 2002 and how do I fix it?
--
XXXX@XXXXX.COM
 
 
 

Link table problem

Post by S2xhdHV » Tue, 29 Aug 2006 23:45:02

Do you really mean 30000 table? If so, your database is a real mess. There
never should be that many tables in any database. Why are there so many?
 
 
 

Link table problem

Post by YnVydF9raW » Tue, 29 Aug 2006 23:59:03

Yes, I really mean 30000 tables. It's a PeopleSoft server and that's how
many they ship. Do you have a solution?

--
XXXX@XXXXX.COM
 
 
 

Link table problem

Post by S2xhdHV » Wed, 30 Aug 2006 00:05:02

Sorry, I assumed, because you didn't state otherwise in your original post,
it is an Access database. I don't have a solution for you. I believe
PeopleSoft is an Oracle database, and I have no experience with that;
however, I would guess that if it works in 2003, it should in 2002.
 
 
 

Link table problem

Post by YnVydF9raW » Wed, 30 Aug 2006 00:38:02

Sorry, wrong assumption. It's a sql server database. I've got a client
trying to set up a linked table from Access 2002.
--
XXXX@XXXXX.COM