Linking Tables

[Terry Watson]

Ok, I failed to get my tables combined satisfactorily. Is there a way to
link tables within a database so that I don't have to enter the same
information twice? I have 4 common fields in both databases.

 

[Guest]

I failed to get my tables combined satisfactorily.
Exactly what are you trying to do?
It sounds like you could not append your records into a single table and now
want to do somwthing.
Why not work on fixing the orignal problem?
What did not work?
What error messages?

 

[Terry Watson]

Fields for Table (Maps) are as follows: Drawer, Name, TMS Number, Date, Job
Number, Location, Subdivision, Block, Lot, Tract, Area, Surveyor, Revision,
Disk.

Fields for Table (DCA) are as flollows: Disk, Name, Job Number, Description,
Date.

The Maps table has over 30,000 records, the DCA table has 10,000 records.

 

[Aaron Kempf]

anything with that many records; and you'd be best off using SQL Server and
Access Data Projects


MDB doesn't even support query hints such as NOLOCK