Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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 -
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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 -
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #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,
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:03 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.