Question Type of DB

[agorman]

Hi,

I have been given a DB which has 2 parts, the first file mydatabase.mdb which I open and another just called data.db

The databases I have produced myself as I have been learning (in Access 2003) only have one file and no data file

Can anyone tell me the difference, and benifits of 2 parts please

Thanks

Adrian

 

[Pauldohert]

http://www.databasedev.co.uk/split_a_database.html

 

[Rabbie]

If the database is to be used by more than 1 person at a time then it is best to have a Front End database on each computer. This should contain the Forms, reports Queries, Macros and VBA modules as applicable. The Data tables should be stored in a separate DB on a server or other convenient computer.

This reduces the risk of data corruption and gives better performance as less needs to be sent over the network.

As Access is a relational database you probably need more than 1 table for your data. with relationships between them.

Do a google search and search this forum for "Data Normalization" and "data Normalisation"

You may find these links useful

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

http://www.datamodel.org/NormalizationRules.html

If you have any queries just post them in a new thread on this forum

 

[agorman]

Thanks to you both for the for the link and exlination - makes more sense now.