where is data stored?

[Guest]

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!

 

[Ken Snell \(MVP\)]

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

 

[Guest]

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.

 

[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.