Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Hook up two computers to backend tables

Posted on 2013-05-23
3
Medium Priority
?
339 Views
Last Modified: 2013-05-23
Good morning...

Today I am attempting to hook up two laptops access database to a 3rd laptop housing the tables. I am hoping I have the brains to get this done!

Anyone have a good reference of directions walking this through?

I am using one of these:

http://www.amazon.com/TRENDnet-Unmanaged-GREENnet-Standard-1000Mbps/dp/B001QUA6RA/ref=sr_1_1?ie=UTF8&qid=1369315980&sr=8-1&keywords=710931610154

Any overview your can provide, or things I should watch out for would be great.
0
Comment
Question by:cansevin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 48

Assisted Solution

by:Dale Fye
Dale Fye earned 2000 total points
ID: 39190918
Generally, you would put the data that both laptops are trying to access on a network file server, then link those tables to the front end Access application (.accdb file), and put a copy of the application on each of the laptops.  If you have not already done this, you can use the database splitter application database splitterto split your data tables from your forms, reports, ...

If you don't have a network file server, you can probably share the appropriate folder of laptop #3 with the rest of your network, and let you users connect to that from across your network.

If you have already done this, but the tables are not linked properly, use the Linked table manager to refresh the links to those tables.  To do this, right click on a table in the Navigation Panel and select the "Linked Table Manager" option near the bottom of the popup window, then follow the instructions in the wizard (make sure you select the option to link the tables).
0
 

Author Comment

by:cansevin
ID: 39190968
Thank you fyed! Much appreciated.

What is a network file server and how do I know if I have one?
0
 
LVL 48

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 39191060
Are you working in an office?  Do you have an IT person?  If the answer to either of those is a yes, you probably have a "file server".  It is basically a PC (could be a server) that has sections of the hard drive partitioned for general file storage for the organization (my definition).

If you are simply trying to share a datafile across three laptops, connected by some form of network (including wireless), then you would need to use the sharing option I mentioned above.  To do that, open your "Windows Explorer" (not Internet Explorer) or click on the "My Computer" icon on your desktop.  Navigate to the folder you want to share with the other laptops, right click on that folder, select Properties, then click Share on the "Sharing" tab.  It will ask you for the name you want to use for the shared folder.

Then, on the other computers, you should be able to open Windows Explorer, select "Tools", then "Map Network Drive", and then click Browse.  From the Explorer window, scroll down to the Network icon, expand it and you should see the shared folder from the 3rd computer.  Select that folder and then change the drive letter so that both of the remote laptops share the same folder name.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question