Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Converting to accde files

Posted on 2010-08-23
4
Medium Priority
?
298 Views
Last Modified: 2013-12-25
Greetings all ...

A solution I've just received on a different question is (finally!) providing strong encouragement for me to convert my applications to accde/accdb pairs of files. I'm concerned that coding practices I've adopted in the past won't easily support a conversion to an accde environment. At least not without some serious rethinking and quite a bit of recomposition.

To date the structure I've utilized is basic textbook. Two files, one front end and one back end, both mdb or accdb files. Back end file is all tables, front end file is everything else (including an autoexecute macro), with links to all the tables in the back end. Basic beginner textbook.

The most obvious potential conflict I'm envisioning, as I try to convert at least one of these files to a compiled format, is that I have dozens of instances throughout the front end of my apps where queries, based on conditions available at the moment, are created on the fly, executed, and then deleted. Am I right in assuming that those, at least as they're currently structured, won't run in an accde environment?

Let's assume that my rewriting all instances of this 'create/manipulate/delete' coding methodology isn't an option. Is it possible for me, from within the accde file, to direct that these temporary objects be managed on a workspace within another, linked, read/writable accdb file?

I hope I've articulated this little issue clearly. The implications of your responses, regarding the larger general question of 'how to manage multiple linked files', will clearly have a huge bearing on how I view and map out future projects.

I am so grateful for your willingness to lend your expertise to lost souls like me!

Best,

John
0
Comment
Question by:jofoco4
[X]
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
  • 2
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 33501442
You cannot create forms or reports in the .accde environment, but you can create/delete queries, if that's what you're asking.

That said, I've rarely found a need to create/delete querie on the fly. You can always just build a temporary query and work with the QueryDef object as needed.
0
 

Author Comment

by:jofoco4
ID: 33501754
Thanks for this. My apps don't currently create forms or reports, so I think I'm safe on that front.

One quick followup. I don't understand the distinction you draw between "creating/deleting queries on the fly", and "just build a temporary query and work with the QueryDef object as needed".

This confusion is probably my fault, in how I phrased my first question. Building a temporary query and working with the querydef is how I "create/delete queries on the fly". It's likely your response was just confirming for me that this method is generally accepted.

Thanks again for your prompt reply!

Best,

John
0
 
LVL 85
ID: 33506098
By "on the fly", I mean actually creating a QueryDef and populating it.

My description was probably not as clear as it should be. I think you're better off creating and storing a query in the database and then just manipulating that query as needed - i.e. change the SQL property to reflect what you need, then "run" that query. Better yet, just use SQL where possible and be done with it!
0
 

Author Comment

by:jofoco4
ID: 33506424
Good thoughts. Thanks.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

650 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