Solved

Hook up two computers to backend tables

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Unable to install Canon shared printers on Windows 7 PC's 6 53
Dell SonicWall Connection 18 59
Routers to buy for MDT Multitasking 6 77
Windows 2016 Server and Updates 5 43
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

734 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