Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 executable database application
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

zinpin
Junior Member

Australia
202 Posts

Posted - 13 August 2005 :  09:35:12  Show Profile
Hi all :) a while back i made a website for a company that now wants to have most of that factionality as an self contained executable file. My database is access and most of the work on it is already completed in terms of tables queries and such.
What do you guys think I should use to help me convert this into a exe file?

TIA

Podge
Support Moderator

Ireland
3775 Posts

Posted - 13 August 2005 :  10:33:52  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
It should be possible. Are you familiar with Visual Studio?

Would putting the website on an intranet not be an easier option than having to convert to an exe?

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 August 2005 :  15:15:55  Show Profile  Visit HuwR's Homepage
depends whether you want to maintain two sets of code or one, the only means I know of doing it succesfully with one code base is to use Delphi and Intraweb.

This site http://www.dipex.org is exactly what you describe, it is a standalone executable which is basically a custom webserver, so it can be used to run the website, or put on a cd and run locally as an executable, the web site uses a SQL backend, but by changing a line in an ini file can be pointed at any ADO compliant database like access
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 13 August 2005 :  15:27:43  Show Profile  Visit HuwR's Homepage
actually, to see the executable part you need to go to the experiences link from the menu and then choose an illness, the front few pages are a html gateway which jumps you into the actual exe. The pages are all template based so can be skinned for different audiences, for example http://www.dipex.org/lungcancer looks totally different to http://www.dipex.org/sexualhealth but is exactlt the same exe and data
Go to Top of Page

zinpin
Junior Member

Australia
202 Posts

Posted - 13 August 2005 :  18:05:36  Show Profile
Great work Huwr he he are you free for a month or so ? anyway this looks very much what they have in mind. In the case of the executable how is the database handled? Is it tamper proof in any way? Does it run as a totally stand alone application without the need of internet access?
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 14 August 2005 :  14:02:28  Show Profile
Take a look at the "Visual Studio Tools for the Microsoft Office System": http://msdn.microsoft.com/howtobuy/vsto/default.aspx

"Microsoft Office Access 2003 Developer Extensions. The Access 2003 Developer Extensions provide the tools and resources developers need to more quickly and easily create, test, and deploy sophisticated Access solutions. The Developer Extensions also include a royalty-free Access Runtime enabling distribution of Access solutions."


You would need to convert your whole application so that it all works from within the Access database though.

Edited by - pweighill on 14 August 2005 14:06:17
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 15 August 2005 :  05:42:02  Show Profile  Send pdrg a Yahoo! Message
are you sure you want an exe? Or would a rich client do? You could arcitect your app to use web services to provide the underlying data and business logic, then your website can call those webmethods, and the rich app would just provide pre-built desktop forms to access the same webmethods.

Or go one further, and build an exe with (say) VB which just contains an instance of the browser component pre-set to start at your website page... ;-)
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 15 August 2005 :  06:49:33  Show Profile  Visit HuwR's Homepage
quote:
Originally posted by zinpin

Great work Huwr he he are you free for a month or so ?
anyway this looks very much what they have in mind. In the case of the executable how is the database handled? Is it tamper proof in any way? Does it run as a totally stand alone application without the need of internet access?



Yes, it runs totally standalone, it does not require a net connection. The access db can be secured, or you could use an embedded database like dbisam for greater security
Go to Top of Page

zinpin
Junior Member

Australia
202 Posts

Posted - 16 August 2005 :  08:46:23  Show Profile
Thanks all. So Huwr even though this will sound very simplistic, on a scale from 1 to 10 what would you rate the difficulty of creating /converting what I got to an exe.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 16 August 2005 :  11:05:09  Show Profile  Visit HuwR's Homepage
quote:
Originally posted by zinpin

Thanks all. So Huwr even though this will sound very simplistic, on a scale from 1 to 10 what would you rate the difficulty of creating /converting what I got to an exe.


a simple question, but not so simple to answer

For me I would say 1, but then I have done it quite a few times, if you've never used Delphi or Intraweb then probably 10+ just depends on your ability and confidence as a coder. Not very helpful I know.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 August 2005 :  15:00:52  Show Profile  Send ruirib a Yahoo! Message
If you have the application already developed, although as a .mdb file, which is what I understood, pweighill sugestion is the fastest route to get an .exe.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07