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
Solved

Importing a report into an ACCDE

Posted on 2010-11-29
10
522 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

829 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