[mso] Re: Access DB only will Open in Read Only :VSMail mx2
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 31 Dec 2002 11:19:32 -0800
April,
Yes, this is one of the reasons to split the database.
There are a couple ways to try to recover. One, you can sometimes have the
person who was in it, open it from the same computer they were on and then
close it again. (This will ocassionally delete the ldb file enabling others
to use it.) Another option is to open a new db, click on file, get external
data and try to import everything from your original database. (This is
something I always recommend you do after you complete your development.
There are some things that even compact and repair don't get rid of that
just take up space.) The only problem you should encounter with the new db
that has everything imported is that you will need to have it named
differently than the original since the ldb file is still out there. One
other thing you can try and it will ocassionally work, try to copy the
database and rename it in Windows Explorer. The ldb file doesn't follow the
copy and it should let you get to your data.
Hope this helps
James
-----Original Message-----
From: 4office [mailto:4office@xxxxxxxxxxxxx]
Sent: Tuesday, December 31, 2002 10:57 AM
To: Office (E-mail)
Subject: [mso] Access DB only will Open in Read Only :VSMail mx2
(In another different DB then my previous 2 postings) I have a DB that will
only open as a read only... It says that somebody else has it opened
exclusively and nobody else has it opened at all.... It is saved on a server
that crashed on day while somebody had the DB opened... they fixed the
server problem, but can no longer get into this DB.....
In excel I could copy and paste all the info into a new spreadsheet and make
it read/write able.... How can I recover this DB to a read/write able
status....
James, is this why you say to split the DB??
April
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] Re: Access DB only will Open in Read Only :VSMail mx2
