Print Manager Plus / Web credit tool

[cookie_monster]

We use Print Manager Plus and use the web tool that allows users to view how many credits they have left. This used to work perfectly but since moving to a new server it only seems to work about 50% of the time.

Occasionally users receive the error below and i can't see why if it was all ths time it would be easier to troubleshoot, does anyone else here use this tool?

Thanks.

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use. 

/euit.asp, line 25

[sharkster]

what version are you using?

[cookie_monster]

6.0.0.123

[Michael]

I noticed you're using an Access database. Could it be something to do with the concurrent number of users accessing their credit?

MS SQL would be more suitable and I'm pretty sure you can install PMP using SQL. I personally use the desktop client, so users can view their credit in the Taskbar/notification area.

[plexer]

The access db version and everything associated with it is pretty poor.

Ben

[srochford]

As Michael says, it's almost certainly a limitation of the Access db which copes badly with multiple accesses (particularly if one process is trying to read data from a table which another process is updating).

If you can upgrade to a SQL version then I would do that (many companies give the option of using MSDE or SQL 2005 Express, both of which are free).

If this was code you had written yourself then you would need to just change the connection string so that it pointed to the SQL db rather than the Access db - ConnectionStrings.com - Forgot that connection string? You will find it right here! is a good place to find connection strings.

[cookie_monster]

Yes we're thinking about updating to the sql version but it produces this error when only one person is using the tool and as i say it did work very well before.