Forgive my newbieness and I did search the forums first.
I have programmed some in Access and have had one Access db connect to another using several different methods. But this is my first attempt at an ODBC connection and my first attempt at sharing data via a web server.
Basically, I have a service running that collects syslog data sent from other machines. The syslog daemon opens an ODBC connection to an Access database and writes the data. No problem.
Now, I am trying to write php script to also open an ODBC connection and read some of this data via with an SQL query. But, I can't seem to open two ODBC connections at one time. If the syslog service is shutdown, no problem. But as long as it is open, it locks the database.
This is also my first use of Access 2007. But in my previous projects in Access 2003 and earlier, I have never had a problem with multiple users connecting to the database, only if they were writing to the same table.
Any help is appreciated. Perhaps I should be trying to connect a different way?
t
I have programmed some in Access and have had one Access db connect to another using several different methods. But this is my first attempt at an ODBC connection and my first attempt at sharing data via a web server.
Basically, I have a service running that collects syslog data sent from other machines. The syslog daemon opens an ODBC connection to an Access database and writes the data. No problem.
Now, I am trying to write php script to also open an ODBC connection and read some of this data via with an SQL query. But, I can't seem to open two ODBC connections at one time. If the syslog service is shutdown, no problem. But as long as it is open, it locks the database.
This is also my first use of Access 2007. But in my previous projects in Access 2003 and earlier, I have never had a problem with multiple users connecting to the database, only if they were writing to the same table.
Any help is appreciated. Perhaps I should be trying to connect a different way?
t
