Remote Access

[Robert L]

Hello everyone. I am looking for some help. My boss is interested in moving our database to a hosting provider, and allowing individuals to connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS Access that can be used. Our remote connectors will not have the MS Access program. I am trying to find out if anyone has heard of this type of application, and if so where can I find more information about it. I did not see anything on the Microsoft site.

Thanks!

 

[Douglas J. Steele]

VPN is almost certainly too slow to work with Access.

You might want to read what Albert Kallal has to say about using Access over
the WAN at http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello everyone. I am looking for some help. My boss is interested in
moving our database to a hosting provider, and allowing individuals to
connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS
Access that can be used. Our remote connectors will not have the MS Access
program. I am trying to find out if anyone has heard of this type of
application, and if so where can I find more information about it. I did
not see anything on the Microsoft site.

Thanks!

 

[John Vinson]

Hello everyone. I am looking for some help. My boss is interested in moving our database to a hosting provider, and allowing individuals to connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS Access that can be used. Our remote connectors will not have the MS Access program. I am trying to find out if anyone has heard of this type of application, and if so where can I find more information about it. I did not see anything on the Microsoft site.

Thanks!

I have a client who routinely uses Citrix Server/Citrix Client to let
remote users (including me!) to log on to the server and run Access.

I have not worked with VPN but I've seen some major complaints about
it. Microsoft Terminal Server might be a better bet, or you could use
the Windows public newsgroups to get more info about VPN.

John W. Vinson[MVP]

 

[Ron Hinds]

In addition to what the others wrote - you are looking for the Access Runtime. It comes with the Office Professional Editions.
Hello everyone. I am looking for some help. My boss is interested in moving our database to a hosting provider, and allowing individuals to connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS Access that can be used. Our remote connectors will not have the MS Access program. I am trying to find out if anyone has heard of this type of application, and if so where can I find more information about it. I did not see anything on the Microsoft site.

Thanks!

 

[Robert L]

Good read, and good information. Thank you, as I for one did not initially consider the speed issue. It makes sense due to the slow speed that is observed in-house on the network. I have actually dabbled with VPN over WAN in the past, and it was insanely slow, this article reminded me of this situation. Putting the two together is not going to be an option.

Thanks Douglas!

--
Robert L.
VPN is almost certainly too slow to work with Access.

You might want to read what Albert Kallal has to say about using Access over
the WAN at http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Hello everyone. I am looking for some help. My boss is interested in
moving our database to a hosting provider, and allowing individuals to
connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS
Access that can be used. Our remote connectors will not have the MS Access
program. I am trying to find out if anyone has heard of this type of
application, and if so where can I find more information about it. I did
not see anything on the Microsoft site.

Thanks!

 

[Robert L]

I am looking into the Citrix and MTS options, thank you for the leads John.

--
Robert L.

Hello everyone. I am looking for some help. My boss is interested in moving our database to a hosting provider, and allowing individuals to connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS Access that can be used. Our remote connectors will not have the MS Access program. I am trying to find out if anyone has heard of this type of application, and if so where can I find more information about it. I did not see anything on the Microsoft site.

Thanks!

I have a client who routinely uses Citrix Server/Citrix Client to let
remote users (including me!) to log on to the server and run Access.

I have not worked with VPN but I've seen some major complaints about
it. Microsoft Terminal Server might be a better bet, or you could use
the Windows public newsgroups to get more info about VPN.

John W. Vinson[MVP]

 

[Robert L]

In my research thus far, I have come across the run-time option. Just for quick clarity, the run-time can be installed on any number of computers, allowing for the remote users to work with on the front-ends without actually installing MS Access, am I correct?

Also, just to make sure, there is not a requirement to have a working copy of any office product in order to utilize the runtime?

--
Robert L.
In addition to what the others wrote - you are looking for the Access Runtime. It comes with the Office Professional Editions.
Hello everyone. I am looking for some help. My boss is interested in moving our database to a hosting provider, and allowing individuals to connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS Access that can be used. Our remote connectors will not have the MS Access program. I am trying to find out if anyone has heard of this type of application, and if so where can I find more information about it. I did not see anything on the Microsoft site.

