×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Jobs

MS Access 2013 and Stored Procedures

MS Access 2013 and Stored Procedures

MS Access 2013 and Stored Procedures

(OP)
To any MS Access 2013 users out there: if you were using an earlier version of Access as .adp projects with SQL back end tables AND stored procedures, were you able to convert to MS Access 2013 by linking your SQL tables AND by linking your SQL stored procedures? Or were you only able to link your SQL tables and have to convert to pass-thru queries from the Access side?

My department has been using Access projects very successfully for years and have quite a few Access db's with many, many SQL tables and just as many stored procedures, some very long and complicated. All work very, very well. But now, within the next two years, we will be upgrading to Access 2013. How much (future) trouble are we in?

Many blogs on the internet reference 'linking' SQL tables but no one specifically addresses the stored procedures.

Not sure if I want to hear the news, but will welcome any advice, info on this. Thanks in advance.

RE: MS Access 2013 and Stored Procedures

I've not used 2013 but I expect it has not changed much.

You can link your tables and use ADO or SQL Pass-thru queries for your stored procedures.

The catch of course may be that Acess treats all tables the same whether they are native or whatever and you may hit some performance snags whith the ACE database engine doing table scans where it may be less likely in an ADP. Access client-server has entire books on the subject. You also may do better with this question in the Other Topics forum as 2013 user's are not likely to look in the ADP forum.

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!

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