G
Guest
Hi all:
We are running Access 2002 and 2003. We use it to run queries on an SQL
datastore on a server in the same location as the client. We are running
2003 server with AD and SQL 2000(I believe)on the server. The queries have
been working correctly for a couple of years without any problem. Recently,
we changed the IP addresses on all machines including the server and the
clients running access. Since then the access database works fine until we
query the SQL datastore on the server. I have checked folder and database
privileges(access rights, etc). I am sure I have missed something somewhere.
Any ideas???
Thanks,
Michael
We are running Access 2002 and 2003. We use it to run queries on an SQL
datastore on a server in the same location as the client. We are running
2003 server with AD and SQL 2000(I believe)on the server. The queries have
been working correctly for a couple of years without any problem. Recently,
we changed the IP addresses on all machines including the server and the
clients running access. Since then the access database works fine until we
query the SQL datastore on the server. I have checked folder and database
privileges(access rights, etc). I am sure I have missed something somewhere.
Any ideas???
Thanks,
Michael