Solved

.ADP file conversion to .ACCDB format - Access 2013

Posted on 2014-04-07
6
565 Views
Last Modified: 2016-05-29
Hi,

As we all know that access ADP format have been deprecated from Access 2013.

I am required to migrate ADP format to ACCDB Access 2013 format. we have been able to import all the forms in the new file, however we got stuck in stored procedures as they are not supported by Accdb format. These procedures are being used in forms to pull data from SQL Server. We are using SQL Server 2012.

It would be great if anybody can suggest the solution.

Regards,
Rahul
0
Comment
Question by:IndiaRahul
  • 2
  • 2
6 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 168 total points
ID: 39985769
have you tried calling the stored procedure using access VBA ?

see this link
http://support.microsoft.com/kb/185125
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 166 total points
ID: 39986609
If you want to use bound forms (and you should), you will need to convert them to Access querydefs.  If validation is being done in the stored procedure, you will need to move that into the BeforeUpdate event of the appropriate Form.

If the stored procedures are used for batch updates, you can just run them from Access as Rey suggested.
0
 
LVL 24

Assisted Solution

by:Bitsqueezer
Bitsqueezer earned 166 total points
ID: 39989811
Hi,

although you cannot use the stored procedure as RecordSource in the form as in ADPs you can of course use the result of a SP in a form without a DAO object.

Simply create an ADO Recordset object (as described in the in the link Rey posted above) and then assign that to the Recordset property of the form because any form is able to work with either DAO or ADO recordsets, the form class converts them internally.

But expect some side effects in the case of a SP: For example, if you press F5 it is possible that you get errors instead of a requery because Access cannot requery such recordsets with the internal methods. So if you want to avoid that you must disable such functions and create an own requery method - or you must indeed create the logic of the SP in the frontend in VBA and use a DAO object.
(That's one of the reasons why I will go on working with ADPs as they are a lot easier to work with as ACCDB.)

Cheers,

Christian
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 39989894
For single record (or small quantity) recordsets, stored procedures offer no advantages over standard bound forms.  I would cut the cord entirely rather than worrying about side effects.
0
 
LVL 24

Expert Comment

by:Bitsqueezer
ID: 39989998
Hi Pat,

that depends on what the SP does. If it is only a replacement for a view with parameters then you're right, a simple linked view with parameters in the frontend is enough in that case. But often SPs are created to do complicated calculations, summations, procedural code and so on - there's nothing which could replace that in the frontend which would make sense because that's the real power of using a database server: Having an active backend which can do all the heavy data work and only return the result.

Cheers,

Christian
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now