Solved

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

Posted on 2002-07-08
5
456 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# Gridview does not exist in the current context 14 70
toggle checkboxes when a checkbox is checked 16 54
Import csv files to MS SQL 5 81
ASP CDO - Limiting Connections 2 50
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 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

16 Experts available now in Live!

Get 1:1 Help Now