Linking data bases in Access 2003

[Access Newby]

I'm new to Access. I created 3 separate databases with similar information.
My students often move from one school to another so I need a way to link all
three of these data bases.

If this isn't possible, is there a way to move a record from one school's
data base to a different school's data base.

Is any of this possible without an advanced degree in computing?

 

[Stefan Hoffmann]

hi,

I'm new to Access. I created 3 separate databases with similar information.
My students often move from one school to another so I need a way to link all
three of these data bases.

Why do you have three databases?

Normally you should use a table layout(structure) like this

School:
ID (AutoInc) Primary Key
Name (Text) Not Null

Student:
ID ..
idSchool (Long) Not Null
dataFields..

and create a relation in the relationship window.

Is any of this possible without an advanced degree in computing?

<g>



mfG
--> stefan <--

 

[Mr. B]

Access Newby,

From your description of what you are wanting to do, it would seem that you
do not need 3 separate databases. You should only need one database and have
your tables defined in a way that you are assigning each student to a
specific school.

You may want to re-think your database design.

HTH
Mr. B
askdoctoraccess dot com