>>failed to execute some query for 1 or 2 users most of the time for each button/function.

It depends on what you mean by "fail".
Having 3 concurrent queries in Access can make it take 1/2 second instead of 1/3 sec, but It CANNOT make it fail.
If it failed, (check for any error message), it might simply be a CFLOCK issue in the code, rather than an Access problem,
and upgrading to MSSQL won't solve the problem.

--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to