merging databases

[elbudda]

I am using ACCESS 2000 and am trying to merge two
dissimalar databases. I basically cut and pasted the
fields from both databases into a new database and then
tried to replcate the tables for the new DB to draw
from. But it will not accept the new table.

I may have the concept all wrong. Where does the DB form
get its data from? Is it not a table?

 

[John Vinson]

I am using ACCESS 2000 and am trying to merge two
dissimalar databases. I basically cut and pasted the
fields from both databases into a new database and then
tried to replcate the tables for the new DB to draw
from. But it will not accept the new table.

I may have the concept all wrong. Where does the DB form
get its data from? Is it not a table?

It can be a table, but it's more typically a Query.

Tables should be designed first, using the principles of database
normalization; designing a table to fit the appearance of a form
(paper or computer form) is the wrong way about and will certainly get
you in trouble!

You then create Queries to select records and fields from the table or
tables.

Finally you create Forms and use the queries (or, occasionally, a
table) as the Recordsource for the form.