Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 12th, 2003, 09:02 AM
Registered User
 
Join Date: Nov 2003
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to wall_of_jericho
Default Creating stadalone access .exe file

ok the basics are in the title.

i need to convert my MS access 2002 database into a standalone .exe file...

is there anyway of doing this without reprogramming in VB

w.o.j

- Studying A2 Level ICT -
  #2 (permalink)  
Old November 12th, 2003, 10:30 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can create a .mde file. this is a compiled version of your access database and can be distributed to users. It strips the code and will not allow any changes to any forms, reports, macros that have been created prior to compiling. Make sure that you keep a back-up copy of your database because once compiled you will not be able to crack it open again.

When you do this, your database has to be split, in other words your tables have to be in one database and your other objects (forms, reports, macros, queries) will be on another database with links to your tables. The database that gets compiled to .mde will be the one with your forms, reports, etc.

One other thing to keep in mind is, you will have to create a new default toolbar so that you can hide all of the database object from the user. Again, make sure that you keep a copy of your database. A lot of people make the mistake of creating a new default toolbar, hiding the database and they are not able to get back in their database.

search microsoft's site and read a litle on mde files.



Sal
  #3 (permalink)  
Old November 12th, 2003, 09:27 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is not, however, any way to make an Access file into an EXE file

http://www.mvps.org/access/general/gen0001.htm

What you can do, however, is shell out some cash for Office Developer Edition, so you can distribute the database with a Run-time version of Access, this way your users don't have to have Access on their machine.

Since ODE is about twice the price of regular Office, you only need 3 or more users to justify the cost

Steven

I am a loud man with a very large hat. This means I am in charge
  #4 (permalink)  
Old November 13th, 2003, 08:53 AM
Registered User
 
Join Date: Nov 2003
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to wall_of_jericho
Default

thanks. Its seems a bit stupid you can't make it standalone! I'll have to get my school to look into that ODE package.

However is there not a way of using Vb to create the exe?

thanks again. :)

- Studying A2 Level ICT -
  #5 (permalink)  
Old November 13th, 2003, 08:58 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Stupid? Yes, stupid like a fox. You see, by forcing people to do it this way, Microsoft is making a bundle by forcing people to use the developer's edition. Otherwise, peope would bypass it and make EXEs all they want. It's not a matter of they can't program Access to make EXEs... it's that financially speaking, why would they want to?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #6 (permalink)  
Old November 13th, 2003, 10:33 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Another Microshaft Winblows Creature (feature). Also, ODE is not the best package and deployment tool out there. With ODE it canbe a pain do do updgades to new versions of your application and many times when Access is actually installed on the computer, strange things start to happen (DLL H***).



Sal
  #7 (permalink)  
Old November 13th, 2003, 02:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Norwich, Norfolk, United Kingdom.
Posts: 129
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ODE is sometimes available on eBay. That's where I got mine.

Clive Astley
  #8 (permalink)  
Old November 19th, 2003, 01:39 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Madison, Wisconsin, USA.
Posts: 451
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Ben Horne
Default

From my experience with MDE files, you do not have to split the database. I created an MDE file of my Music Inventory database a while back and I didn't have any major conversion problems

Quote:
quote:Originally posted by sal
 You can create a .mde file. this is a compiled version of your access database and can be distributed to users. It strips the code and will not allow any changes to any forms, reports, macros that have been created prior to compiling. Make sure that you keep a back-up copy of your database because once compiled you will not be able to crack it open again.

When you do this, your database has to be split, in other words your tables have to be in one database and your other objects (forms, reports, macros, queries) will be on another database with links to your tables. The database that gets compiled to .mde will be the one with your forms, reports, etc.

One other thing to keep in mind is, you will have to create a new default toolbar so that you can hide all of the database object from the user. Again, make sure that you keep a copy of your database. A lot of people make the mistake of creating a new default toolbar, hiding the database and they are not able to get back in their database.

search microsoft's site and read a litle on mde files.



Sal
Ben
Madison Area Technical College student
-------------------------
I am one of those people that you call "Microsoft Access Freaks". I'm addicted to Access
  #9 (permalink)  
Old November 19th, 2003, 02:11 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It is best to split the database. "Access will crash". When the database is split and you have a backup copy of your forms, it is easier to re-start. It is best to keep data separate from front end.

Something I do is, I compact and repair my .mde on close. This can not be done when the database is not split and when the front end does not reside on the user's pc.





Sal
  #10 (permalink)  
Old October 13th, 2005, 01:29 PM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok, my original MDB file was lost. I have the MDE file however.

This company claims to have a product that allows MDE files to be edited:

http://www.download3000.com/download_8318.html

Q: I downloaded the demo, and it DOES SOMETHING. What, however is unknown cos all the tables have been removed and the word "Demo" inserted. Does anyone have intimate knowledge that if I send these guys 55 bucks, it will simply not vanish into the air, and will this program actually allow me access to the MDE file?

Thanx,




Similar Threads
Thread Thread Starter Forum Replies Last Post
.Exe file of Access Application prasanta2expert Access 3 July 16th, 2007 07:05 PM
Creating Access (.mdb) file from ASP mfarooqw ASP.NET 2.0 Basics 1 June 5th, 2007 02:39 AM
problem creating .exe from MFC AppWizard(exe) c++ method Visual C++ 0 July 7th, 2006 03:28 AM
problem n creating exe file dawngeorge VBScript 0 December 4th, 2004 03:48 AM
How to creating an exe file ? JAVA J2EE 2 May 20th, 2004 05:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.