where databases are to be stored in Access

i don't know where databases are to be stored in access, im excited about
the search on access in order to be a professional user like others. cheers

Microsoft Access uses a single file, with the ".mdb" extension, to store
everything.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"darkus" wrote in message
...
i don't know where databases are to be stored in access, im excited about
the search on access in order to be a professional user like others.
cheers

On Sat, 8 Dec 2007 02:00:00 -0800, darkus
wrote:

i don't know where databases are to be stored in access, im excited about
the search on access in order to be a professional user like others. cheers

An Access Database is a .mdb file (or a .mde compiled database, or a .mda
library database, or several other minor variants). A .mdb file is most
typical, and will contain multiple Tables, Queries, Forms, Reports, Macros and
Modules - everything that makes the database work along with the actual data
contents.

For multuser systems it is recommended and common to use a "split" database -
a "Backend" containing only the Tables of data, and a "Frontend" containing
everything else, with links to the tables. Each user gets their own copy of
the frontend.

John W. Vinson [MVP]