Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / August 2005

Tip: Looking for answers? Try searching our database.

importing record from one Access database to another

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rbedoscoe - 09 Aug 2005 00:23 GMT
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.
tina - 09 Aug 2005 00:44 GMT
> 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

> Hello:
>
[quoted text clipped - 16 lines]
>
> Thanks for any help you can give.
Rbedoscoe - 09 Aug 2005 04:00 GMT
What a good idea!

Thanks,

R

> > Both databases are the same, essentially.
>
[quoted text clipped - 31 lines]
> >
> > Thanks for any help you can give.
tina - 09 Aug 2005 05:54 GMT
you're welcome  :)

> What a good idea!
>
[quoted text clipped - 37 lines]
> > >
> > > Thanks for any help you can give.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.