ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
8 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Opening microsoft access from multiple locations
Posted on 2012-12-26
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.
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.
[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
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
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
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
- Microsoft Legacy OS
- Storage
- Storage Software
- Windows OS
- Storage Hardware
- Windows 10, Windows Vista, Windows 8, Windows 7, *Disk Cloning
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 19 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.