Data Provider for SQL Server and Access

[iakovosjam]

I am new to VB.NET and I am going to be writing an application that uses both SQL Server and Access databases. Would it be better to use the OLEDB data provider for both databases or should I use native sql provider?

 

[cjard]

Use Jet OLE for access, use native Sql for SQLS.. Keep the datasets separate. If data is to be pushed between databases, set up a Linked Server in SQLS and push the data directly.