Solved

.ADP file conversion to .ACCDB format - Access 2013

Posted on 2014-04-07
6
714 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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 36

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 36

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Viewers will learn how the fundamental information of how to create a table.

749 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