Solved

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

Posted on 2002-07-08
5
437 Views
Last Modified: 2007-11-27
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
0
Comment
Question by:cookbook
5 Comments
 
LVL 8

Expert Comment

by:drittich
ID: 7137470
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
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 7137547
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
 
LVL 8

Expert Comment

by:drittich
ID: 7137610
That would be the DSN name...
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 7138545
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
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8145068
Administrative Action - PAQ'd and points NOT refunded

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now