<div>
Hello Scott<br />
<br />
I will give that a shot.<br />
<br />
Thank yoU!
</div>


<div>
I think Mr. McDaniel's advice is exactly correct. <br />
<br />
FWIW, I get the impression that it might be a good time to plan a migration to something more sustainable while you have time. The great news is you already have the data in the cloud.<br />
<br />
Good luck!
</div>


<div>
Hello funwithdotnet<br />
<br />
Do you have any suggestions for another platform? &nbsp;I would love to move it to something else so any advice is greatly appreciated!<br />
<br />
Thank you<br />
Andy
</div>


<div>
Given his handle, I'm sure he would agree that a .NET environment would be more suitable for your needs :)<br />
<br />
FWIW, I agree that planning a move to .NET is not a bad idea, but this is something that can take quite a bit of effort (and money, if you can't do it yourself). The .NET platform gives you much greater latitude in terms of design and such, but it's definitely not Access, and there is a fairly steep learning curve.
</div>


<div>
<i>Just because data is in a SQL Server database, doesn't mean it is in the cloud.</i><br />
<br />
The author said they're using Azure.
</div>


<div>
Hello Everyone<br />
<br />
I love reading all these different views and information. &nbsp;To go back a little, I created a new blank database and linked the tables and views. &nbsp;<br />
<br />
I then exported the Forms, Reports, Macros, and Modules from the adp to the new accdb (that was such fun)<br />
<br />
I tried running the new non-adp and I got this error (I have attached it) in one of the modules. &nbsp;I am not sure why it is not recognizing it, like I said I copied everything.<br />
<br />
ANy ideas?<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1111195/First-Error.jpg" target="_blank" class="file-inline" title="First-Error.jpg (301 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>First-Error.jpg</a>
</div>


First-Error.jpg

<div>
@Scott, We use Azure also but the database isn't in the cloud.<br />
<br />
@alevin16, Try setting a reference to the ADO library. &nbsp;It isn't set by default.
</div>


<div>
And after making that reference, you should Compile the application. This should tell you if other references are missing.<br />
<br />
To compile, first make a backup and then open the VBA Editor and click Debug - Compile. Fix any errors that you can, and post back here with those that you cannot fix.
</div>


<div>
Sorry for the delay in writing back. &nbsp;We have had other issues happening (thankfully not related to this). &nbsp;I am going to be doing more work and hopefully have some more success.
</div>


<div>
The methods suggested in my comment are one method you can use to convert. Other suggestions for different platforms are certainly valid as well.
</div>


<div>
<div class="content wysiwyg-content">
Hello All<br />
<br />
Is there a reliable way to convert an Access adp to an accdb? &nbsp;As most of you know :D &nbsp;I have an Access program that has an SQL backend up on Azure, and a front end that is loaded with VBA.<br />
<br />
It was created in Access 2010 and Access 2013 and greater do not support adp. &nbsp;<br />
<br />
I am dreading doing this because I cannot believe there is an easy or reliable way (I do not want to have to worry about recoding the VBA)<br />
<br />
Any advice?
</div>
</div>


Hello All

Is there a reliable way to convert an Access adp to an accdb?  As most of you know :D  I have an Access program that has an SQL backend up on Azure, and a front end that is loaded with VBA.

It was created in Access 2010 and Access 2013 and greater do not support adp.  

I am dreading doing this because I cannot believe there is an easy or reliable way (I do not want to have to worry about recoding the VBA)

Any advice?

Converting an Access adp to an Access accdb

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Remote access may refer to the connection to a data-processing system from a remote location, for example through a virtual private network remote desktop software, terminal emulation, or the activation of features of a business telephone system from outside the business's premises.

Remote Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.