Am I still using Jet with SQL Server? 1

[TheresAlwaysAWay]

I ran across this link.

https://www.fmsinc.com/microsoftaccess/SQLServerUpsizing/how/index.htm

In it they explain four different usage modes for Access.

1) Microsoft Access and Jet Single User
2) Microsoft Access and Jet Multi-User
3) Microsoft Access, Jet, and SQL Server
4) Microsoft Access and SQL Server without Jet

It's 3 and 4 that have me confused. I didn't even know 3 existed since I always assumed as soon as there was a SQL Server back end Jet was essentially disabled, so I'm wondering if someone can clarify. Basically the Access 2007 db has been split with a SQL Server back end, but am I still using Jet? How can I tell? I still use local tables for specific purposes as well, in case that makes a difference.

Thanks in advance.

 

[dhookom]

With linked SQL server tables you are using Jet to manage your queries etc. Notice how you use "#" for date delimiters and " for strings. In SQL you would use ' for both.

SQL Server without Jet might be referring to ADPs which FMS correctly states are no longer supported.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[TheresAlwaysAWay]

Thank you, Duane. Yours was exactly the answer I was looking for.

The article confused me and I needed someone to set me straight!