A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access database SQL split and Terminal Services



 
 
Thread Tools Display Modes
  #1  
Old November 3rd, 2009, 11:45 AM posted to microsoft.public.access
Kelly
external usenet poster
 
Posts: 469
Default Access database SQL split and Terminal Services

Hi, I'm running an Access database that's been running for 2 years without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client running
Terminal Services. I was using Access 2000 and the problem is that the thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem to
change anything. I only have (2) users using the database, (1) being a PC and
the other a thin client. The PC doesn't have this problem.

Thank you,
  #2  
Old November 3rd, 2009, 01:27 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Access database SQL split and Terminal Services

"Kelly" wrote in message
...
Hi, I'm running an Access database that's been running for 2 years without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client
running
Terminal Services. I was using Access 2000 and the problem is that the
thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do
to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem
to
change anything. I only have (2) users using the database, (1) being a PC
and
the other a thin client. The PC doesn't have this problem.


With terminal services, you must have a copy of the front-end for each user.
I usually put a folder on the machine with the front-end in it, and when the
users logs in, (s)he is directed to that folder and not permitted to go
anywhere else. I have never had a problem with multiple users some with
local LAN front-ends, and others on a terminal server (and still others with
an asp front end) The web server and database were on the same server, and
the terminal server clients had their own server. I have also had multiple
terminal server clients on the same server as the back end without any
problems.

In your case, I'd set up perfmon.exe to monitor the terminal server since,
that is probably the cause of your problem.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


  #3  
Old November 4th, 2009, 12:50 AM posted to microsoft.public.access
GBA
external usenet poster
 
Posts: 174
Default Access database SQL split and Terminal Services

isn't an Access issue per se....there is nothing in Access which knows that
one is using terminal services, so there is no setting or anything that one
could change.

whether terminal services or not terminal services; one should split an
Access db and establish a front end.mdb (FE) for each user. in a non
terminal services environment you put the FE on the PC of each user. in a
terminal services environment you put that FE in each users virtual space -
the exact instructions depend on the version and maker of your terminal
services...and so you will want their assist.....

"Kelly" wrote:

Hi, I'm running an Access database that's been running for 2 years without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client running
Terminal Services. I was using Access 2000 and the problem is that the thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem to
change anything. I only have (2) users using the database, (1) being a PC and
the other a thin client. The PC doesn't have this problem.

Thank you,

  #4  
Old November 4th, 2009, 11:41 AM posted to microsoft.public.access
Kelly
external usenet poster
 
Posts: 469
Default Access database SQL split and Terminal Services

That's good. I do beleive I may have found the resolution to the problem.
What I've found is that when the users are calling up drawings from out local
intranet, Adobe Acrobat Reader would open up to display the drawing. They
would then select the Print icon to print the drawing and the lockup would
occur quite often. Yesterday, in the preferences of the reader, I modified
the connection which was set to dialup connection at 56kb and changed it to
be a LAN connection which it is. I checked the event view on the Terminal
Server this morning and I don't see any events from last night, which in the
past I saw many events. I think this may have been the root cause. I will
monitor this for another day and if all goes well, this was it. I will
respond back to verify this.
Thank you!

"GBA" wrote:

isn't an Access issue per se....there is nothing in Access which knows that
one is using terminal services, so there is no setting or anything that one
could change.

whether terminal services or not terminal services; one should split an
Access db and establish a front end.mdb (FE) for each user. in a non
terminal services environment you put the FE on the PC of each user. in a
terminal services environment you put that FE in each users virtual space -
the exact instructions depend on the version and maker of your terminal
services...and so you will want their assist.....

"Kelly" wrote:

Hi, I'm running an Access database that's been running for 2 years without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client running
Terminal Services. I was using Access 2000 and the problem is that the thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem to
change anything. I only have (2) users using the database, (1) being a PC and
the other a thin client. The PC doesn't have this problem.

Thank you,

  #5  
Old November 5th, 2009, 01:15 PM posted to microsoft.public.access
Kelly
external usenet poster
 
Posts: 469
Default Access database SQL split and Terminal Services

