Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best DB-Backend
Message
From
11/10/2002 11:37:33
 
 
To
11/10/2002 02:04:29
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Miscellaneous
Thread ID:
00710187
Message ID:
00710367
Views:
15
>Greetings!
>
>I've been asked to replace an existing Clipper-based db app with a newer, Windows/VB-based version. The old app used dbf files for its back-end database.
>
>Would it be better if I also "upgrade" the dbf files with an mdb file? I'll be using ADO and ODBC for the connection to a server-located database, where the database file sizes reaches upwards of 100mb per year (annual archiving and extraction prevents further ballooning of the files...)
>
>So in short, do I go with Access mdb, or stay with dbf? Which is better performance-wise for this setup?

Moving to an MDB would be a downgrade of capability and capacities; if you want to migrate away from DBF/DBC functionality, I'd investigate MSDE, which offers a very direct upgrade path to SQL Server in the event that the extra capacities and capabilities are required later. MDBs are just an easy way to hurt both performance and data integrity.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform