Exclusive Access Conflict

[Guest]

Reposting to correct group ...

----------------------------------------------------------------------------------------------

Hey folks!

I got a head-scratcher here (at least for me ... perhaps not for you).

My frontend points to a SQL server database which I have a table of users.
When they first open the app, requires them to log in by selecting a username
from a listbox and entering their password.

Here's the head-scratcher ...

After it appears to populate the listbox, my users get a message box (31
times, everytime) with the following message:
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later."

The listbox is populated by a query statement in the Rowsource property on
the Data tab rather than by vba code during the form load operation.

The sql for the rowsource property is
----------------------------------------------------------------------------------------------
SELECT tblUsers.user_id, tblUsers.user_name AS UserName, tblUsers.user_fname
AS [First Name], tblUsers.user_lname AS [Last Name], tblUsers.user_pwd,
tblUsers.user_role
FROM tblUsers
ORDER BY tblUsers.user_lname, tblUsers.user_fname

 

[Guest]

Hi Bob,

Is each user opening their own copy of the FE, or a shared copy?

Damian.

 

['69 Camaro]

Hi, Bob.

Reposting to correct group ...

Please don't multipost. If you feel you posted in a newsgroup in error,
please be courteous to others and post a "retraction" reply to the original
post, saying something such as, "I should have posted this question in the
blah-blah-blah newsgroup. Please disregard this question in this newsgroup,
since I won't be monitoring it for answers."

Otherwise, you'll get people answering the same question in multiple
newsgroups, and I can't tell you how irritating it is to spend half an hour
or more researching and answering someone's question, only to find out
someone else has already answered it in another newsgroup five minutes
before.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Reposting to correct group ...

----------------------------------------------------------------------------------------------

Hey folks!

I got a head-scratcher here (at least for me ... perhaps not for you).

My frontend points to a SQL server database which I have a table of users.
When they first open the app, requires them to log in by selecting a
username
from a listbox and entering their password.

Here's the head-scratcher ...

After it appears to populate the listbox, my users get a message box (31
times, everytime) with the following message:
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later."

The listbox is populated by a query statement in the Rowsource property on
the Data tab rather than by vba code during the form load operation.

The sql for the rowsource property is:
----------------------------------------------------------------------------------------------
SELECT tblUsers.user_id, tblUsers.user_name AS UserName,
tblUsers.user_fname
AS [First Name], tblUsers.user_lname AS [Last Name], tblUsers.user_pwd,
tblUsers.user_role
FROM tblUsers
ORDER BY tblUsers.user_lname, tblUsers.user_fname;