Hi,
I have ADP file that have a connection to a SQL server 2000 through
VPN.
A month ago I strated to have a problem with it, each time that I will
try to open the ADP file it will load up and do the connection to the
server then when I want to view my DB it will locked up and its taking
about 5 to 10 mintues to retrieve the data. I checked my VPN connection
with cisco tech and they assure me that the VPN connection is working
good and they can not find any problem with it. Then I deside to make
a test using Open office 2.0 I create a DB with ADO connection and
everything working I was able to load the database without any problem.
So I went back to my ADP file and try to create a new file but the
same thing happen access is locking up and it is taking forever to
bring the DB up.
My question is can I setup my ADP file to use ADO connection and not ODBC I try to search for it but all I can find is per form and not per ADP file
I will appreciate any idea you might have.
Thank you .
