Hi Folks
	I am running a rather large Access 2000 application on a Win 2000
computer, the application makes a number of ADO connections to an Oracle
server, using OLEDB. My problem is that every now and again, and seemingly
randomly, I get the following error reported:

Error 3052: File sharing lock count exceeded. Increase MaxLocksPerFile
Registry entry.

The error stops the file executing, but on clicking the OK, it carries on
running as if nothing has happened, and there seems to be no detrimental
effect on the data output. I know I could capture the fault through the
OnErrorEvent, but I would be interested if anybody else has had a similar
problem, and indeed how I can change the MaxLocksPerFile registry entry,
there seems to be no entry for this in my help files. 

Thanking you in advance.

Cheers 
Russell

**********************************************************************
This Email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this Email in error please notify 
the system manager.

This footnote also confirms that this Email message has been swept by 
MIMEsweeper and Norton Anti-Virus for the presence of computer viruses.

**********************************************************************
        VISIT OUR WEBSITE AT HTTP://WWW.DOMINO-PRINTING.COM/
**********************************************************************

Russell,

This sounds like it may be an Oracle issue.  You may want to post this 
on an
Oracle forum.  I think you ma have a better chance of finding an answer
there.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Jacobs, Russell [mailto:russell.jacobs@d...]
Sent: Wednesday, March 20, 2002 8:11 AM
To: Access
Subject: [access] Error 3502

Hi Folks
        I am running a rather large Access 2000 application on a Win 
2000
computer, the application makes a number of ADO connections to an 
Oracle
server, using OLEDB. My problem is that every now and again, and 
seemingly
randomly, I get the following error reported:

Error 3052: File sharing lock count exceeded. Increase MaxLocksPerFile
Registry entry.

The error stops the file executing, but on clicking the OK, it carries 
on
running as if nothing has happened, and there seems to be no 
detrimental
effect on the data output. I know I could capture the fault through the
OnErrorEvent, but I would be interested if anybody else has had a 
similar
problem, and indeed how I can change the MaxLocksPerFile registry 
entry,
there seems to be no entry for this in my help files.

Thanking you in advance.

Cheers
Russell

**********************************************************************
This Email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they 
are addressed. If you have received this Email in error please notify
the system manager.

This footnote also confirms that this Email message has been swept by
MIMEsweeper and Norton Anti-Virus for the presence of computer viruses.

**********************************************************************
        VISIT OUR WEBSITE AT HTTP://WWW.DOMINO-PRINTING.COM/
**********************************************************************