Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-05-16
7
Medium Priority
?
1,382 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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1500 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

Independent Software Vendors: 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!

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

927 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