Improve company productivity with a Business Account.Sign Up

x
?
Solved

Importing a report into an ACCDE

Posted on 2010-11-29
10
Medium Priority
?
564 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 Access MVP) 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 

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 Access MVP)
DatabaseMX (Joe Anderson - Microsoft Access MVP) 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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

606 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