Hello,
I have a MS. Access database in XP. When I open the database in design
view, users will get an error message & cannot even open the database.
Is there any way to solve this problem?
Thanks for your help in advance.
Orchid
16  2640 
What error message? Did you try the standard compact/repair routine?
Thanks for your reply!
The error message is: "The database has been placed in a state by user
'Admin' on machine 'Name' that prevents it from being opened or
locked."
Yeah, I tried the standard compact/repair routine, (which is under
Tool, Database Utilities, Compact and Repair Database...)but still got
the same error message.
"Orchid" <yh******@yahoo .com> wrote in message news:<11******* *************** @g14g2000cwa.go oglegroups.com> ... Thanks for your reply!
The error message is: "The database has been placed in a state by user
'Admin' on machine 'Name' that prevents it from being opened or
locked."
Yeah, I tried the standard compact/repair routine, (which is under
Tool, Database Utilities, Compact and Repair Database...)but still got
the same error message.
try deleting the *.ldb file on the machine that has it opened or locked.
I tried to delete the *.ldb file, but got error message: "It is being
used by another person or program. Close any programs that might be
using the file and try again."
The *.ldb is a file automatically created after opening a *mdb file in
a directory, once the *mdb file is closed, the *ldb file is disappear.
Is there any way that the users can open the database even I am on the
design view? Is it dealing with Security of the database?
Your help is appreciated!
Regards,
Orchid
Orchid wrote: Hello,
I have a MS. Access database in XP. When I open the database in design
view, users will get an error message & cannot even open the database.
Is there any way to solve this problem?
No. Do you really want users to be getting into the database when you
are doing design work on it?
IS this a back end database or is it an application that everyone
accesses on a network?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
I want the users to be able to log into the database at any time even
when I am working on the design view. I want to eliminate the calls
from users saying they cannot open the database.
The database is on the network share drive. I have the database set up
that the users cannot view the design views,tables, and queries. When
they open the database, they will see a form & double click from a list
to open forms & reports. so is it consider to be an application? I
am not sure.
Orchid,
Look for JetComp on Microsoft's web site. It isn't a sure thing but there
are .mdb's that it will recover which cannot be recovered by Access. It's
free and it it works, very cool.
--
Alan Webb kn*******@SPAMh otmail.com
"It's not IT, it's IS
"Orchid" <yh******@yahoo .com> wrote in message
news:11******** **************@ l41g2000cwc.goo glegroups.com.. . I tried to delete the *.ldb file, but got error message: "It is being
used by another person or program. Close any programs that might be
using the file and try again."
The *.ldb is a file automatically created after opening a *mdb file in
a directory, once the *mdb file is closed, the *ldb file is disappear.
Is there any way that the users can open the database even I am on the
design view? Is it dealing with Security of the database?
Your help is appreciated!
Regards,
Orchid
Orchid wrote: I want the users to be able to log into the database at any time even
when I am working on the design view. I want to eliminate the calls
from users saying they cannot open the database.
The database is on the network share drive. I have the database set up
that the users cannot view the design views,tables, and queries. When
they open the database, they will see a form & double click from a list
to open forms & reports. so is it consider to be an application? I
am not sure.
You need to split the database into a front-end and a back-end.
The FE will contain the Forms, Queries, Macros, Reports and Modules.
The BE will contrin only the tables.
Put the BE on the network and the FE on each users pc.
Link the FE to the BE.
This way you can make changes to your copy of the FE and then give each user
an new compy when you have completed making you changes.
Ron
--
Ronald W. Roberts
Roberts Communication rw*@robcom.com
"Orchid" <yh******@yahoo .com> wrote in message news:<11******* *************@l 41g2000cwc.goog legroups.com>.. . I want the users to be able to log into the database at any time even
when I am working on the design view. I want to eliminate the calls
from users saying they cannot open the database.
The database is on the network share drive. I have the database set up
that the users cannot view the design views,tables, and queries. When
they open the database, they will see a form & double click from a list
to open forms & reports. so is it consider to be an application? I
am not sure.
Has this worked before where you are in design view and others can
open the database without the error? If not maybe being in design
view locks the database. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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.
|
by: MHenry |
last post by:
Hi,
We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.
Suddenly, network computers cannot access the database.
The message is...
|
by: Yannick Turgeon |
last post by:
Hello,
We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data
(SQL Server 2000), 40 users.
I'm wondering what are the disadvantages of using Access as front-end? Other
that it's not...
|
by: DaveG |
last post by:
Hi all
I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.
The delema is what is best to use ase the DB engine, Access I have as
part of Office 2002 or should I really be looking at SQL...
|
by: philip |
last post by:
On a form, I have a datagridview.
This datagridview is constructed on a dataset filled by a tableadapter.
The table adapter do very well what it must do when filling dataset.
Insertions, modifications and deletions functions very well in the dataset.
But impossible to transmit modifications in ACCESS database. Impossible to
WRITE in database.
Here is the code for data transmission from tableadapter to Access database
:
| | |
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button remains desperatly grayed.
It also seems impossible to open the library in another Access instance
|
by: Wayne Smith |
last post by:
I've come up against a major headache that I can't seem to find a solution
for but I'm sure there must be a workaround and I would really be grateful
of any help.
I'm currently building a web site for a small club I belong to and one of
the features I would like to include is the ability to allow users to upload
image files.
unfortunately the servers web root www folder only allows READ and EXECUTE
permissions, which makes it...
|
by: surfrat_ |
last post by:
Hi,
I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb
database. Please help me to sort this out.
Problem 1:
The Microsoft page "How to: Connect to Data in an Access Database"
|
by: Harel |
last post by:
I have a report SQL which have been working for a few weeks. Its large
and the target database is large. It has 59 join, and I dont think
there is anything I can do about this, since the DB I use has been
normalized by pros.
My problem is I try to had another join to display another value, then
I get a crash report from MS-Access. Anything I can to do diagnose
this problem. My development depends on this SQL:
SELECT
|
by: Wesley Peace |
last post by:
I hate to cross post, but I've gotten no answer yet on a problem I'm having
with visual studio 2008.
I've created a series of forms with controls to access a Access database
tables. The connection string works fine and the tables are added to the
project without a problem.
When I create the tables they appear to bind and I am able to preview the
data in the database in design mode; however, at runtime no data is
displayed and the...
|
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...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
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,...
|
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...
|
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...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
