I have ported over several DB's from a SQL 7.0 machine onto SQL 2000 server. The users have seveal Access DB's that have been pointing to the data on the 7.0 server.
How can I point the existing queries in Access to point to the same data that now resides on the 2000 server without having to recreate the queries all over again.
Thanks in advance.
How can I point the existing queries in Access to point to the same data that now resides on the 2000 server without having to recreate the queries all over again.
Thanks in advance.