[AccessD] Same FE open twice (or more)

In fact I do not want to prevent the user from opening it twice, unless it
is causing a problem which I haven't determined yet.  I just want to see the
count of a user in a database or something like that. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 31, 2008 12:07 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Same FE open twice (or more)

Hi John

That is quite easy if you can persuade the users to launch your app via a
shortcut (and if you read the command line when launching the app, you can
quit if no params exists - see recent thread on this) which forces the
frontend to be opened exclusively. If opened already, catch that error and
display a message.

/gustav

>>> jwcolby at colbyconsulting.com 31-01-2008 17:48 >>>
Is there any way to discover that a user has opened the database more than
one time?  I have users who do this, and while I don't care, I think that it
might be causing issues.  I have built a rather elaborate error logging
system to log error number, error message, code module, function, line
number, workstation, user, time and date.  I have the majority of errors
coming from specific users and am trying to discover why.  Some of them have
mentioned that they do use the FE opened more than once at a time so I want
to check if these specific users are doing that at the instance that the
error occurs.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com