Problem with connecting with Access Database when two records updated at the same time

Dear All,

I have big problem raised when I connect to access database by ASP.  When I updated two records on the access database, Error should be occurred at either updating process with following message prompted:

[Microsoft][ODBC Microsoft Access Driver]General error unable to open registry key"SOFTWARE\ODBC\Brazos volatile counter"

I would like to ask whether access database can be updated/accessed by two users at the same through webpage??

So, any solution to solve such problem? How can I change the program code to allow users to update the access database at the same time??
It's quite urgent, Anyone can help me!  Thanks a lot
cookbookAsked:
Who is Participating?
 
SpideyModCommented:
Administrative Action - PAQ'd and points NOT refunded

SpideyMod
Community Support Moderator @Experts Exchange
0
 
drittichCommented:
It sounds like you have aregistry permissions problem.  I recommend you sue a DSN-less connection instead.  Here is an example:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=c:\somepath\mydb.mdb;" & _
           "Uid=admin;" & _
           "Pwd=;"
0
 
Arthur_WoodCommented:
this sounds as if there is another issue, not related to Access---What is "Brazos volatile counter"?

It saounds as if you have some other software nvolved, that has a limit on the number of active "connections"  Is this a possibility?

0
 
drittichCommented:
That would be the DSN name...
0
 
jitgangulyCommented:
I remember I solved this sometiem back.
Would you please update your mdac and use MDAC 2.5

http://www.microsoft.com/data/download.htm 

Look at my answer here
http://www.experts-exchange.com/questions/Q_20095547.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.