Access 2.0 Multiuser Application - Microsoft Access / VBA

marifusman

Acees 2.0 application when user run application it give following
error.
The database is opened by user "Admin" on machine "abc". you can not
open this database exclusively.

Please help me
usman

Nov 12 '05 #1

Subscribe Reply

1772

Peter Steimann[MVP Access]

"marifusman " <ma********@yah oo.com> schrieb im Newsbeitrag
news:ca******** *************** ***@posting.goo gle.com...

Acees 2.0 application when user run application it give following
error.
The database is opened by user "Admin" on machine "abc". you can not
open this database exclusively.

Please help me

Then do not open the database exclusively or twice at the same time-;)

Sometimes, there is a .ldb-file remaining in the directory where the
database is. Delete it and try again

Peter

Nov 12 '05 #2

Larry Linson

"Peter Steimann[MVP Access]" wrote

Acees 2.0 application when user run
application it give following
error.
The database is opened by user "Admin"
on machine "abc". you can not open this
database exclusively.
Then do not open the database exclusively
or twice at the same time-;)

Sometimes, there is a .ldb-file remaining in the
directory where the database is. Delete it and
try again

As I recall, Access 2.0 does NOT ever delete the .ldb file. But, I did quite
a few multiuser databases in Access 2.0 and that was never a problem.

The kind of problem leads me to believe that the original poster has
multiple users attempting to open the same front-end or monolithic database.
That was as bad an idea in Access 2.0 as it is now and has been in every
intervening version. Every user should have his/her own copy of the front
end, linked to the shared tables in the back end.

However, this can also happen in cases of "mild" database corruption -- that
is, it's corrupted enough to be a problem but not enough to prevent all use.

Larry Linson
Microsoft Access MVP

Nov 12 '05 #3

Similar topics

5932

Access or Visual Studio?

by: Jerome | last post by:

Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy in Visual Studio to create reports and labels as it's in Access?` The advantage of VS.net is that not every user needs Access, right? And that would eliminate the Access version problem as well I guess.

.NET Framework

4091

Can't access temp-table in backend-db

by: Jon Ole Hedne | last post by:

I have worked on this problem some hours now (read many-many...), and I can't solve it: In vba-code I create a table with Connection.Execute, and add some data to it. This table is saved in the backend-database. After generating this table, I want to open a report based on a query with data from this temporary table. In the report's OnOpen event I set the report's record source to the query pointing to the temporary table. If I run...

Microsoft Access / VBA

12356

Limit of users in Ms-Access?

by: Hannu | last post by:

Hi. In the ldb file you can see the users of the mdb-file. If you open the mdb-file your machine and username will be written in the lbd- file. Allthough you close the mdb-file your name won't disappear from the ldb-file, before every user has closed the mdb-file. I have heard that there will be problems if the amount of users will be over 10 in mdb-files. Is that true? Hannu

Microsoft Access / VBA

1950

How robust is Access 2002?

by: David Kistner | last post by:

I'm fairly new to Access (I've worked with Oracle and MySQL in the past). I was asked to build an application for a small office and told that I had to use Access 2002. I was VERY uncomfortable with this, but went ahead anyway. So two weeks ago we rolled out the new system and I'm still wondering how robust Access is......I know it's not in the same league as Oracle, but at the same time this isn't a real big application. But I can't...

Microsoft Access / VBA

2374

Access 97 Capasity

by: Paul | last post by:

I am in need of some advice please: I have a client who wants to use Access 2k and 2k3 on their workstations. The appication will be written using Access 2k. My client has the following setup: 1. Possible 40 users in the database simultaneously (very light to moderate use) 2. Each user will have Windows 2000 or XP Professional

Microsoft Access / VBA

1532

Converting access to application

by: SecretCharacter | last post by:

I have a project going on to store data for inventory information. Creating a database with access makes me realise all things like the data tables and user interface(forms) and queries are all incorporated to one file. I wish to split the user interface from the database table itself so that the user interface can be stored locally on a local computer and the data(tables) is stored in the server. Is there any way we can do this? Having VB...

Microsoft Access / VBA

1869

multi-user access 2000 database

by: Smriti Dev | last post by:

Hi, I wanted find out if it is possible to have many users access an access database and add records using forms. I'm worried their might be data corruption. I will have about 5 users using the database. Thanks for your help. smriti --

Microsoft Access / VBA

4118

Need Access database on the web

by: nihad.nasim | last post by:

Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a reliable way of connecting Access to a server. I am willing to switch to any version of Access which might solve the problem. Which server would you recommend and what are the advanatages and disadvantatges of the server you propose? Please also inlcude...

Microsoft Access / VBA

9568

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, 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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10007

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9951

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9832

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 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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8831

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7375

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5275

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3531

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2805

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General