receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"
i need to have multiple users being able to access the database at the same time
9  8003 
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"
i need to have multiple users being able to access the database at the same time
It sounds as though a user has it opened for exclusive access. Are people likely to be using it directly through MS Access, or only through your application (assuming there is an application)?
I believe you can set an option in Access that determines whether the default action is to open databases exclusively, or shared. If you're using VB (if so, what version?), then you use a parameter when you open the database to specify whether it is for exclusive use.
It sounds as though a user has it opened for exclusive access. Are people likely to be using it directly through MS Access, or only through your application (assuming there is an application)?
THE APPLICATION IS OPENED FROM THE DESKTOP USING A SHORTCUT CREATED FROM AN ACCESS MACRO WHICH DOES OPENFORM OPERATION
I believe you can set an option in Access that determines whether the default action is to open databases exclusively, or shared. If you're using VB (if so, what version?), then you use a parameter when you open the database to specify whether it is for exclusive use.
VB 6.3 HOWEVER MY FILES ARE OPENED BY THE FORM
THE APPLICATION IS OPENED FROM THE DESKTOP USING A SHORTCUT CREATED FROM AN ACCESS MACRO WHICH DOES OPENFORM OPERATION
...
VB 6.3 HOWEVER MY FILES ARE OPENED BY THE FORM
Ok, now you've lost me completely. If you are using an Access macro to open an Access form, then where does VB6 come into it?
Ahah! Now I get it. This is VBA version 6.3, built into Access. Now it's starting to make a little sense, at least.
I think you need to check your Access settings ( Tools | Options | Advanced) for that database to see whether it is being opened for exclusive use by default.
Since this appears to be largely an Access problem rather than VB, I'm going to move this to the Access forum - we should find more help there.
DEFAULT OPEN MODE = SHARED
DEFAULT RECORD LOCKING = NO LOCKS
OPEN DATABASE USING RECORD LEVEL LOCKING IS CHECKED
DEFAULT FILE FORMAT = ACCESS 2000
Ok, now you've lost me completely. If you are using an Access macro to open an Access form, then where does VB6 come into it?
Ahah! Now I get it. This is VBA version 6.3, built into Access. Now it's starting to make a little sense, at least.
I think you need to check your Access settings (Tools | Options | Advanced) for that database to see whether it is being opened for exclusive use by default.
MMcCarthy 14,534
Recognized Expert Moderator MVP
DEFAULT OPEN MODE = SHARED
DEFAULT RECORD LOCKING = NO LOCKS
OPEN DATABASE USING RECORD LEVEL LOCKING IS CHECKED
DEFAULT FILE FORMAT = ACCESS 2000
These settings should allow the database to be opened in multiple locations (although I would recommend change Default Record Locking to Edited Record).
Back to your problem. Do you know which machine has it open at the moment. Is there any problem with that machine? Have you tried to close the database on that machine?
Mary
ADezii 8,834
Recognized Expert Expert
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"
i need to have multiple users being able to access the database at the same time
__1 You will get this exact message when you have a Database Opened and an Object contained within it, say a Form, is in Design View. If you now try to open another Instance of this Database you'll get "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"
__2 If that is not the problem, close the Database and see if you have a .ldb file with exactly the same base name as the DB e.g. Employees.mdb ==> Employees.ldb. If this file exists once the Database has been closed, deleted it.
receiving error message "the database has been placed in a state by user .... on machine ......that prevents it from being opened or locked"
i need to have multiple users being able to access the database at the same time
Hi did u finally get the solution to this problem? coz am also experiencing the same problem
NeoPa 32,566
Recognized Expert Moderator MVP
If you read through the posts and you'll find the solution :confused:
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: delete table with Visual Basic 6 |
last post by:
Dear developer,
I have an error message when I try to delete or drop Microsoft Access XP
table with ADOX in Visual Basic 6. I use the ADOX.Catalog and ADOX.table to
create and delete or drop table within Visual Basic program.
If anybody knows how to solve the problem, please give me the solution.
I would like to thank you for your attention...
|
by: Jim Hubbard |
last post by:
It seems that Microsoft not only does not need the classic Visual Basic
developer army (the largest army of developers the world has ever seen), but
now they don't need ANY Windows developer at a small or mid-sized business.
...
|
by: Steve |
last post by:
Having only recently migrated across from VB6 to VB.NET I'm still
unsure whether or not I should be making (heavy) use of the
Microsoft.VisualBasic namespace in new applications. I've read a lot
of posts in the (VB).Net newsgroups and seen just about all of the For
and Against arguments i.e. not using it = not coding in VB.NET, not
using it =...
|
by: bbdobuddy |
last post by:
Hi,
How do I open a Microsoft Access 2003 form from Visual Basic.net
Thanks in advance
bbdobuddy
|
by: Jim Hubbard |
last post by:
http://www.eweek.com/article2/0,1759,1774642,00.asp
| | |
by: nuoo |
last post by:
Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET
Learn how to turn data into solutions with SQL Server 2000, Visual
Basic .NET, and XML. Get a fundamental grasp of SQL Server 2000 data
access, data manipulation, and data definition T-SQL programming
techniques, Visual Basic .NET language enhancements, Microsoft Visual...
|
by: Nick |
last post by:
Hi
Has anyone encountered the "readonly" issue with Microsoft Forms 2.0 TextBox
?
The locked property of the control seems to have no effect - always enabled
regardless of whether it's set to True or False.
It has some really nice properties and Im using it in my project.
I managed to google a post of someone having the same problem, but...
|
by: =?Utf-8?B?TWlrZTE5NDI=?= |
last post by:
This is an example that is supposed to work in VB
http://support.microsoft.com/kb/175512/en-us
After spending a couple of hours downloading and installing VB Express 2008
after someone told me it was easy, the thing doesn't work any better.
These two instruction lines are not functional
3. Place a Common Dialog control on the form.
4. From...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| | |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
