Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

winCheckMultipleInstances

i am trying to prevent users fro opening a second instance of the database using winCheckMultipleInstances.The problem is that it isn't working in windows 7 64bit and ms access 2010 32 bit.i have tried using a short cut and opening the database directly.Is there an working alternative.Thanks
0
Svgmassive
Asked:
Svgmassive
  • 6
  • 6
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What/where is 'winCheckMultipleInstances' ??
Are you talking about a 2nd instance on the same system, or just a 2nd instance anywhere ?

mx
0
 
SvgmassiveAuthor Commented:
Second instance on same system
0
 
SvgmassiveAuthor Commented:
I am running it from an autoexec function
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well, I know the author of that code and I'm sure it works.  But I suppose there could be an issue with Win7x64, although I'm not sure why there would be.
Has the code ever worked for you ?

Also just curious, how would a 2nd instance of your db get opened on the *same* system anyway ?

mx
0
 
SvgmassiveAuthor Commented:
yep
0
 
SvgmassiveAuthor Commented:
i think the problem is with the   sMyCaption = winGetTitle(winGetHWndDB()) it's returning a "" not sure if this is correct,an alternative is to check the task manager.i don't know if the will work.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
just curious, how would a 2nd instance of your db get opened on the *same* system anyway ?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Also what  version of Access / Windows did you have this working in ?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I  have pinged the author of that code. He is in NZ ... time zone difference.  Let's see what he comes up with ...

mx
0
 
GrahamMandenoCommented:
Hi Svgmassive

I confess to being the author of that code :-)

It was written almost 20 years ago for Access 2.0, and worked beautifully until Access 2007.  

The problem is that it works by checking the title bar text of the Database window, which used to be guaranteed to show the filename of the database, even if the user had changed the application window title.  With Access 2007, the Database window disappeared and was replaced with the Nav Pane, which has no title text.

A reasonable workaround is to use a shortcut with the /excl command line switch to open the database exclusively.  You must include the full path to msaccess.exe in the command line - like this:

"C:\Program Files (x86)\Microsoft Office\Office14\msaccess.exe" "C:\Your Path\Your database.accdb" /excl

Note that in a multi-user environment you should always give each user a separate copy of the front-end on the local hard drive, so there will never be any problem of locking other users out by using the /excl switch.

Best wishes,
Graham Mandeno [Access MVP since 1996]
0
 
SvgmassiveAuthor Commented:
Thanks graham for taking the time..never had a problem before with it...will try the work around later.can the task manger be used as an alternative
0
 
SvgmassiveAuthor Commented:
Databasmx thanks. Any suggestions
0
 
GrahamMandenoCommented:
I can't see how the task manager could be used for this.

You could conceivably check the title text of the main application window, but this is fraught with difficulty - for example:
- the user can change the text, or it can be changed by code
- the title changes with DoCmd.Maximize and DoCmd.Restore
- the format changes with different Access versions

The only really fool-proof method I can think of is to use API calls to inspect the file handles for all the other Access processes, and see if any of them have the current DB open, but this is getting into some pretty heavy-duty I/O subsystem coding.

I recommend the /excl switch - it works well for me :-)

Note that you can also set the "Default open database mode" to "Exclusive" in the Access options.  This is a per-user setting, so will need to be set for each user's profile.

-- Graham
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Databasmx thanks. Any suggestions"
Well since Graham is here ... :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 6
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now