Stand-Alone Program

[RedMatrix]

Hello. I have tried using the search function on the board but I cannot find an answer.

Is it possible to create an executable program to run the database?

I would like to have a computer that does not have Access installed, to be able to load and run the user interface that allows them to manipulate the database, as well as write to it. It doesn't matter if the tables are encrypted or not.

Thanks for your time.

EDIT: It appears that after writing this post, I realized I hadn't used the search term "executable." I found an answer here.

 

[dxp]

For this standalone version you need MS Access developer extensions to produce a runtime version (.exe) otherwise you are limited to users with Access installed on there pc so they can run the mdb or mde file.

 

[boblarson]

For this standalone version you need MS Access developer extensions to produce a runtime version (.exe)

That is actually not completely accurate, you can NEVER produce an exe file in Access. The exe you are using is just the Access Runtime, which is a limited version of Access that can run on anyone's machine without requiring an Access license.

As mentioned in the link, to produce an actual exe file requires a programming language like VB6, VB.NET, C++, C#, etc. You can use an mdb file as the backend for one of those but as a "semantics" thing: You can NEVER turn an Access program itself into an exe.

 

[dxp]

I stand corrected Boblarson, however I know what he wants and I know what I meant in my reply. I have the same problem !!

 

[RedMatrix]

Thanks a lot for your help, dxp. So basically, you described a "reader" version of access. That's definitely an option.

Bob, I also understand what you say. It wouldn't be that much different to using .DLL files then, if an .EXE had to reference an .MDB!

 

[dxp]

No probs, just dipping my toe. I would allways defere to to Bob, he and many here have probably forgotten more than I will ever know..!

looks like I am going to have to invest in the developer extensions if I am to progress my humble effort any further, I would however have prefered to to invest in a 'hired gun' if for nothing else than to show my appreciation for the help I have recieved here.

 

[RedMatrix]

I completely understand. However, I am in no rush, so I will take the time to learn things the right way. Heavens forbid I make a design flaw!

 

[swanny]

access 2007

Hi

I am currently designing (slowly) a db in access 2007 and am new to access and general databases!

i need to run the live program on a single machine for testing for now and was wondering what method would be the best to do this?

Once completed will be shared via network drive...

Please go easy on the techincal terms

Thanks