dbTalk Databases Forums  

running MS Access using Remote Desktop

comp.database.ms-access comp.database.ms-access


Discuss running MS Access using Remote Desktop in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Al
 
Posts: n/a

Default running MS Access using Remote Desktop - 07-16-2003 , 06:13 PM






Hello all,

Has anyone out there tried running an Access adp file using Remote
Desktop/Terminal Services from a pocket PC? I was able to connect to
the desktop PC but when I tried running Access, it gave me the error
that "A video adapter resolution of at least 640x480 pixels is
required to run Microsoft Access." Is there any way of getting around
this? Does anyone have a better solution for using an Access DB from a
pocket PC rather than using RD/TS? Maybe it's our network, but when
using RD/TS, my connectiong keeps getting dropped after about 5
minutes. I'm running Win CE 4.10 and Win 2k with SR2 from my desktop.
Thanks in advance.

Al

Reply With Quote
  #2  
Old   
Ananda Sim
 
Posts: n/a

Default Re: running MS Access using Remote Desktop - 07-16-2003 , 08:28 PM






Hi Al,

Your problem has been proved. I ran PocketPC via USB via Desktop PC cable
modem to the my PC in the Office. Ran an .ade / adp (I have Access 2002 and
2000 there but I think 2000 prefers to launch when you double click on a
document). Got your 640x480 message.

Connection via Terminal Services is steady, no drop outs - there are a few
km between my PocketPC and the Office PC.

If you are using .adp, you are obviously using SQL Server engine in the back
end. Looks like the most promising way would be to design server scripted
web pages to expose your data as web pages and use PocketIE to do your work.

I have not tried VNC - that might get around that 640x480 issue but I
believe VNC would generate more traffic than Terminal Services.

Hope This Helps

Ananda


"Al" <b_i_g_a_l_ (AT) hotmail (DOT) com> wrote

Quote:
Hello all,

Has anyone out there tried running an Access adp file using Remote
Desktop/Terminal Services from a pocket PC? I was able to connect to
the desktop PC but when I tried running Access, it gave me the error
that "A video adapter resolution of at least 640x480 pixels is
required to run Microsoft Access." Is there any way of getting around
this? Does anyone have a better solution for using an Access DB from a
pocket PC rather than using RD/TS? Maybe it's our network, but when
using RD/TS, my connectiong keeps getting dropped after about 5
minutes. I'm running Win CE 4.10 and Win 2k with SR2 from my desktop.
Thanks in advance.

Al



Reply With Quote
  #3  
Old   
Al
 
Posts: n/a

Default Re: running MS Access using Remote Desktop - 07-17-2003 , 12:33 PM



Thanks for your response. I looked into VNC and seems like VNC doesn't
support multiple concurrent users connected to the same server/host
computer, so that option is out, as we plan on having at least 2
connected at a time.

"Ananda Sim" <anandasim (AT) optushome (DOT) com.au.invalid> wrote

Quote:
Hi Al,

Your problem has been proved. I ran PocketPC via USB via Desktop PC cable
modem to the my PC in the Office. Ran an .ade / adp (I have Access 2002 and
2000 there but I think 2000 prefers to launch when you double click on a
document). Got your 640x480 message.

Connection via Terminal Services is steady, no drop outs - there are a few
km between my PocketPC and the Office PC.

If you are using .adp, you are obviously using SQL Server engine in the back
end. Looks like the most promising way would be to design server scripted
web pages to expose your data as web pages and use PocketIE to do your work.

I have not tried VNC - that might get around that 640x480 issue but I
believe VNC would generate more traffic than Terminal Services.

Hope This Helps

Ananda


"Al" <b_i_g_a_l_ (AT) hotmail (DOT) com> wrote in message
news:a5ab2093.0307161513.1ad9db62 (AT) posting (DOT) google.com...
Hello all,

Has anyone out there tried running an Access adp file using Remote
Desktop/Terminal Services from a pocket PC? I was able to connect to
the desktop PC but when I tried running Access, it gave me the error
that "A video adapter resolution of at least 640x480 pixels is
required to run Microsoft Access." Is there any way of getting around
this? Does anyone have a better solution for using an Access DB from a
pocket PC rather than using RD/TS? Maybe it's our network, but when
using RD/TS, my connectiong keeps getting dropped after about 5
minutes. I'm running Win CE 4.10 and Win 2k with SR2 from my desktop.
Thanks in advance.

Al

Reply With Quote
  #4  
Old   
Ananda Sim
 
Posts: n/a

Default Re: running MS Access using Remote Desktop - 07-17-2003 , 06:04 PM



Hi Al,

"Al" <b_i_g_a_l_ (AT) hotmail (DOT) com> wrote

Quote:
Thanks for your response. I looked into VNC and seems like VNC doesn't
support multiple concurrent users connected to the same server/host
computer, so that option is out, as we plan on having at least 2
connected at a time.
VNC isn't anything like Terminal Services or Citrix (which by the way, you
might try). VNC is just like classic remote control and certainly, you can't
have more than one remote control session with laplink, pcanywhere and so
on - they emulate the remote screen and keyboard, not a virtual PC session.

What you are looking for is an 800x600 virtual screen with the PocketPC
being a porthole viewing a panning window within that screen - then MS
Access would work. But it would generally not be enjoyable in the least.

Server scripted web pages targeted for PocketPC size screen would be the way
to go.

Hope This Helps
Ananda




Reply With Quote
  #5  
Old   
Art Yates
 
Posts: n/a

Default Re: running MS Access using Remote Desktop - 07-18-2003 , 06:06 AM



There is a VNC option which will allow multiple users---
Go into detail and click the option.



"Al" <b_i_g_a_l_ (AT) hotmail (DOT) com> wrote

Quote:
Thanks for your response. I looked into VNC and seems like VNC doesn't
support multiple concurrent users connected to the same server/host
computer, so that option is out, as we plan on having at least 2
connected at a time.

"Ananda Sim" <anandasim (AT) optushome (DOT) com.au.invalid> wrote

Hi Al,

Your problem has been proved. I ran PocketPC via USB via Desktop PC
cable
modem to the my PC in the Office. Ran an .ade / adp (I have Access 2002
and
2000 there but I think 2000 prefers to launch when you double click on a
document). Got your 640x480 message.

Connection via Terminal Services is steady, no drop outs - there are a
few
km between my PocketPC and the Office PC.

If you are using .adp, you are obviously using SQL Server engine in the
back
end. Looks like the most promising way would be to design server
scripted
web pages to expose your data as web pages and use PocketIE to do your
work.

I have not tried VNC - that might get around that 640x480 issue but I
believe VNC would generate more traffic than Terminal Services.

Hope This Helps

Ananda


"Al" <b_i_g_a_l_ (AT) hotmail (DOT) com> wrote in message
news:a5ab2093.0307161513.1ad9db62 (AT) posting (DOT) google.com...
Hello all,

Has anyone out there tried running an Access adp file using Remote
Desktop/Terminal Services from a pocket PC? I was able to connect to
the desktop PC but when I tried running Access, it gave me the error
that "A video adapter resolution of at least 640x480 pixels is
required to run Microsoft Access." Is there any way of getting around
this? Does anyone have a better solution for using an Access DB from a
pocket PC rather than using RD/TS? Maybe it's our network, but when
using RD/TS, my connectiong keeps getting dropped after about 5
minutes. I'm running Win CE 4.10 and Win 2k with SR2 from my desktop.
Thanks in advance.

Al



Reply With Quote
Reply




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 On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.