I'm sort of new to this and have done this in the past, but I have a new
laptop and apparently don't have every thing I need (I think that's the
problem).

I have a SQL database that I need to see in thru access (there are reports
built on the access DB thaty I need to modify )

How do I get them linked (SQL 2000 / Access 2000 and/or 2003)
--
Mac

On Tue, 17 Jul 2007 10:44:02 -0700, Mac <Mac (AT) discussions (DOT) microsoft.com> wrote:

¤ I'm sort of new to this and have done this in the past, but I have a new
¤ laptop and apparently don't have every thing I need (I think that's the
¤ problem).
¤
¤ I have a SQL database that I need to see in thru access (there are reports
¤ built on the access DB thaty I need to modify )
¤
¤ How do I get them linked (SQL 2000 / Access 2000 and/or 2003)

If the Access database is working off of linked tables then you can probably use the Linked Table
Manager to re-link your SQL Server tables.

I'm assuming that is the problem you're having since you didn't mention any errors or the exact
problem.


Paul
~~~~
Microsoft MVP (Visual Basic)