Solved

Importing a report into an ACCDE

Posted on 2010-11-29
10
498 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
10 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 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
 

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

912 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

17 Experts available now in Live!

Get 1:1 Help Now