|  | Can you run multiple sessions in acceses? |  | |
| | | JK |  |
| Posted: Fri Aug 29, 2008 11:16 am Post subject: Can you run multiple sessions in acceses? |  |
I created an application and saved it to a company server. I then split the database and created an MDE file. Using the MDE file, I copy it and then past it to each user's desktop.
Access 2003
My questions is this, would it cause any problems if the user runs multiple sessions? With the application already open; I have one user that wants to have the db open twice so that she can flip back and fourth.
Is this generally a bad idea or is ok to do? Although I've never tried it for fear of breaking the app. she say's it has worked in the past.
Thx! JK |
| |
| | | Maurice |  |
| Posted: Fri Aug 29, 2008 11:42 am Post subject: RE: Can you run multiple sessions in acceses? |  |
Should be possible, she might not see the changes immediately in the other database though.
-- Maurice Ausum
"JK" wrote:
| Quote: | I created an application and saved it to a company server. I then split the database and created an MDE file. Using the MDE file, I copy it and then past it to each user's desktop.
Access 2003
My questions is this, would it cause any problems if the user runs multiple sessions? With the application already open; I have one user that wants to have the db open twice so that she can flip back and fourth.
Is this generally a bad idea or is ok to do? Although I've never tried it for fear of breaking the app. she say's it has worked in the past.
Thx! JK |
|
| |
| | | Tom van Stiphout |  |
| Posted: Fri Aug 29, 2008 11:45 am Post subject: Re: Can you run multiple sessions in acceses? |  |
On Fri, 29 Aug 2008 06:16:00 -0700, JK <jasonk at necoffeeco dot com> wrote:
Generally OK to do.
-Tom. Microsoft Access MVP
| Quote: | I created an application and saved it to a company server. I then split the database and created an MDE file. Using the MDE file, I copy it and then past it to each user's desktop.
Access 2003
My questions is this, would it cause any problems if the user runs multiple sessions? With the application already open; I have one user that wants to have the db open twice so that she can flip back and fourth.
Is this generally a bad idea or is ok to do? Although I've never tried it for fear of breaking the app. she say's it has worked in the past.
Thx! JK |
|
| |
| | | JK |  |
| Posted: Fri Aug 29, 2008 12:28 pm Post subject: Re: Can you run multiple sessions in acceses? |  |
Thanks!
"Tom van Stiphout" wrote:
| Quote: | On Fri, 29 Aug 2008 06:16:00 -0700, JK <jasonk at necoffeeco dot com wrote:
Generally OK to do.
-Tom. Microsoft Access MVP
I created an application and saved it to a company server. I then split the database and created an MDE file. Using the MDE file, I copy it and then past it to each user's desktop.
Access 2003
My questions is this, would it cause any problems if the user runs multiple sessions? With the application already open; I have one user that wants to have the db open twice so that she can flip back and fourth.
Is this generally a bad idea or is ok to do? Although I've never tried it for fear of breaking the app. she say's it has worked in the past.
Thx! JK
|
|
| |
| | | David W. Fenton |  |
| Posted: Fri Aug 29, 2008 7:40 pm Post subject: Re: Can you run multiple sessions in acceses? |  |
=?Utf-8?B?Sks=?= <jasonk at necoffeeco dot com> wrote in news:0A87C4A4-E446-49A4-8387-78D8718FE15A@microsoft.com:
| Quote: | I have one user that wants to have the db open twice so that she can flip back and fourth.
|
While that's an easy method, it can lead to locking issues.
You might want to learn about opening multiple form instances. I've done that for clients who were doing exactly the same thing and they much prefer flipping back and forth between the two or three open forms than flipping between multiple instances of Access.
-- David W. Fenton LINK usenet at dfenton dot com LINK |
| |
|
|