General question on Access Database Structure

[Guest]

About 7 or 8 years ago I spent a couple years developing databases using Borland Paradox. I specifically liked Paradox over Access because I could update forms and reports in a master database and then just send those seperate form and report files out to the people who used the database.

My question is: Does Access still house the entire database, forms, reports, queries and tables in one giant file? Or are all the elements of the database in seperate files?

Thanks

 

[Wayne Morgan]

The answer is Yes to both. However, splitting is recommended in order to do
updates as you stated or in a multi-user environment. When you split the
database, you put the tables in one file (the back-end) and everything else
in another file (the front-end) then create linked tables in the front-end
to the tables in the back-end. Give each user a copy of the front-end on
their computer and place the back-end on a network share that they have
permissions to.

You will find more information here.
http://members.iinet.net.au/~allenbrowne/ser-01.html
http://www.mvps.org/access/tables/tbl0009.htm
http://www.granite.ab.ca/access/splitapp/index.htm

 

[PC Datasheet]

Mike,

What Wayne said works in 2000 as well as previous versions. Actually you should
do this for all databases even if it's standalone. It gives you the flexibility
to easily make changes to a database.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

One other question,
Our company is someone out dated... the latest version of Access we have is

2000. Does this version of Access work in the way you mention or is that only
for newer versions?