?
Solved

.ADP file conversion to .ACCDB format - Access 2013

Posted on 2014-04-07
6
Medium Priority
?
852 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 672 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 38

Assisted Solution

by:PatHartman
PatHartman earned 664 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 664 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 38

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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

801 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