connecting SQL DB to ACCESS DB

Mac · Joined: 08 Aug 2007 Posts: 2

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

Archived from group: microsoft>public>dotnet>framework>odbcnet

Paul Clement · Joined: 08 Aug 2007 Posts: 154

On Tue, 17 Jul 2007 10:44:02 -0700, Mac 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)

connecting to HP NonStop SQL Hi All, Anybody developed a .Net App which connects to "HP NonStop SQL" database . If anybody worked with it, can you please let me know, what should be installed on my machine. Do we have any drivers for connecting from .Net App Please help me Thanks in

Connecting to MySQL Database Hi, I'm developping a Web Site using ASP.NET (C#) and I'm trying to connect to a MySQL database. My hosting provider supports: - ASP.NET 1.1 - MySQL 4.0 - MDAC 2.7 - MySQL ODBC Driver-MyODBC 3.51 Here's my code: try { connection = new OdbcC

problems connecting to Oracle DB Hello, I have this problems. I wrote a asp.net application and I tested on my pc (windows 2000, IIS 5.0) and everything works. I tried to move the application on my server, but when I try to run it, at the first attempt to connect to my Oracle Database (O

Connecting to Oracle via front-end using .NET (Type your message here) From: Joe Alkhazraji Does anyone know of a way to connect to an Oracle database using the Application Server front-end? I'm writing an application and I don't want to use SQLNET connections but r

Connecting to Oracle through front-end Hi. I am writing a custom application in Visual basic .NET that needs to use a person's Oracle Applications logon (like J_SMITH) and password to connect to Oracle and run queries as if logging into Oracle Applications instead of using a hard-coded passw