tekprof wrote:
Neil - I have had a devil of a time with using an ODBC-DSN connection with Access databases. It works fine as long as there is about a 60 second time delay between people who are entering data, but if two people should try to enter data at or near the same time the second person hangs and eventually times out.Jeff,When using ODBC connection, be sure to place the Access database in a folder where the internet user is given Full Control file permissions. When connecting to the database, Windows needs to create a temporary lock file on the database using the internet account. Once the connection is closed, it removes the temporary file.As long as Windows is able to create the temporary file, there will not be any collisions between multiple connections on the database.Please be aware though that Microsoft has hard coded a 5 connection limit to an Access database. They do this to get large systems to upgrade to their MS SQL Server software.
