Creating an EXE file for Access 2000

[Tashman]

Hi,

I have created an Access 2000 DB with a lot of VBA code in it, how do I (to stop other people ripping of my code) create an Access 2000 .EXE file that I can release to my users.

Cheers
Tashman

[bill brave]

Did you try to create MDE file ?

[Tashman]

Hi Bill, thanks for replying.

Yep, I have created an MDE file, but I want to be able to keep the database table's seperate, so the users (or me) don't have to keep exporting the database data every time I make an enhancement. I'm now looking to create the forms etc as an MDE file as a front end but keep the tables as an MDB file in the background, but im not sure how to do this.

[CCDriver]

The only way i know of is, you will need to buy Microsoft Office Developers Edition or Office Plus, i think?? not sure now about the name, it's been awhile. Contact a Microsoft distributor in your country and they will be able to tell you what the name of the program you will need.

NOTE:
I enquired about this myself some time ago and it was going to cost around $1100AUS to buy, bit pricy, huh? Convert that currency to yours and thats roughly what you will be looking at to fork out.

It can be done but it's very expensive.

[bill brave]

What do you think about ways as follows:

1. Use linked tables : Create 2 MDB. First One contains Tables (role as database) which are located in separate place. Second one contains forms, tables in this MDB are just linked tables. Every time app starts, tables in second MDB will be linked to tables in first MDB.

2. Use VB to create front ends (forms) and MDB as database.

I also would like to hear from you.

[Tashman]

I have found the Database splitter routine in Access and have split the Dbase into a back end with the database tables in it (.MDB file) and a front end (.MDE file) with the forms/VBA code in etc......which hopefully will stop any users borrowing/amending code.

I would have liked to put a VB front end on the system as you suggest but the company im doing this for does not have VB yet (I think a bit of persuasion is in order) so all had to be done this time in Access......

[Tashman]

Yep you could say that, thats a bit out of the project's budget price range, I think ill stick with the MDE approach for now.....

Cheers
Tashman.