Access 2003 and SQL2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Access 2002 was integrated well with MSSQL via OLE DB, how's in this new Access 2003? Is the same mechanism, or is there any more else (I think ADO.NET)

If we can use ADO.NET then is possible to use special (from Framework.NET) assemblies for MSSQL

Thanks in advanc
Krzysztof Malinowski
 
Hi,

There is no direct support for dot-net/windows forms in that version of
Access, in Access.


Hoping it may help,
Vanderghast, Access MVP


Krzysztof Malinowski said:
Hi,

Access 2002 was integrated well with MSSQL via OLE DB, how's in this new
Click to expand...
Access 2003? Is the same mechanism, or is there any more else (I think
ADO.NET)?
 
Hi,

Yep, you can use ADO, within Access, mainly if you are using a dot-adp
(using "natively" MS SQL Server Engine instead of Jet).

Note that outside Access, the application, you can use a dot-net
environment, and still connect to a Jet database engine, through ADO-Net. It
is just that WITHIN Access itself, the programming language is still only
VBA, in the actual version.


Vanderghast, Access MVP
 
Back
Top