[AccessD] Opening an Access application multiple times

jwcolby jwcolby at colbyconsulting.com
Thu Feb 3 14:35:37 CST 2011


LOL.  Because they do.  Not uncommon really.

In this case, it is a call center for disability insurance claims, they take calls all day.  When 
they are not on the phone they are "working claims".  *At their instance* (I need to stress that) 
they have their main form be the center of their world and it opens to a claim for a specific 
person.  It is tabbed with as many as 22 different tabs, although only about a dozen actually show 
under normal circumstances - some tabs only unhide for certain claim types etc.  However some tabs 
have tabs.

Can you say *busy*?

The tabs are JIT so they can switch between tabs and only pull that tab's info if / when they visit 
the tab.

Never the less, the claim form can take many seconds to open.  Now, they are working on a claim, and 
a phone call comes in...

Do we switch away from what we were doing... or open a second instance (keep it open is actually 
what they do) and just switch away to that other open instance and locate the claim of the person on 
the phone?

John W. Colby
www.ColbyConsulting.com

On 2/3/2011 3:01 PM, David McAfee wrote:
> John, I do it as Lambert described.
>
> Quick question. Why do the users need to open two copies of the database?
>
>
>
> On Thu, Feb 3, 2011 at 11:40 AM, jwcolby<jwcolby at colbyconsulting.com>wrote:
>
>>> I usually just open another instance of Access and then..
>>
>> Yea.  These are end users so... batch file it is.
>>
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>> On 2/3/2011 2:13 PM, Heenan, Lambert wrote:
>>
>>> Don't know why but I see the same thing happening. I usually just open
>>> another instance of Access and then have it open the second instance of the
>>> MDB file via the File menu.
>>>
>>> Lambert
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com [mailto:
>>> accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>>> Sent: Thursday, February 03, 2011 2:05 PM
>>> To: Access Developers discussion and problem solving
>>> Subject: [AccessD] Opening an Access application multiple times
>>>
>>> I am trying to open an access application more than once - two instances
>>> open at the same time.
>>> When I double click the FE (in explorer) it opens.  When I go back to
>>> explorer and double click it again, it just switches me back to the open
>>> instance.  Shouldn't it open the application a second time?
>>>
>>> When, from a batch file, I so something like "SomePath\Access.exe"
>>> SomeAccessFe.mdb it in fact opens the application a second time.
>>>
>>> I can live with having to open it from a batch file but I am just
>>> wondering why this is happening.
>>>
>>> --
>>> John W. Colby
>>> www.ColbyConsulting.com
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>>   --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>



More information about the AccessD mailing list