Solved

Opening microsoft access from multiple locations

Posted on 2012-12-26
3
323 Views
Last Modified: 2013-01-11
I run a lot of MS Access forms and reports at work and many people run them at the same time.
Gererally I will create a shortcut to the specific MDB/form/ect.. and the user will click on the shortcut and the application will open, or that is what used to happen.
Now if another user has the application open the only way for the second user in to have the application open is to go to MS access> File> Open and then select the shortcut. Which equals broke to some users
It has not always been this way it seems like maybe a year ago this started.
0
Comment
Question by:TechGuy_007
  • 2
3 Comments
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 38722083
A better way to do it is to split the back end data tables from the front end forms.

http://office.microsoft.com/en-us/access-help/split-an-access-database-HA010342026.aspx

But if I have multiple users, i try to put it in a web app with a real database back end (MS SQL, MySQL, Oracle, )tc
0
 

Author Comment

by:TechGuy_007
ID: 38722106
This would not solve the issue I am currently having, would it?
0
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 500 total points
ID: 38722292
It probably would because you would no longer be using a shortcut to one MDB file. Each user would have a copy of the front end application. Of course this is only a viable solution if you don't have too many people using the application since every change requires distributing a new copy of the front end.

If you issue started a year ago, I am not sure that you can track down the root cause unless you have fantastic records pertaining to all of the patches, updates, etc that have been performed on the affected computers.

That being said. Check under Tools>>Options>>Advanced and make sure that your "Default Open Mode" is set to Shared and the "Default Record Locking" is set to No Locks, with the checkbox for "Open database using record-level locking" is checked.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel 2013: Displaying times in Milliseconds 6 261
onenote 2016 sync 40 270
How to export photos individually from a OneNote 2016 39 144
Sharepoint 2012 site not live after migration 7 80
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

821 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