I am making Apache, PHP based website with MS Access 2000 as database, and I would use ODBC as connection engine. I saw many descriptions of possible problems about security (for example - user can access database without username / password, and many other things).
Database was already made in MS Access, and data input is going on every day locally.
Any suggestion about security issue? Anybody uses connection to MS Access like this one?
Well yes and no. it all depends how tight security you can build. There are many ways to secure an Access DB. Try google on it you'll get tons of white papers on this subject. Everyone uses connections for web apps and others.