[Scopulus Argentarius]

Steve,

A = new database
B = old database

If you have access to both MDB files. Simply open A, the one you want the data in, link to the B table (new table --> link--> pick the B.mdb -> pick the table with the pix), and create a 'make table query' to copy the pics (and any important fields) from the linked table to a new local table. When done, simply delete the linked table. The images are in the a locally contained table with all of the other information you chose in the query (like id and such). Optionally, If you want to optimize, Put that table in design mode, add an autonumber primary key, index any fields you may need to join later, save and behold your fine work.

Sounds like an upgrade to a badging system or perhaps a photo directory. Did both a few years ago from an 'secure' access db.

BTW, the datatype for the pix should likely be 'Ole Data' and it is kind of a strange bird. You can write a module to save these in bmp or other format... (google that answer)


Hope that helps

Cheers,

sa


pm me if you need a better explaination...quickly..I'll be out of contact for a while in a couple of days.