hI.
Well, I have used Access Db's for ages now (2.5 years I think) under Delphi
and have had the ODD hickup but CERTAINLY not as many as I had with Paradox.
In the area of corruption, yes it can happen, BUT it is pretty easy to fix.
You can either write a wee tool to do it, or include it in your start-up
code where it automatically does a repair and compaction wheither it need
it or not.
This was a trick learned back in my VB days.
This will get rid of any corruption problems. OTHER than the user turnig off
their PC and not shutting Things down.
There are a number of ways of accessing Access, either via components (I use
Titan for Access but there are better ones) or via ADO or the DAO engine's
themselves.
cheers,
Jeremy Coulter
Application Developer
Application Development Centre
Compaq Computer New Zealand Ltd.
Phone: 64 3 371 5724
Fax: 64 3 371 5724
Mobile: 64 0212533214
E-mail: [EMAIL PROTECTED]
Personal Email: [EMAIL PROTECTED]
-----Original Message-----
From: Terry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 11, 2000 12:00 PM
To: Multiple recipients of list delphi
Subject: [DUG]: Access v Paradox
Hi All,
The current project I'm working on has an existing Access db containing a
dozen or so tables. I've worked with pdox in the past with reasonable
success, but as with most MS products, I'm a bit cautious about Access.
Specifically;
1. Too many eggs, not many baskets. Being a single flat file, if you get
that screwed up, you lose everything. Or do you? With Pdox, at least the
various table data is isolated in separate files, so recovery is more
probable...
2. What's the stability like? How vulnerable are Access dbs to corruption?
Are there good tools to fix them?
3. Speed with large dbs - as the files grow, does paradox have (or lose) an
edge?
TIA,
Terry
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
