Solved

Hook up two computers to backend tables

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

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

Question has a verified solution.

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

Suggested Solutions

Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now