From: William M. <ne...@ma...> - 2005-02-02 19:29:27
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, is there any reported problem in working with >1GB .mdb files? I have no problems working with small files. I made some testing with ~10MB files and I was able to list tables, export structures and data. Larger files are "ignored", no tables listed, no data extracted. I tried 0.6pre1 on a Slackware 10.1 box. Any clue? Thx -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCASn+1ALxG2OcY+8RAiHVAJ44NCBcGrr1uuneHoleowbScuqcVwCffk8M EwCpJl12tU1OHgKS3biLngE= =pq3M -----END PGP SIGNATURE----- |
From: Matthew P. <mp...@he...> - 2005-02-03 00:57:23
|
On Wed, Feb 02, 2005 at 08:29:03PM +0100, William Maddler wrote: > is there any reported problem in working with >1GB .mdb files? > I have no problems working with small files. > I made some testing with ~10MB files and I was able to list tables, > export structures and data. > Larger files are "ignored", no tables listed, no data extracted. >=20 > Any clue? I'm not an mdbtools hacker, but I don't know of any limitations on larger files (and 1GB seems like an odd place to stick a limitation), but in my experience mdbtools is less forgiving of MDB corruption than Jet is, and larger files do like to get corrupted far more than small files do. I have observed corrupted MDB files which don't list any available tables, as well as a wide variety of other f**ked up symptoms. I'd run a complete repair/cleanup over the big files before going too far down the path of looking for size-limit bugs in mdbtools. - Matt |
From: Sam M. <pa...@gm...> - 2005-02-03 02:39:35
|
I've experienced issues myself with corrupt db's returning errors - loading them up into to Access and repairing them seems to fix most cases. On Thu, 3 Feb 2005 11:57:11 +1100, Matthew Palmer <mp...@he...> wrote: > On Wed, Feb 02, 2005 at 08:29:03PM +0100, William Maddler wrote: > > is there any reported problem in working with >1GB .mdb files? > > I have no problems working with small files. > > I made some testing with ~10MB files and I was able to list tables, > > export structures and data. > > Larger files are "ignored", no tables listed, no data extracted. > > > > Any clue? > > I'm not an mdbtools hacker, but I don't know of any limitations on larger > files (and 1GB seems like an odd place to stick a limitation), but in my > experience mdbtools is less forgiving of MDB corruption than Jet is, and > larger files do like to get corrupted far more than small files do. I have > observed corrupted MDB files which don't list any available tables, as well > as a wide variety of other f**ked up symptoms. > > I'd run a complete repair/cleanup over the big files before going too far > down the path of looking for size-limit bugs in mdbtools. > > - Matt > > > |
From: Tony T. <to...@gr...> - 2005-02-03 05:10:08
|
At 12:39 PM 02-03-2005 +1000, you wrote: >I've experienced issues myself with corrupt db's returning errors - >loading them up into to Access and repairing them seems to fix most >cases. FWIW the only real way to ensure Access MDBs are free from corruption is to also import them into a new MDB. Just repairing isn't always sufficient as minor corruptions can still exist and thus grow in major corruptions. This is according to Peter Miller of PK Solutions who retrieves data from corrupt MDBs. >Based on the Page Usage Maps section of the HACKING document, >there is a theoretical limit of about 1GB for Jet3 and 2GB for >Jet4. I have not worked with any files of that size, so I do >not have any first-hand experience. This is correct. There's a misleading error that occurs once the MDB gets too large. I forget the exact text though. Tony ----- Tony Toews, Microsoft Access MVP Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
From: Jeff S. <why...@ya...> - 2005-02-03 04:09:53
|
--- William Maddler <ne...@ma...> wrote: > is there any reported problem in working with >1GB .mdb files? > I have no problems working with small files. > I made some testing with ~10MB files and I was able to list tables, > export structures and data. > Larger files are "ignored", no tables listed, no data extracted. > > I tried 0.6pre1 on a Slackware 10.1 box. > > Any clue? Based on the Page Usage Maps section of the HACKING document, there is a theoretical limit of about 1GB for Jet3 and 2GB for Jet4. I have not worked with any files of that size, so I do not have any first-hand experience. In checking the Changelog, I made a few changes/bugfixes back in August 2004 that might affect this, so you might see if it works better (or worse) with the CVS version of mdbtools. -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail |