where is data stored?

J

jlm

can anyone tell me where the data for a particular database is stored in my
computer? is it stored within the .mdb file such that if i opened that file
on another computer with Access, all my data would be there also? or is it
pulling the data from some other place hidden in my computer? thanks!
 
K

Ken Snell \(MVP\)

The .mdb file contains all the data, all the objects, all the relationships,
etc.
 
J

jlm

excellent! this is a relief to know. it is another way to 'save' the data
w/o having to export it, just as the microsoft works database does.
 
K

Ken Snell \(MVP\)

By "save", I assume that you mean "back up"? Yes, you can back up an ACCESS
database by copying the file and putting it in a safe place. Note: do not
copy an .mdb file while there is an .ldb file for it -- the presence of an
..ldb file means that a user is using the file, and if data
edits/additions/deletions are occurring when you make the copy, the copied
file may be corrupt.
 
Top