Group:  Microsoft Access ยป microsoft.public.access.gettingstarted
Thread: How do I connect 2 databases?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How do I connect 2 databases?
Sapphire_Daze 28.07.2006 17:39:02
I am having difficulty with combining Inventory Control and Order Entry. I
need to be able to put in received merchandise and take out inventory sold
without doing it in both databases? Supplier and Vendors in the same database
would work perfect. Also my UPC cades are not validating as text. Not sure
what to do.

I am not that savvy and just learning, however this is needed. If there is a
better way, please advise....
Re: How do I connect 2 databases?
"Jeff Boyce" <nonsense[ at ]nonsense.com> 28.07.2006 18:04:30
I'm having some trouble visualizing your current situation.

If you have two separate .mdb files (i.e., databases), you could open one
and use File | Get External Data | Link... to connect to tables in the
other.

Or you could create a totally new, empty .mdb file and link (as above) to
both of your existing databases.

Or am I just not understanding?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Sapphire_Daze" <Sapphire_Daze[ at ]discussions.microsoft.com> wrote in message
news:A0AAD94A-2D91-48D1-8F62-DC2B1389749D[ at ]microsoft.com...
[Quoted Text]
>I am having difficulty with combining Inventory Control and Order Entry. I
> need to be able to put in received merchandise and take out inventory sold
> without doing it in both databases? Supplier and Vendors in the same
> database
> would work perfect. Also my UPC cades are not validating as text. Not sure
> what to do.
>
> I am not that savvy and just learning, however this is needed. If there is
> a
> better way, please advise....


Re: How do I connect 2 databases?
Sapphire_Daze 29.07.2006 17:25:02
Jeff,

Thats sounds so simple; however there is "weigh" too much air in my head to
comprehend. BUT I DID IT!!! YAHOO...

Yes I have 2 .mdb files. I did the external links and it worked just great.
Now how do i get the other shitchboard to show?

"Jeff Boyce" wrote:

[Quoted Text]
> I'm having some trouble visualizing your current situation.
>
> If you have two separate .mdb files (i.e., databases), you could open one
> and use File | Get External Data | Link... to connect to tables in the
> other.
>
> Or you could create a totally new, empty .mdb file and link (as above) to
> both of your existing databases.
>
> Or am I just not understanding?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Sapphire_Daze" <Sapphire_Daze[ at ]discussions.microsoft.com> wrote in message
> news:A0AAD94A-2D91-48D1-8F62-DC2B1389749D[ at ]microsoft.com...
> >I am having difficulty with combining Inventory Control and Order Entry. I
> > need to be able to put in received merchandise and take out inventory sold
> > without doing it in both databases? Supplier and Vendors in the same
> > database
> > would work perfect. Also my UPC cades are not validating as text. Not sure
> > what to do.
> >
> > I am not that savvy and just learning, however this is needed. If there is
> > a
> > better way, please advise....
>
>
>
Re: How do I connect 2 databases?
"Jeff Boyce" <nonsense[ at ]nonsense.com> 31.07.2006 14:51:42
What switchboard?

You can link data from any number of sources.

If you are trying to combine two applications into one, you'll have to do
all the development and programming.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Sapphire_Daze" <SapphireDaze[ at ]discussions.microsoft.com> wrote in message
news:D7B4D09D-35CD-4F1C-B9F5-1FF4DB35A5F2[ at ]microsoft.com...
[Quoted Text]
> Jeff,
>
> Thats sounds so simple; however there is "weigh" too much air in my head
> to
> comprehend. BUT I DID IT!!! YAHOO...
>
> Yes I have 2 .mdb files. I did the external links and it worked just
> great.
> Now how do i get the other shitchboard to show?
>
> "Jeff Boyce" wrote:
>
>> I'm having some trouble visualizing your current situation.
>>
>> If you have two separate .mdb files (i.e., databases), you could open one
>> and use File | Get External Data | Link... to connect to tables in the
>> other.
>>
>> Or you could create a totally new, empty .mdb file and link (as above) to
>> both of your existing databases.
>>
>> Or am I just not understanding?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Sapphire_Daze" <Sapphire_Daze[ at ]discussions.microsoft.com> wrote in
>> message
>> news:A0AAD94A-2D91-48D1-8F62-DC2B1389749D[ at ]microsoft.com...
>> >I am having difficulty with combining Inventory Control and Order Entry.
>> >I
>> > need to be able to put in received merchandise and take out inventory
>> > sold
>> > without doing it in both databases? Supplier and Vendors in the same
>> > database
>> > would work perfect. Also my UPC cades are not validating as text. Not
>> > sure
>> > what to do.
>> >
>> > I am not that savvy and just learning, however this is needed. If there
>> > is
>> > a
>> > better way, please advise....
>>
>>
>>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net