Click to See Complete Forum and Search --> : PHP & MS Access
scojo1
08-17-2005, 11:25 AM
I'm trying to create a web interface for a access database. I thought the database was done in SQL, but much to my disappointment, it isn't.
Is there any clean and easy way to create a connection with an access database (without installing UnixODBC, or other packages)?
I'm running Apache and PHP on Fedora
scojo1
08-20-2005, 10:54 PM
a last question. After some research, it appears that 'upsizing' the access database to SQL would be the best. Has anyone out there done this?
invertedpanda
08-20-2005, 11:18 PM
Regarding conversion: Yeah.. and it can be a bit of a chore. If it is a relatively simple DB, it should convert with only a few minor things that will need changing. Larger, more complex databases, tend to not convert too well..
scojo1
08-22-2005, 01:32 PM
thanks for the reply, for some reason, my company is stuck in the past (using office 97) I think I'm going to go ahead and try to convert to SQL by first upgrading the db to SQL 6.5 then the SQL 6.5 to 2000, I don't really want to mess with creating odbc connections to get the php to work