Nov 2 2009, 11:51 AM
Sorry if this isn't the right section.
I have been assigned an awful task here at work.
We have an old foxpro database that creates a couple of .dbf files. (I'll be re-writing those but right now time is of the essence). I then open an access (what looks like to be 2003 format) and import the .dbf files that foxpro created. Do some stuff there. I then have to open an access database in 2000 format and import that same .dbf file or the table from the 2003 database into it. But I'm getting all sorts of errors. The file is 75,000 rows or so, are there size limitations with 2000 or something?
Nov 2 2009, 12:32 PM
There is not a limit on the number of records in Access 2000 or 2003. What kind of errors are you getting.
Nov 2 2009, 01:08 PM
I get a dialog that states:
Cannot open database 'DED0911'. It may not be a database that your application recognizes, or the file may be corrupt.
I get this whether I try to import the table from the other access database or whether I try to bring it in from the original .dbf file.
However, I can import either format into other databases.
I just tried to export the table from the other access database as a .txt file (tab delimited), when I tried to import that I got the same error.
The size of the Access 2000 database is 2,095,108kb, am I bumping into a limitation there?
Edited by: beachrog on Mon Nov 2 13:19:02 EST 2009.
Nov 2 2009, 01:52 PM
2 gig is the max in Access 2000 and above. Try to compact and repair both of the Access databases and then try the imports again.
Nov 2 2009, 04:03 PM
That was it, got rid of about seven years of history and compacted and repaired and the table went right in smooth as butter.
thanks for the guidance.
Nov 2 2009, 06:09 PM
You are welcome.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here