Making an .accde file or similar

[beeky]

I hope this is the right forum but please advise if not. I am using Microsofts new 2010 beta version of Access. I want to distribute a very simple database that records time spent ona job and calculates the invoice and prints an invoice report. I want to make an executable file of my database so that people without MS Access can use the database. This is not a commercial thing. However, when I try the share option and choose the make accde file or similar file access says it can't create it - help says usually because of the number of table IDs. This is really a very simple and small database with only 5 small tables. Can anyone help or tell me how I can get round this problem please?

 

[gemma-the-husky]

try compiling it

open a module, then debug/compile

-------
if there are any errors, you wont be able to create an mde/accde - this is the most likely cause.

 

[beeky]

Sorry but how do I compile it in Access.

 

[SOS]

Sorry but how do I compile it in Access.

You go to the VBA window, go to DEBUG on the menu and select COMPILE <your application name here>.

And then you have to do that and fix every error it highlights and once you have fixed one, do it again until it doesn't generate an error.

Also, I would NOT be distributing an Access 2010 BETA app. Most of the time, apps developed with the BETA software will NOT be able to be used in the commercial release. At least that has been the case in many instances.

 

[DJkarl]

I want to make an executable file of my database so that people without MS Access can use the database.

This cannot be done in Access alone, an Access database will always require some version of Access in order to run it, this could be a full blown Access install or just the runtime version.

If you want to package a stand alone app look at one of the visual studio express options (free to download), use access as your backend database and create your own EXE front end.

 

[SOS]

This cannot be done in Access alone, an Access database will always require some version of Access in order to run it, this could be a full blown Access install or just the runtime version.

If you want to package a stand alone app look at one of the visual studio express options (free to download), use access as your backend database and create your own EXE front end.

Oops, I missed that part of the question. Thanks for catching that one.

 

[beeky]

Thank you for your inputs. I think I will have to do as you suggest and use one the the VB express editions. I was hoping I could get around the problem of distributing but obviously I can't.

 

[beeky]

Thank you. It looks like it is going to have to be VB Express which I was hoping to avoid.