![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
If I deploy an application to a terminal server (Windows 2008 64 bit) it runs OK for me but if someone else opens it, the objects seem to disappear out of the navigation pane and errors occur like "cannot find form xxx" even though that form should exist. If that user compacts the database then it runs fine, until they log out and log back in again the same thing occurs. Compacting the database fixes it for that session only. If I open the database after the other person has compacted it then the same error occurs until I compact it myself. No-one is opening it simultaneously. If I deploy to a machine running Windows XP it is fine, even with different people logging in on RDP. The Windows group Everyone has full control to the folder where the ACCDB file is, happens with ACCDE files as well. |
#3
| |||
| |||
|
|
Travis Crow <noreply (AT) invalid (DOT) org> wrote in news:4d751c1d$0$12173$fa0fcedb (AT) news (DOT) zen.co.uk: If I deploy an application to a terminal server (Windows 2008 64 bit) it runs OK for me but if someone else opens it, the objects seem to disappear out of the navigation pane and errors occur like "cannot find form xxx" even though that form should exist. If that user compacts the database then it runs fine, until they log out and log back in again the same thing occurs. Compacting the database fixes it for that session only. If I open the database after the other person has compacted it then the same error occurs until I compact it myself. No-one is opening it simultaneously. If I deploy to a machine running Windows XP it is fine, even with different people logging in on RDP. The Windows group Everyone has full control to the folder where the ACCDB file is, happens with ACCDE files as well. Office 2010 requires the Enterprise version to run on Windows Terminal Server, right? |
|
It sounds like you're sharing a database, and you shouldn't do that (except the back end) on Terminal Server any more than you should do it on an individual workstation. Each user needs their own copy of the front end (your app is split, right?). |
|
No-one is opening it simultaneously. ;-) |
#4
| |||
| |||
|
|
On Mon, 07 Mar 2011 19:56:07 +0000, David-W-Fenton wrote: Travis Crow <noreply (AT) invalid (DOT) org> wrote in news:4d751c1d$0$12173$fa0fcedb (AT) news (DOT) zen.co.uk: If I deploy an application to a terminal server (Windows 2008 64 bit) it runs OK for me but if someone else opens it, the objects seem to disappear out of the navigation pane and errors occur like "cannot find form xxx" even though that form should exist. If that user compacts the database then it runs fine, until they log out and log back in again the same thing occurs. Compacting the database fixes it for that session only. If I open the database after the other person has compacted it then the same error occurs until I compact it myself. No-one is opening it simultaneously. If I deploy to a machine running Windows XP it is fine, even with different people logging in on RDP. The Windows group Everyone has full control to the folder where the ACCDB file is, happens with ACCDE files as well. Office 2010 requires the Enterprise version to run on Windows Terminal Server, right? It's "Pro" but the install key is one for terminal server, it refuses to install with the normal cd key. |
|
It sounds like you're sharing a database, and you shouldn't do that (except the back end) on Terminal Server any more than you should do it on an individual workstation. Each user needs their own copy of the front end (your app is split, right?). It is split, actually SQL Server back-end, only one user was on it at any one time. See above: No-one is opening it simultaneously. |
#5
| |||
| |||
|
|
No one is opening WHAT simultaneously? Obviously, not the back end. But are you trying to share a front end? Saying it's split is only half the battle -- you also have to make sure mutliple users aren't opening the front end at the same time. |
#6
| |||
| |||
|
|
On Wed, 09 Mar 2011 18:36:19 +0000, David-W-Fenton wrote: No one is opening WHAT simultaneously? Obviously, not the back end. But are you trying to share a front end? Saying it's split is only half the battle -- you also have to make sure mutliple users aren't opening the front end at the same time. No-one is opening the front-end simultaneously |
|
Travis Crow <noreply (AT) invalid (DOT) org> wrote in news:4d751c1d$0$12173$fa0fcedb (AT) news (DOT) zen.co.uk: If I deploy an application to a terminal server (Windows 2008 64 bit) it runs OK for me but if someone else opens it, the objects seem to disappear out of the navigation pane and errors occur like "cannot find form xxx" even though that form should exist. If that user compacts the database then it runs fine, until they log out and log back in again the same thing occurs. Compacting the database fixes it for that session only. |
#7
| |||
| |||
|
|
Travis Crow <noreply (AT) invalid (DOT) org> wrote in news:4d78b8c7$0$12158$fa0fcedb (AT) news (DOT) zen.co.uk: On Wed, 09 Mar 2011 18:36:19 +0000, David-W-Fenton wrote: No one is opening WHAT simultaneously? Obviously, not the back end. But are you trying to share a front end? Saying it's split is only half the battle -- you also have to make sure mutliple users aren't opening the front end at the same time. No-one is opening the front-end simultaneously Then I don't really understand what you meant when you wrote: Travis Crow <noreply (AT) invalid (DOT) org> wrote in news:4d751c1d$0$12173$fa0fcedb (AT) news (DOT) zen.co.uk: If I deploy an application to a terminal server (Windows 2008 64 bit) it runs OK for me but if someone else opens it, the objects seem to disappear out of the navigation pane and errors occur like "cannot find form xxx" even though that form should exist. If that user compacts the database then it runs fine, until they log out and log back in again the same thing occurs. Compacting the database fixes it for that session only. Why don't you give explicitly steps for what is being done that's causing the problem? |
#8
| |||
| |||
|
|
As above, user A deploys app on terminal server, runs it, it's OK User A logs out User B logs in, runs app, problem occurs User B Compacts database, is OK User B can close database and re-open it no problem but if user B logs out then logs back in again, the same problem occurs. |
|
I did manage to reproduce the problem on a workstation, but only once, again, compacting the database fixed it. It's as though there's some sort of corruption occurring. It's as though the database is possibly not getting closed when the user logs out of the terminal server |
|
, perhaps Access is getting stuck in memory and keeping it open but this doesn't appear to be the case as I have monitored for instances of msaccess.exe in task manager and it is exiting whenever a user exits the app. Unless there's a rouge DLL sitting around in memory that's got the database open but then I wouldn't be able to compact it. |
#9
| |||
| |||
|
|
If I deploy an application to a terminal server (Windows 2008 64 bit) it runs OK for me but if someone else opens it, the objects seem to disappear out of the navigation pane and errors occur like "cannot find form xxx" even though that form should exist. If that user compacts the database then it runs fine, until they log out and log back in again the same thing occurs. Compacting the database fixes it for that session only. If I open the database after the other person has compacted it then the same error occurs until I compact it myself. No-one is opening it simultaneously. If I deploy to a machine running Windows XP it is fine, even with different people logging in on RDP. The Windows group Everyone has full control to the folder where the ACCDB file is, happens with ACCDE files as well. -- Travis Crow |
![]() |
| Thread Tools | |
| Display Modes | |
| |