Thanks!

 

[Albert D.Kallal]

for the remote users to work with on the front-ends without actually

installing MS Access, am I correct?

Correct. On the other hand, if you use a VPN + terminal services (included
with windows), or purchase citrix + VPN, then the performance will be
great...even with a speed rating of 1. And, you don't have to install the
ms-access (or runtime) on the client computers.

Also, just to make sure, there is not a requirement to have a working copy
of any office product in order to utilize the runtime?

correct. You will need to purchase the developers edition of office to
obtain the runtime packaging wizard...

 

[Rick Brandt]

In my research thus far, I have come across the run-time option. Just for
quick clarity, the
run-time can be installed on any number of computers, allowing for the remote
users to work
with on the front-ends without actually installing MS Access, am I correct?
Also, just to make sure, there is not a requirement to have a working copy of
any office product > in order to utilize the runtime?

Since you seemed concerned about licensing I thought I would point out that if
you go the Citrix/VPN route your remote users WILL need licenses for the Citrix
client, Terminal Services licenses to connect to the server, as well as licenses
for Access (unless the server uses the Access runtime).

 

[Mastercafe - Juan]

Why not try to do with sql server, most of ISP have SQL services and connections are easy for access. I have actually an application that use 34 terminal with sql server and its possible with a simple mdb/mde if you don't want use adp/ade.

--
Saludos desde Oviedo (Asturias)

Juan Menéndez
Mastercafe S.L.
www.mastercafe.com
(e-mail address removed)

Si la información recibido te ha servido indicalo con otro post.
En caso de resolverlo por otros medios, indica la solución usada
ayudaras a otros y aprenderemos todos.

"Robert L" <[email protected]> escribió en el mensaje Hello everyone. I am looking for some help. My boss is interested in moving our database to a hosting provider, and allowing individuals to connect from remote places via VPN in order to work in our MS Access system.

He mentioned something along the lines that there is a client version of MS Access that can be used. Our remote connectors will not have the MS Access program. I am trying to find out if anyone has heard of this type of application, and if so where can I find more information about it. I did not see anything on the Microsoft site.

Thanks!

 

[Robert L]

:sigh: Tell me about it. I have been trying to talk them into another database, but they are decided that they do not want to move away from Access. In my opinion, a SQL server would be 100 times better.

 

[John Vinson]

:sigh: Tell me about it. I have been trying to talk them into another database, but they are decided that they do not want to move away from Access. In my opinion, a SQL server would be 100 times better.

You can tiptoe them into it using MSDE. It's full SQL Server, with a 2
GByte limit on database size and a throttle on the number of
concurrent active processes, but other than that it's the same. And
it's free, on your Office Pro install disk.

John W. Vinson[MVP]

 

[Albert D.Kallal]

news:[email protected]...

:sigh: Tell me about it. I have been trying to talk them into another
database, but they are decided that they do not want to move away from
Access. In my opinion, a SQL server would be 100 times better.

--
Robert L.
-----------------------------

I don't understand here?? ms-access is like c++, or VB, or whatever
development tool you like to use. You can use oracle, or sql server for the
database, and develop the application in ms-access. You are confusing the
database system with that of a developers tool like ms-access. How can you
build a form in sql server?? (you can't, and sql server does not allow you
to build applications).

SQL server is indeed a high performance system, and also a system that can
scale to many many users.

If you write your application in c++, or VB or in your case with ms-access,
in GENERAL the performance of all of these tools will BE THE SAME.


I mean, when using a JET file share, you grab a invoice from the 75,000
record
table..only the one record is transferred down the network with a file share
(and, sql server will also only transfer one record). So, at this point, you
really will NOT notice any performance difference by upgrading to sql
server. There is no magic here.

Sql server is a robust and more scalable product then is JET. And, security,
backup and host of other reasons make sql server a good choice.
However, sql server will NOT solve a performance problem with dealing
with such small tables as 75k records

Of course, when efforts are made to utilize sql server, then
significant advances in performance can be realized.

So, you can use the database engine JET, or Sql server, or oracle, or the
free edition of sql server express....

This changes nothing in terms of continuing to use ms-access as your
developers tool..