where databases are to be stored in Access

[darkus]

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

 

[Jeff Boyce]

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

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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

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

 

[John W. Vinson]

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]