473,394 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

MS Acces help needed


Someone knows how to drop this big difficulty??

A Data Base in MS-Access 2002, condivided with multiple client, had link
failure with a client.
From this time until now, none can open the file because it appear following
message (translation from italian):

<<Microsoft Jet Manager stops working because another client want to modify
same data.>>

If I don't find how to overcome this problem and I can open again the file,
I loose part of my Data Base.
This is a big damage for me and it is not a good advertising for Microsoft
packages.

Can I open with other Data Base or Packages the file and repair it?
Which is the best?

Thank You very much

Alberto

Nov 13 '05 #1
1 1379
jv
Is the .ldb file still exist even though no one is in the database?
This happens to us once in a while when a network error occur. We
would get a message saying that the database is read-only. If that is
the case then try the following:
-Close all connections to this database.
-From the a Windows server machine, click on Start, Run, then type
in srvmgr,
then Click OK. This should open the Server Manager utility with a
list of computers
on the network.
-Double click on the server name where the data resides.
-Click on In Use. Another window will appear showing you a list of
open resources.
-Look in the Path column for the name of your database. If you see
any open resource
for the database, then highlight the line and click on Close
Resource until all
resources for that database is closed.
-Open windows explorer and see if the .ldb still exist. It it still
exist,
try to delete it.
-Try to open your database to see if the problem is solved.

If the above does not take of the problem then make a copy fo the
database and try the following on it:
-Repair and Compact, if you are able to get to it.
-Download JetComp.exe and try repairing it using the utilities.
-Decompile the database from the command promp using the the
/decompile switch.
-Import the data and objects into another database.

Good Luck

Julie Vazquez

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

29
by: Hagen | last post by:
Hello, in a recent thread "speed of vector vs array" I read about the problem of the slow acces by addressing vector elements by indexing, unfortunately I see no workaround in my case. My...
4
by: Kona | last post by:
Hello, I would like to known if it is possible to limit acces to a UDB database on Solaris system through db2connect to only specified clients ? My client is a db2connect on Windows platform. ...
1
by: TTD_hck | last post by:
Hello, I need suggestions for the following. I have a acces 97 database and with a script command in acces 97, I can e-mail a file via outllok. I do this with the folowing command in Acces 97:...
2
by: JMCN | last post by:
is it possible to export multiple queries into one workbook, having each query as separate worksheet? i cannot specify a range because the records will change on a daily basis as for query size. i...
0
by: John Smith | last post by:
I am currently using excel to manage a small database. The problem is my database is getting big and I need more then the 65000 lines excel can have. I have considered access but it lacks some...
5
by: Mrozu | last post by:
Hi I have frm1. On this form button.Click code for this button is: Dim frm2 as New frm2 frm2.show So after click, frm2 form is shown.
0
by: Nikeco | last post by:
Hello, I`m a little new to access and vb But i need to write a webservice client for a certified webservice, My certificate is stored in the keystore of microsoft and i don`t know how to...
0
by: bik | last post by:
Hi guys, it'll be great if some can help me, I have a problem geting directories Url in vista scaning the C:\\ disc, it says that the acces is denied, i had disabled the UAC, and have administrator...
3
by: tomPee | last post by:
Hi, I have the following problem: I am trying to make some sort of base class menu that i can then use to derive other menu's from. Those menu's should then be able to interact with each other....
6
by: zaankanter | last post by:
Hi, This my problem. After distribution of my acces-application I want the new user to be able to enter his Name-adress-etc values, in a one-row table called program-variables. These will be used...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
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...
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
jinu1996
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...
0
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...
0
tracyyun
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.