Solved

Importing a report into an ACCDE

Posted on 2010-11-29
10
527 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 - Microsoft MVP, Access and Data Platform) 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Saving data on a subform when I close the form 12 27
MS Access Query Question 2 33
Union & Crosstab qrys 101! 6 53
Specify the table containg the records you want to delete 14 29
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

685 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