Solved

Hook up two computers to backend tables

Posted on 2013-05-23
3
314 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
  • 2
3 Comments
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) 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 47

Accepted Solution

by:
Dale Fye (Access MVP) 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

778 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