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

I have also compacted the access database and updated the links to SQl
database.

"Michael in Florida" wrote:

> 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