Access vs ???

[YoungBuck]

I've read in a few places that Microsoft Access has some issues when it comes to holding larger amounts of data and I was wondering if there was any truth behind this and if there is what is the people's champion in holding theoretically infinite data?

[JasonS]

I've had problems with Jet3.5x databases when importing large amounts of data (usually over 500,000 records). Don't know about jet4.

[Nathan]

If you have money then I would suggest a SQL Server database. It is really fast and powerful and holds as much data as you can put into it. But... it's not as cheap as Access...

[murtagh]

I believe it is possible to get a Oracle8i Personal Edition
from Oracle go to this address for the download.

you have also to register first

http://technet.oracle.com/software/products/8i_personal/software_index.htm

This is a free download (if only for personal use, come with one license) I have the Linux edition and its ain't to be sneezed at.

Its 462mb by the Way



Hope this helps

[murtagh]

Opps sorry made a mistake in the last post;

Personal Oracle8i Release 2 Version 8.1.6 for Windows NT/2000 is a 462 MB download


and


Personal Oracle8i Release 2 Version 8.1.6 for Windows 98 is a 194 MB download



Oh and this is what they print about it;

Oracle8i - Personal Edition
Oracle8i Personal Edition is the most powerful desktop database available on the market today. By bringing the award-winning functionality of Oracle8i to the personal computer, Oracle offers a database that combines the power of the world's most popular database with the ease of use and simplicity you'd expect in a desktop product. Especially popular with consultants, developers and students, Oracle8i Personal Edition is the full-featured version of Oracle8i, targeted at individuals who require full compatibility with the entire Oracle8i database family. Oracle8i Personal Edition superior ease of use enables you to efficiently harness the ever-increasing power of PCs for development, by using advanced replication and distribution features to easily deploy your work in an Oracle enterprise environment.

go to http://www.oracle.com for deatils