Arvin - Thank you,
I will take your advice and see if there is something else going on with the
server. I'm noticing that the problem with Access buttons not working is now
godn and the events seem to be relating to the HP printer driver - it looks
like anyway. I will report back my findings.

Thank you!

"long" wrote:


"Arvin Meyer [MVP]" дÈëÏûÏ¢ÐÂÎÅ:uWpLBEIXKHA.1372@TK2MSFTN GP02.phx.gbl...
"Kelly" wrote in message
...
Hi, I'm running an Access database that's been running for 2 years
without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client
running
Terminal Services. I was using Access 2000 and the problem is that the
thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do
to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem
to
change anything. I only have (2) users using the database, (1) being a PC
and
the other a thin client. The PC doesn't have this problem.


With terminal services, you must have a copy of the front-end for each
user. I usually put a folder on the machine with the front-end in it, and
when the users logs in, (s)he is directed to that folder and not permitted
to go anywhere else. I have never had a problem with multiple users some
with local LAN front-ends, and others on a terminal server (and still
others with an asp front end) The web server and database were on the same
server, and the terminal server clients had their own server. I have also
had multiple terminal server clients on the same server as the back end
without any problems.

In your case, I'd set up perfmon.exe to monitor the terminal server since,
that is probably the cause of your problem.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com



.

  #6  
Old November 8th, 2009, 12:54 AM posted to microsoft.public.access
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Access database SQL split and Terminal Services

GBA wrote:

whether terminal services or not terminal services; one should split an
Access db and establish a front end.mdb (FE) for each user. in a non
terminal services environment you put the FE on the PC of each user. in a
terminal services environment you put that FE in each users virtual space -
the exact instructions depend on the version and maker of your terminal
services...and so you will want their assist.....


Depending on how the users home directories and such are configured
you could use the free Auto FE Updater utility see
http://www.autofeupdater.com to keep each individuals FE up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
  #7  
Old May 3rd, 2010, 08:10 PM posted to microsoft.public.access
kaylee
external usenet poster
 
Posts: 3
Default Access database SQL split and Terminal Services

fkfneerereegjnrnerneeeyr
"Kelly" wrote in message
...
Hi, I'm running an Access database that's been running for 2 years without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client
running
Terminal Services. I was using Access 2000 and the problem is that the
thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do
to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem
to
change anything. I only have (2) users using the database, (1) being a PC
and
the other a thin client. The PC doesn't have this problem.

Thank you,


  #8  
Old May 3rd, 2010, 10:32 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Access database SQL split and Terminal Services

Make sure that the PC is running the front-end from a workstation, not the
server. Each of the Terminal services clients need their own copy of the
front-end. I usually do this by creating a folder for each thin client user
and putting a copy of the front-end in it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"kaylee" gybrvuh28185 wrote in message
...
fkfneerereegjnrnerneeeyr
"Kelly" wrote in message
...
Hi, I'm running an Access database that's been running for 2 years
without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client
running
Terminal Services. I was using Access 2000 and the problem is that the
thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do
to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem
to
change anything. I only have (2) users using the database, (1) being a PC
and
the other a thin client. The PC doesn't have this problem.

Thank you,




  #9  
Old May 15th, 2010, 06:11 PM posted to microsoft.public.access
kaylee
external usenet poster
 
Posts: 3
Default Access database SQL split and Terminal Services


flggkfgkgjgkgkfdkffgukgjiddkdig. iggdiuggi
"Kelly" wrote in message
...
Hi, I'm running an Access database that's been running for 2 years without
problems. I have the backend on a Sequel2000 Server and never had any
problems with it. I now swapped out the computer with a thin client
running
Terminal Services. I was using Access 2000 and the problem is that the
thin
client access application keeps locking up. The mouse click seems to stop
working for the access application. Is there something special I must do
to
use this database in a terminals service session?
I ended up making it an MDE thinking this would help, but it didn't seem
to
change anything. I only have (2) users using the database, (1) being a PC
and
the other a thin client. The PC doesn't have this problem.

Thank you,


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.