Jim said:
Hi,
I am about to convert a .mdb file to a project. I would like to load the
data files on a remote server that has MDSE running. Can I have the .adp
files linked to the remote site via a tcp/ip connection? If so, do you
think
there will be performance issues?
Yes, you can link to that remote server. I am not really sure that you would
want to leave a server opened up to the wild internet, but to answer your
question: yes, you can remote access it. You likely would be better off to
setup a VPN, and then connect through that. There are too many security
risks to simply have a server opened, and attached to the internet. So, make
sure you got EXPERIENCED people who know EXACTLY what they are doing when
they
expose that server to the internet. This can be done, but is VERY dangrouies
when you don't know what you are doing.
If so, do you think
there will be performance issues?
As for converting to a adp project, or using a linked mdb to sql server?
Hum, you can certainly keep your application as a mdb file and use linked
tables. As a general rule you will get more performance out of a ADP
connecting to sql server then a mdb IF YOU DON'T KNOW WHAT YOU ARE doing. In
other words, if your mdb is well designed, then there is LITTLE performance
advantage of using a ADP or a MDB to connect to that remote database server.
And, remember, high speed internet is 100 TIMES SLOWER then your office LAN.
So, you better make sure you got good designs here. (you can't do really
stupid things like simply open up a form to a table without any
consideration
to what records get loaded into a form. On the other hand, I never open a
form to a table without some restrictions on the records loaded. This is
a very good practice with a regulart mdb file also. And, if you use a mdb
file to a sql server, the same thing applices. And, of couse when using
a adp, again the advice applies. So, to simply open up forms to a large
table is a VERY is a very poor design, and one also of very
poor performance anyway.
Away, you can read about deploying ms-access over the internet, and I
outline some solutions and pitfalls here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html