create a seperate database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

My problem is after i has create a major database with a lot of reference
tables and queries. Now i need to use this database to perform a number of
calculations using the existing database for reference.

Although i can use the existing database to do the calculations and save it
for that particular project. But this create a big database with a lot of
redundants information. This is alright if you only has to create one or two
calculations. In my case i may have to perform 20 to 30 calculations for
each project.

My question is as follows:
Is there anyway we can create a databse that only store the relevant
information for the calculations of the project.


thanks
 
Store your original major database on the server, then create a new empty
database in MS Access.
Use "Linked tables" to link to the tables in the major database on the
server.
Then, store your 30 calculations in the new database.
Use a new database for each project, and realize that each new database
links to the major database.
 
Back
Top