At 2004-05-12 14:11, Alex Gemmell wrote: >Also, I heard that converting the .mdb file to a .dbf file might help ? but how do I connect to that with PHP? The PHP manual says this about dbase functions: >?These functions allow you to access records stored in dBase-format (dbf) databases. There is no support for indexes or memo fields.? >That?s no good because I have long text fields in the Access database that are of type ?memo?! >The Manual also says ?we recommend that you do not use dBase files as your production database? ? eek! It?s only a small database (one table with about 50 records, each with no more than 20 fields) so hopefully it will suffice. What it basically says is that you shouldn't use .dbf formats to operate a database with, but only to transfer (import) data. I prefer however to use the comma separated value's (.csv) format that most database programma's can export and import: Jaap,van Ganswijk,"this is comment, which contains a comma" I prefer it because it's human and inter architecture readable. In PHP you can read it quite easily using the getscsv() function, like: if ($hf=fopen(..)) { while ($E=getscsv($hf)) { $A[]=$E; } } For setting up a simple database, why not just read the whole file each time? You could also look into the adb() funtions, with gndb() as one of it's prominent members. That way you will have indexes within your database and can read single entries. Another way is to use the serialize() and unserialize() functions to store complex (PHP-style) datastructures within a file or within the datafield of an adb() database. Check out phpinfo() on your hoster's system to see what is available. Greetings, Jaap -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php