Database questions

  • Thread starter Thread starter Jie
  • Start date Start date
J

Jie

Hello, I am a new user to use database. Because I am
working in college, we have several databases for
different semester. Is there any chance I can build a main
database including small database(eg. for each semester's
database), and use shortcut to open those small database?
Thank you very much.
 
This is not really a viable option. Access database files
are so small that it is almost always preferable just to
make a new database each time you need one.

If you really wanted to use only one mdb file, you could
use different tables within the database to hold
individual "databases" of information and a startup switch
to direct the application to open a particular table upon
startup, but this requires some VB coding.
 
You can make a new database and IMPORT (FILE>Get
external) the tables and forms into the new database so
all the databases are consolidated into one. Then use the
SWITCHBOARD MANAGER in TOOLS>Database Utilities to create
a button on the switchboard that opens each "database".
And If you need to add more semesters just create another
table or put a field in the existing table to show what
semester it is..

Hope this helps

Tim
 
But the problem each single database we have a lot of
tables with same names, if I import those tables into one
database, I am afraid that it will be confusing. And if I
use one switchboard to make shortcut, I mean probably too
many shortcut to make.
 
Back
Top