Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access 2000 slow response over WAN
Name: Ade Date: October 24, 2003 at 01:15:59 Pacific OS: Windows 2000 and XP CPU/Ram: Petntium 4, 1GB
Comment:
Hi All, We have an Access 2000 database system on a server with ODBC interface connection developed in Visual Basic 6. While deployed on our LAN, the system functions well with good response time. Recently we had to link to this database from another office location through a 128K leased line, since then we have been experiencing slow response time up to about 6 minutes to save a record. The response time in accessing the Internet from the same location is good. I need to resolve this response time problem to a minimum as soon as possible. Any help is appreciated.
Name: Noel Taylor Date: November 6, 2003 at 07:59:33 Pacific
Reply:
You may want to check and see if the SQL jet engine was installed when the original program was isntalled.
The SQL Server engine does not normally install with the program. It is on the cd but will need to installed seperate. Check the help section for the install file to look for on the program cd.
Summary: I'm having problems converting my Access 97 programs to Access 2000. String functions such as right(), date(), and chr(13)& chr(10)used in queries won't convert. I get a message undefined function. ...
Summary: Please Help! I am trying to use the CUMIPMT function to make a calculation on a MS Access 2000 form. The syntax I have used is =CUMIPMT(0.0075,360,125000,1,1,0). It is returning #Name. The msowcf.dll ...
0 
