Exclusive Access warning 8 times

  • Thread starter Thread starter HLCruz via AccessMonster.com
  • Start date Start date
H

HLCruz via AccessMonster.com

I just created user-level security for my FE database, when I log on as the
administrator everything opens fine. When I log on as my first created
group's user, I get the "You do not have exclusive access at this time"
message box, which reappears 8 times before finally closing out. I can't
imagine this is normal behavior and would hate to put my users through this.
Is anyone aware of how to resolve this? Any suggestions or solutions are
greatly appreciated!

Heather
 
Hi, Heather.
When I log on as my first created
group's user, I get the "You do not have exclusive access at this time"
message box, which reappears 8 times before finally closing out.
Click to expand...

Your application's startup is attempting to either open the file in
exclusive mode and/or elevate file access from shared mode to exclusive mode
immediately after opening the file. The former happens when a user is
attempting to open the file in exclusive mode, but doesn't have database
"Open Exclusive" User-Level Security permissions. The latter happens when a
design change is made and either the user doesn't have permissions to open
the file in exclusive mode or else other processes have already connected to
the database file, so it can't be changed from shared mode to exclusive
mode.

Perhaps your code is making changes to a form, report, or command bar on
start up, but the database is being shared across the network by other users
(i.e., not using a split database design)? Perhaps you have the Adobe
Acrobat 7.0 toolbar installed on a shared multiuser database? These
conditions would spark that error message when the user doesn't have "Open
Exclusive" permissions.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Thanks Gunny, I am using a split design on a shared network so I don't think
that's it, but I DO have the Adobe Acrobat toolbar. So is this a glitch
related to the toolbar that causes my application's start up issues or are
those two completely different problems? Will removing the toolbar stop the
problem? i am using the tool bar to create pdf versions of reports for easy
emailing ... is there a way to get around this?

Thanks for your advice!

'69 Camaro said:
Hi, Heather.
When I log on as my first created
group's user, I get the "You do not have exclusive access at this time"
message box, which reappears 8 times before finally closing out.
Click to expand...

Your application's startup is attempting to either open the file in
exclusive mode and/or elevate file access from shared mode to exclusive mode
immediately after opening the file. The former happens when a user is
attempting to open the file in exclusive mode, but doesn't have database
"Open Exclusive" User-Level Security permissions. The latter happens when a
design change is made and either the user doesn't have permissions to open
the file in exclusive mode or else other processes have already connected to
the database file, so it can't be changed from shared mode to exclusive
mode.

Perhaps your code is making changes to a form, report, or command bar on
start up, but the database is being shared across the network by other users
(i.e., not using a split database design)? Perhaps you have the Adobe
Acrobat 7.0 toolbar installed on a shared multiuser database? These
conditions would spark that error message when the user doesn't have "Open
Exclusive" permissions.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
I just created user-level security for my FE database, when I log on as the
administrator everything opens fine. When I log on as my first created
Click to expand...
[quoted text clipped - 6 lines]
Heather
Click to expand...
Click to expand...
 
Back
Top