P
Paul
I am running Access 97 databases on a Win 2000 Server
using linked tables from an SQL server. When I run an
update query using a VBA function to update records in a
linked SQL table, Access closes by itself without any
error or warning. If I run the same query on a local
table, it works fine. I can open the linked table up and
edit records manually, and I can edit records using update
queries that dont use VBA functions without a problem.
The odd thing is I have two other servers running the same
databases without error. The main difference between the
three servers is the first two that do work were installed
as Windows 2000 Server SP2 and upgraded to SP3 including
hotfixes. The third server was installed as Windows 2000
Server SP3.
This problem has me at a stand still and I have 40 staff
waiting to move out of the head office but can't until
this server is up.
I would appreciate any help I can get.
Paul.
using linked tables from an SQL server. When I run an
update query using a VBA function to update records in a
linked SQL table, Access closes by itself without any
error or warning. If I run the same query on a local
table, it works fine. I can open the linked table up and
edit records manually, and I can edit records using update
queries that dont use VBA functions without a problem.
The odd thing is I have two other servers running the same
databases without error. The main difference between the
three servers is the first two that do work were installed
as Windows 2000 Server SP2 and upgraded to SP3 including
hotfixes. The third server was installed as Windows 2000
Server SP3.
This problem has me at a stand still and I have 40 staff
waiting to move out of the head office but can't until
this server is up.
I would appreciate any help I can get.
Paul.