Learn how to a build a cloud-first strategyRegister Now


Networking A Access .mdb runtime application

Posted on 2006-03-28
Medium Priority
Last Modified: 2012-08-13
I have a runtime access .MDB application on a server and I want to access all records from two seperate workstations. How do I setup the workstations to access the .MDB file on the server?
Question by:ronlcline
LVL 15

Accepted Solution

Computron earned 1000 total points
ID: 16318352
The way I have done it in the past is to put the tables into their own MDB. Then place this MDB containing the tables on the server. Then put the MDB with the queries, forms, reports, etc on each client workstation and attach to the tables on the server MDB through a mapped drive. Also remember when you open the MDB on the server to use it in shared mode not exclusive.

Author Comment

ID: 16577994

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Many of us in IT utilize a combination of roaming profiles and folder redirection to ensure user information carries over from one workstation to another; in my environment, it was to enable virtualization without needing a separate desktop for each…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
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…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

810 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