BackOffice Products
1863005 Members
1789 Online
110446 Solutions
New Discussion

Re: Windows98 - MS Access 2000

 
Michelle_34
Occasional Contributor

Windows98 - MS Access 2000

Another weird problem - I've got Access 2000 running on my Win98 Workstation. All works fine in the program, creating reports, queries, tables etc..but I am unable to "import or link" any dbf (foxpro 5) file into my access file. The error I'm getting is: External table is not in the expected format - #3274"

Yet if I go to any of our other 50 or so Win98 workstations in the office I can import or link the exact same files into Access 2000 with no problems or errors.

I'm wondering if I've installed some software that's conflicing with Access? I've tried removing it and reinstalling, but I'm still getting the same errors. I've even tried copying the DBF files from the server directly to my c:\ drive to see if that made any difference but still no change.

Any suggestions anyone?
5 REPLIES 5
Ganesh Babu
Honored Contributor

Re: Windows98 - MS Access 2000

give a try to reinstall the access 2000 and also check the conversion tools whether u had installed proper.

V.Ganesh Babu
Jorge Pinto Leite
Respected Contributor

Re: Windows98 - MS Access 2000

Michelle, I confess I didn't understand quite right your problem.
Do you mean that in W98/Access2000 wkst group A you can import foxpro5 dbf files, and in W98/Access2000 wkst group B you cannot import exactly the same files?
If so, the problem should be in Access installation on wkst group B.
Have you configured ODBC for Visual FoxPro? In any of the groups? Or is it by default?
Maybe you can try to uninstall Access2000, make syre that the ODBC for FoxPro is removed, and install Access again. And I would give a close look into any ODBC diferences between a wkst that can import and another one that cannot.
Keep us updated.
Jorge
John Pennington
New Member

Re: Windows98 - MS Access 2000

We are having the same problem here as well.
using Office2000 sp3, I have run spk5 on visual studio 6, but this does not solve the problem.
Does anyone have a clue ?
Jon Finley
Honored Contributor

Re: Windows98 - MS Access 2000

Try the following article from MS:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;225861

Jon
"Do or do not. There is no try!" - Yoda
John Pennington
New Member

Re: Windows98 - MS Access 2000

we stripped the latest service pack off the window2000 prof. having the problem. ( srv pk 4 ) and the problem was fixed.