 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2006How do I connect 2 databases?
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.... 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 >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 [quoted text clipped - 6 lines] > a > better way, please advise.... 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? > I'm having some trouble visualizing your current situation. > [quoted text clipped - 22 lines] > > a > > better way, please advise.... 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 > Jeff, > [quoted text clipped - 36 lines] >> > a >> > better way, please advise.... |
Reply to this Message |
 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.