Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Importing a report into an ACCDE

Posted on 2010-11-29
10
Medium Priority
?
553 Views
Last Modified: 2012-05-10
I have an Application that I distribute as an ACCDE running in the 2010 runtime.

I want to allow users to modify certain reports in the ACCDE.

To accomplsh this I would supply an ACCDB with links to the backend tables and just the reports that can be modified.

So the question is - once the report is modified, is it possible, using VBA in the ACCDE, to import the modified report?
0
Comment
Question by:kentgorrell
  • 5
  • 4
9 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 34236132
No.  Access would consider that a 'design change', which cannot be done in an ACCDE.  

mx
0
 

Author Comment

by:kentgorrell
ID: 34236157
So is there another way to go about it? eg using an ACCDB as a library.
0
 
LVL 75
ID: 34236176
Another way to get them into the ACCDE?

As far as a Library, you can certainly Reference an ACCDB (or ACCDA).  And you could import the modified reports into the library and then run them.

mx
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:kentgorrell
ID: 34236207
What is an ACCDA? or was that a typo?
So it looks like a library is the way to go.

Is it possible to reference an ACCDB from an ACCDE?

I have referenced ACCDBs and MDBs from an ACCDB but I was re reading 'Access 2003 VBA Programmers Reference' (Amen Stein, Graham Seach et al) and it alluded to the need to also convert the Library to an MDE when referencing it from an MDE. But that was 2003.


0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 34236309
An ACCDA is the A2007/10 version of an MDA.  Essentially, there is no difference between an ACCDB and ACCDA (or MDB and MDA) except that ... Access will only recognize an ACCDA/MDA in the Add In Manager.  For your purpose, it might be convenient just to distinguish the file as a 'library' db.

 "Is it possible to reference an ACCDB from an ACCDE? "
Apparently not. I just tried several times.  I created the Reference while still and MDB (to another MDB), then tried to create an MDE, and it failed each time.  I'm a bit shocked, but in some ways, it makes sense.  I was able to Reference an MDE, then create an MDE, but I already knew that works.

Soooo ... seems we are back to square zero ...

mx

0
 
LVL 75
ID: 34236323
So, the Accepted Answer is incorrect.  You cannot Reference an ACCDB from an ACCDE.

The correct Answer to this Q is what I first posted.  I will hit the Request Attention button and straighten this out.  But thanks for the thought.  You had I guess Accepted before I made my last post.

mx
0
 

Author Comment

by:kentgorrell
ID: 34236367
Thanks mx.

This just means that the user will have to make an MDE (or ACCDE) after they modify a report.

Previously I've distributed this app as an MDB with a project password. Using a library is a lot more work but solves a couple of other issues like being able to install a new FE version wthout losing the user's report changes.
0
 
LVL 75
ID: 34236394
Another tip I recently found out.  IF say, you make a MDE in the A2007 environment ... that MDE (not talking about ACCDE) will *not* run in A2003.  In general, you must *create* the MDE in the lowest version you expect to be able to run in.

mx
0
 

Author Comment

by:kentgorrell
ID: 34236491
That's worth noting. Thanks for that.

Since my last PC died and I installed 2010 I haven't bothered reinstalling my old versions.

In old apps, I develop in VMs running the old version. In fact one app runs in Office 97 on one server and 2010 on another.

So now I just need a VM with Access XP to create MDEs for the odd occassion.

Mostly these days I issue ACCDBs and the 2010 runtime (Using Sagekey) and that avoids versioning issues.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

810 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