G
Guest
When I go out to my hard drive, in the area I have saved my database, it shows db1.mbd and db2.mbd - what does this mean or stand for, and what happens if I delete it?
D
Damien McBain
Charlie said:
Would that be "db1.mdb" (as opposed to mbd)? If so, they're just database
files with the default name. Why don't you open them and see what's inside?
It goes away and you can't use it anymore
N
Niklas Östergren
Well I asume that it´s *.mdb not *.mbd!
db1 = database 1 and *.mdb is extension for fields created in Microsofts
program <Access>. So most sertanly you, or someone else have opened program
Microsoft Access and created a new file and saved it with the default name
that Access gives to any new file.
When you save a an Access file you can, offcource, save it with any name you
like but if you don´t specifye any name db1.mdb will be the name saved. And
db2.mdb for the next one and so on.
Since you don´t know if ther´s a lot of data saved in your db1.mdb and
db2.mdb file´s my suggestion is that you open them up and take look and se
if it´s anything worth saving or not!
Nothing will happen with your operation system. You will still be able to
start your computor and get into Internet and so on.
// Niklas
happens if I delete it?
db1 = database 1 and *.mdb is extension for fields created in Microsofts
program <Access>. So most sertanly you, or someone else have opened program
Microsoft Access and created a new file and saved it with the default name
that Access gives to any new file.
When you save a an Access file you can, offcource, save it with any name you
like but if you don´t specifye any name db1.mdb will be the name saved. And
db2.mdb for the next one and so on.
Since you don´t know if ther´s a lot of data saved in your db1.mdb and
db2.mdb file´s my suggestion is that you open them up and take look and se
if it´s anything worth saving or not!
Nothing will happen with your operation system. You will still be able to
start your computor and get into Internet and so on.
// Niklas
shows db1.mbd and db2.mbd - what does this mean or stand for, and whatCharlie said:
happens if I delete it?
V
Van T. Dinh
When you do Compact & Repair on your database file (and the Compact-On-Close
option), Access actually compacts into a temporary database file "dbX.mdb"
where X is the next available number in the directory. When the comaction
finishes, Access delete the uncompacted file and rename the file "dbX.mdb"
to the original name.
Sometimes for unknown reasons, the comaction is done but the deletion &
re-naming are not done. Check the size of the original database and you
probably find it is still the same and bigger than "dbX.mdb".
I would recommend compacting your database again and if the compaction is
OK, i.e. no "db3.mdb" remains, it is fairly same to delete "db1.mdb" &
"db2.mdb".
--
HTH
Van T. Dinh
MVP (Access)
happens if I delete it?
option), Access actually compacts into a temporary database file "dbX.mdb"
where X is the next available number in the directory. When the comaction
finishes, Access delete the uncompacted file and rename the file "dbX.mdb"
to the original name.
Sometimes for unknown reasons, the comaction is done but the deletion &
re-naming are not done. Check the size of the original database and you
probably find it is still the same and bigger than "dbX.mdb".
I would recommend compacting your database again and if the compaction is
OK, i.e. no "db3.mdb" remains, it is fairly same to delete "db1.mdb" &
"db2.mdb".
--
HTH
Van T. Dinh
MVP (Access)
shows db1.mbd and db2.mbd - what does this mean or stand for, and whatCharlie said:
happens if I delete it?
J
Joan Wild
Since these show up in the same folder as your saved database, you likely
have 'compact on close' set in the options. Access will create a temporary
database during this process (called db1.mdb). If db1.mdb already exists in
the folder, it'll use db2, db3, etc.
Usually when the compact is completed, the db1.mdb file is deleted. In your
case, the process isn't completing - perhaps the user you are logged in as
doesn't have delete permissions on the folder?
have 'compact on close' set in the options. Access will create a temporary
database during this process (called db1.mdb). If db1.mdb already exists in
the folder, it'll use db2, db3, etc.
Usually when the compact is completed, the db1.mdb file is deleted. In your
case, the process isn't completing - perhaps the user you are logged in as
doesn't have delete permissions on the folder?