Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Am I still using Jet with SQL Server?

Am I still using Jet with SQL Server?

Am I still using Jet with SQL Server?

I ran across this link. https://www.fmsinc.com/microsoftaccess/SQLServerUp...

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.

RE: Am I still using Jet with SQL Server?

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.

Hook'D on Access
MS Access MVP 2001-2016

RE: Am I still using Jet with SQL Server?

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close