Solved

Hook up two computers to backend tables

Posted on 2013-05-23
3
335 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 500 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 500 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

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
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…
Suggested Courses

630 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