G
Guest
Anyone know why my shared database seems to make a backup copy of itself? How can I turn off this feature. Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary Miller
Does this file actually have an '.ldb' extension instead or
the usualy '.mdb' if you look at it's properties? If so,
this is normal and it is a file that tracks the users in the
database and Access usually deletes it when the program
closes. You can't tell Access not to create it.
--
Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
the usualy '.mdb' if you look at it's properties? If so,
this is normal and it is a file that tracks the users in the
database and Access usually deletes it when the program
closes. You can't tell Access not to create it.
--
Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
copy of itself? How can I turn off this feature. Thanks!Anyone know why my shared database seems to make a backup
T
Tom Wickerath
Another possibility is that you have the Compact on Close option selected (Tools >
Options, General Tab) and, for some reason, it is not able to complete this operation
successfully. This results in a backup copy. If you have this option selected, and you
find that the backups stop after deselecting the option, it may be a sign that you have
some slight corruption going on. If that's the case, you might want to import all objects
into a new database.
Tom
PS. When you say "shared database", I hope you are sharing only the data (tables). Each
user should have a copy of the Front-End on their own PC's.
________________________
Does this file actually have an '.ldb' extension instead or
the usualy '.mdb' if you look at it's properties? If so,
this is normal and it is a file that tracks the users in the
database and Access usually deletes it when the program
closes. You can't tell Access not to create it.
--
Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
Anyone know why my shared database seems to make a backup
copy of itself? How can I turn off this feature. Thanks!
Options, General Tab) and, for some reason, it is not able to complete this operation
successfully. This results in a backup copy. If you have this option selected, and you
find that the backups stop after deselecting the option, it may be a sign that you have
some slight corruption going on. If that's the case, you might want to import all objects
into a new database.
Tom
PS. When you say "shared database", I hope you are sharing only the data (tables). Each
user should have a copy of the Front-End on their own PC's.
________________________
Does this file actually have an '.ldb' extension instead or
the usualy '.mdb' if you look at it's properties? If so,
this is normal and it is a file that tracks the users in the
database and Access usually deletes it when the program
closes. You can't tell Access not to create it.
--
Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
Anyone know why my shared database seems to make a backup
copy of itself? How can I turn off this feature. Thanks!
G
Guest
I don't see any extensions when I open the properties. Where else can I look? My worry is that the backup copy is bigger than the orig so info is being added to two places meaning my info isn't correct
Also the compact on close option was not checked so that's not the problem. Any other thoughts? Thanks!
Also the compact on close option was not checked so that's not the problem. Any other thoughts? Thanks!
T
Tom Wickerath
This is a Windows Explorer (not Access) setting.
Open Windows Explorer (Windows key + E is one method)
Click on View > Details to set the detail view
Click on Tools > Folder Options...
Select the View tab
Remove a check from the option that reads "Hide file extensions for known file types"
Click on the button labeled "Like Current Folder"
Click on OK.
Close Access if you had it open.
Navigate to the folder that contains your .mdb file.
Do you see a .ldb (locking database) file? If your database is a single user application
(ie. the tables are in a database on your PC instead of in a separate back-end database on
a file server) then you should not see a .ldb file present. If you see it, then try
deleting it. These files are typically 1 KB in size. If your database is on a file
server, and you are sure that no one else has it open, then you should also not see a .ldb
file present.
See Introduction to .ldb Files for more info.
http://support.microsoft.com/default.aspx?scid=kb;en-us;208778
Tom
_________________________________
I don't see any extensions when I open the properties. Where else can I look? My worry is
that the backup copy is bigger than the orig so info is being added to two places meaning
my info isn't correct.
Also the compact on close option was not checked so that's not the problem. Any other
thoughts? Thanks!
Open Windows Explorer (Windows key + E is one method)
Click on View > Details to set the detail view
Click on Tools > Folder Options...
Select the View tab
Remove a check from the option that reads "Hide file extensions for known file types"
Click on the button labeled "Like Current Folder"
Click on OK.
Close Access if you had it open.
Navigate to the folder that contains your .mdb file.
Do you see a .ldb (locking database) file? If your database is a single user application
(ie. the tables are in a database on your PC instead of in a separate back-end database on
a file server) then you should not see a .ldb file present. If you see it, then try
deleting it. These files are typically 1 KB in size. If your database is on a file
server, and you are sure that no one else has it open, then you should also not see a .ldb
file present.
See Introduction to .ldb Files for more info.
http://support.microsoft.com/default.aspx?scid=kb;en-us;208778
Tom
_________________________________
I don't see any extensions when I open the properties. Where else can I look? My worry is
that the backup copy is bigger than the orig so info is being added to two places meaning
my info isn't correct.
Also the compact on close option was not checked so that's not the problem. Any other
thoughts? Thanks!
G
Guest
Thanks Tom, all was as you said it would be! It is a shared DB that resides on the server so a group of people have permission to use the DB. I do see an .ldb extension occassionally when more than one is in the DB but it goes away by itself when closed by the second person. No one has 'fessed up to creating a backup and to tell the truth I don't think they would know how. What is curious is the formatting of the name. The original is MOW and the backup copy is MOW_backup. I don't understand why the backup copy is bigger in size than the original but from all I can tell the original has the most current information. I'll review the article on .ldb as you suggested.