Could Not Lock File Error 3050 - Microsoft Access / VBA

Network users with read-only access are getting this error message when
another user is in the database. Any suggestions on how to fix this
problem??
Thanks!

Jan 6 '06 #1

Subscribe Post Reply

19468

Allen Browne

I suspect Access is attempting to open the database (or ldb) with write
access, and of course that is failing.

What happens if you open the database from a shortcut that uses the /ro
switch to explicitly open it read-only?

Example target for the shortcut:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\MyFile.mdb"
/ro

(Another possibility is that the original use has the database open
exclusively.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"El" <em*@iastate.edu> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Network users with read-only access are getting this error message when
another user is in the database. Any suggestions on how to fix this
problem??
Thanks!

Jan 6 '06 #2

Similar topics

OPENDATASOURCE: text file as input ?

by: Jim Andersen | last post by:

Version 2000. How do I do something like the example SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended...

Microsoft SQL Server

DLL Lock Issue

by: Programmer | last post by:

Hi everyone Well here is my problem I hope you can help me

.NET Framework

Error: Invalid PInvoke metadata format

by: Gacu | last post by:

Hi, An unhandled exception of type 'System.TypeLoadException' occured in system.dll Additional information: Invalid PInvoke metadata format Im getting this error afrer calling...

C# / C Sharp

"could not write to output file" problem

by: Daniel Billingsley | last post by:

Today I went to compile a solution I've been working on for months. I've been off most of the last few months, so there's been a gap in the work, but I did compile it a few times earlier this...

C# / C Sharp

Could not lock file error

by: TechniCT | last post by:

I am very new to working with Visual Studio, and I am trying to display information from a MS Access database in an asp webform. The adapter, connection, dataset, and datagrid setup have been no...

ASP.NET

File lock failure

by: Gary Nelson | last post by:

Anyone have any idea why this code does not work? FileOpen(1, "c:\JUNK\MYTEST.TXT", OpenMode.Binary, OpenAccess.ReadWrite, OpenShare.Shared) Dim X As Integer For X = 1 To 26 FilePut(1, Chr(X +...

Visual Basic .NET

Could Not Lock File Error 3050

by: El | last post by:

Users on the network with read-only access are recieving this error (Could Not Lock File Error 3050) when trying to open the database when another user is currently using the database. Any idea...

Microsoft Access / VBA

Releasing lock on a text file?

by: David Veeneman | last post by:

Is there any way to forcibly release a lock on a text file, so that it can be deleted? I am testing an order-processing site that saves transaction information in a text file that it attaches to...

ASP.NET

Error "Could not save; currently locked by another user."

by: fniles | last post by:

One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...

Visual Basic .NET

Print Pdf file problem after publish on ISS server

by: subhash123 | last post by:

no error mesage come for print related , but say print successfully but there is not print any pages, my code for print is String pathToExecutable = @"C:\Program Files\Adobe\Reader...

.NET Framework

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA