Access 2.0 link to Sql Server

M

Mourad

I need to attach (link) a table in SQL Server 2005 database to an
Access 2.0 front-end database:

On Access 2.0: Click File\Attach Table..., select <SQL Database> click
OK

On the "SQL Data Sources" dialog box, however, I cannot see a "SQL
Server" selection!!!

So' I'm unable to link!

I hope my question is clear.

Thanks for reading,

Mourad
 
J

John W. Vinson

I need to attach (link) a table in SQL Server 2005 database to an
Access 2.0 front-end database:

On Access 2.0: Click File\Attach Table..., select <SQL Database> click
OK

On the "SQL Data Sources" dialog box, however, I cannot see a "SQL
Server" selection!!!

So' I'm unable to link!

I hope my question is clear.

Thanks for reading,

Mourad

2.0!?!

That's *fifteen years old*!!! Do you drive a 1937 Cord?

I don't currently have it installed (yes, I still have the ten or twelve
diskettes) but try looking for "ODBC Connection" instead of SQL/server. You
will need to define an ODBC Connection in Control Panel... Adminiistrative
Tools... Data Sources.
 
L

Larry Linson

I worked on an Access 2.0 client application to Informix. The DBA used a
third-party ODBC Driver (which name I forget at the moment, but I remember
the company was acquired by another) that worked very well. On the other
hand, I _do_ wish I owned a 1937 Cord! But, I'm not sure whether any
company still sells drivers for Access 2.0... nor whether one that Microsoft
would (probably) still have somewhere would work with SQL Server 2005.

I haven't tried it, but am told that Access 2.0 will not run on a machine
with more than 1GB memory (or was it 2GB). The only machine on which I
still have Access 2.0 installed is a vintage-1999 PII 450 with 256MB. It
was good, solid software in its day, and still is, if security is not an
issue. I have also been told if your machine is a "big mama" with lots of
memory and you need to run Access 2.0, you can create a virtual machine with
less memory so it doesn't crash.

Larry Linson
Microsoft Office Access MVP
 
D

david

You need 16 bit ODBC drivers, and the 16 Bit ODBC framework.

Get your Access 2.0 install disks, and re-install the ODBC drivers.

Open the 16-bit ODBC control in Control Panel, and create a
File DSN for your SQL Server.

(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top