What I did:
Rebuilt database on both imported collections.
Named unique - songs1.mdb & songs2.mdb
Opened songs1 in access, changed field bookid to numeric field
created new numeric field called bookid2
exported to Excell
opened in excell and defined value of bookid2 as "= bookid + XXX00" (xxx is the actual number of discs imported in songs2, so that songs1 will start with the next higher book ID when put back into hoster)
saved, and went back to access, created new database file songstemp based on excell file I just saved.
removed bookid field, then renamed bookid2 to bookid
saved.
highlighted all cells, copied, closed file, opened songs2
went to end, and pasted all cells
saved, then went to tools, database conversion, save as previous version.
named file songs.mdb and saved
copied to gig computer and placed in mtu/hoster/databases
opened hoster and IT ACTUALLY WORKED!
I've never used Excell or Access before this week. I gleaned what information I could from websites that I googled for pointers and this is what I came up with. It took me three days and a half a bottle of tylenol but I did it and it worked. I still had a few duplicates when I compiled each small database (about 15 in one and 100 in the other) but that is an acceptable loss compared to the 3000+ it was reporting initially! Now I can wait until the new version is available and still run my show without taking all my CDs now! YEAH!!!!
