Access 2003 and SQL2000

[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

 

[Michel Walsh]

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

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)?

 

[Guest]

Thanks,

But the previous manner via OLE DB is still possible?

Regards
Krzysztof

 

[Michel Walsh]

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