importing record from one Access database to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I am using one of the Microsoft supplied templates to track our wine
collection. It is called the "Wine Collection Database".

I use it to keep records of our purchases. I have saved another copy of it
as our 'wine tasting records database.' The second one is used to keep
descriptions of the wines we have tasted from our collection. Both databases
are the same, essentially.

How can I move the record of a wine we have consumed from the first database
to the second? I can't figure out how to import, or whatever, only a
particular record.

I have looked at the Microsoft online training; I have skimmed through
several Access books, and, of course, I've searched the Access help.
Obviously, I am no Access expert, but I would have thought this would be an
easy one -- it isn't!

Thanks for any help you can give.
 
Both databases are the same, essentially.

so you're entering duplicate data in the databases? first into the Wine
Collection Database, when you purchase the wine, and then again into the
other database when you've tasted one of your purchases?

how about using just one database, and adding a Yes/No field to the
appropriate table to mark a specific record as tasted. Yes (checkmark) =
tasted, No (blank or no checkmark) = not yet tasted.

hth
 
What a good idea!

Thanks,

R

tina said:
so you're entering duplicate data in the databases? first into the Wine
Collection Database, when you purchase the wine, and then again into the
other database when you've tasted one of your purchases?

how about using just one database, and adding a Yes/No field to the
appropriate table to mark a specific record as tasted. Yes (checkmark) =
tasted, No (blank or no checkmark) = not yet tasted.

hth
Click to expand...
 
Back
Top