Solved

Converting MS Access Code into stand-alone application (not Access MDE)

Posted on 2013-05-16
7
1,298 Views
Last Modified: 2013-05-29
I have created a MS Access application using Tables, Queries, Forms and VBA to select up to 3,000 CD's from server and to load them into a Virual CD/DVD Drive (on workstation) for easy access and faster viewing.

I am keen to replace this with a stand-alone application that does not require MS Access. Happy to use MYSQL database for the data, but need some assistance in deciding what to use for application.

Are there any conversion tools to convert cureent VBA code? Can anyone suggest an application/Code I could use that may be adequate?
0
Comment
Question by:AIGS
[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
  • 2
  • +1
7 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39171092
<<Can anyone suggest an application/Code I could use that may be adequate? >>

 Depends on what you want to do with it and what kind of features/functionaility you have in it.

  The world is heading towards the web, so Access 2013 with Access Services through Office 365 might be workable (it's still a re-write though and at present will only handle simple apps) or something like ASP.Net.

  Then there are products out there like VB.Net coupled with mySQL or SQL Server, which give you standalone code and a robust data store.

  Also others like Alpha 5, which many in the Access world are shifting to.  It offers both traditional desktop development and web based.

 Whatever path you choose, pretty much figure on a total re-write.

Jim.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39171525
<No Points wanted>

I agree with Jim

<Whatever path you choose, pretty much figure on a total re-write.>

Though there are many tools that claim to be able to "convert" vba to a .net language... (and My guess that they are getting better all the time), none of them are "perfect" and will probably result in very sloppy code.
So you will probably need a re-write anyway, ...not even considering the learning curve of the conversion tool, or the cost...
0
 

Expert Comment

by:David Smithstein
ID: 39175404
What is your original reason for wanting to replace MS Access?  Are you sure you have to?  Access Runtime is free to deploy for anyone who wants to use your application.
0
Industry Leaders: 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:AIGS
ID: 39176419
Why do I want to replace MS Access? - It is working fine at present for what I need - willing to do complete rewrite if there are definate advantages in doing so - Ultimate aim is to have something that will work on Mac, PCs and Tablets (via web interface). In fact a web interface for eveything would be great. Don't want much do I?
0
 

Expert Comment

by:David Smithstein
ID: 39176458
I've been considering Alpha 5 myself.  The biggest advantages for me would be getting onto Mac and tablets.

I would recommend starting the transition before you have too much to rewrite.
0
 
LVL 57
ID: 39178531
<< Don't want much do I? >>

  Just what most developers want<g>

  Access is a great tool, but it does have several problems:

1. Heavily dependent on it's running environment (true EXE not possible - VBA references are the bane of Access developers, even with late binding).

2. Cannot use many 3rd party controls (does not fully implement the IDispatch Interface)

3. With Access alone, you cannot build 3-tier designs.

  While you can work a round just about any of the other Access short commings (i.e. lack of a true grid style control), you can't get around these and for certain apps, that can be a real problem.

Jim.
0
 

Author Closing Comment

by:AIGS
ID: 39204010
Thanks for your help and sharing your knowledge.
I clearly have to do some more investigation to ensure I am getting what I want.
As you have said, a rewrite is on the cards.

Gary
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Menus 6 57
managing events in  the webrowser control 14 66
MySql Qry performance  (Ver 5.5.17) 1 19
Access 2010 Changing String to Date with Leading Zero 11 32
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

751 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