matifibrahim wrote:
1. Can I put Access (.mdb) files on linux machine ?????
Yes. Please use fewer question marks in future. One per question will usually suffice.
2. what is simplest method available to use them from php ????
It's nontrivial. You can't do so easily.
Your best bet would be to buy a commercial ODBC driver for Linux which supports MSAccess files. I haven't used any of these in production so I can't recommend one.
Microsoft access databases are generally considered unsuitable for production use in a web application. The reasons are several. My experience on Windows suggests that:
- MSAccess is very slow
- It loses data often
- Concurrency is very poor
All of these things make it unsuitable for production use.
In particular, the locking does not work properly over a network (no matter what Microsoft say), therefore using it concurrently by more than one user or application over a network is unsafe. A single failure (during a network operation) will typically cause your database to be permanently corrupted.
Please consider an alternative solution.
Mark
