Hi,
I've been coding PHP4 with MySQL, and now have to build a hitcounter using MS Access database.
That's been going well without any big problem, until I've encountered some severe problems. When analyzing the problem I've discovered that when 2 people access the statistics screen at the exact same time (within let's say a second) one of the 2 people get the error that the datasource is already in use, and get all sorts of odbc errors right after that. If the user refreshes (and is lucky to be the only one at the database) everything goes well.
The same seems to be happening when logging user counts. When 2 people visit a page at the same time, only one of them is recorded, the other one is not logged.
I'm using odbc_connect, but perhaps I should do something to ensure 2 people (or more) can be logged at the same time (at least!!) and preferably, 2 people (or more) can show the result page at the same time.
Does anyone have experience with ODBC / MS Access ? I'm using Access 2000 to create the database (and multi use is on I believe) and use PHP4 (phpts.exe in CGI mode).
If someone has a clue how to be able to enable two or more users at the same time; please tell me! It would help alot if e.g. the statistics screen would be "read only" access to the database (but how ;-))
Greetings,
Martin.
