Stand alone applications

[David Cleland]

Hi

is it possible to make stand alone application from an access db ? I have a
database created and would love to create a small exe version that would
work on any pc ?

David

 

[Wayne Morgan]

There is an Access runtime. It doesn't create a small exe. Essentially, it
installs a version of Access that can't be used to edit the file. Once you
purchase the runtime, it is available to you for distribution with your
file. In Access XP and older, you had to buy the Developer edition of
Office. For Access 2003, you have to buy the "Access Developer Extensions".

http://office.microsoft.com/en-us/assistance/HA011208861033.aspx

 

[David Cleland]

Great

so if I buy that I can use my application on any number of computers with
out the acccess license ?

That would save me quite a lot - unless the runtime is a killer ?

David

 

[David Cleland]

I read there that macros are a problem - I use a few in my database - is
there any way around this ?

david

 

[Wayne Morgan]

I haven't used the runtime, but there are plenty of folks on this group that
have. There is an option under Tools|Macro that will convert macros to VBA,
if that will help.

 

[David Cleland]

I haven't used the runtime, but there are plenty of folks on this group
that have. There is an option under Tools|Macro that will convert macros to
VBA,

is there anyone willing to convert a db for me to see what it looks like ?

are there educational licenses for it ?

David

 

[Albert D. Kallal]

I read there that macros are a problem - I use a few in my database - is
there any way around this ?

Macros work just fine.

The part that you have to pay attention to most is that you need to build
your own interface. You should supply some menu bars. If your current design
does not (or did not) use custom menus, then you can create a simple menu
bar with File->exit on it.

Usually, by the time a developer gets around to using the runtime to deploy
an application, then the ms-access interface and menus was long ago hidden.

There are some "basic" menus that do appear, but as a rule, you want to
build and setup your own proper interface before you ever get around to
using the runtime...

You can build a short cut that will launch your mde file now, and it will
give you an idea of how it will look/work in the runtime.

Use:

"C:\Program Files\Office2003\OFFICE11\MSACCESS.EXE"
"C:\Program Files\BookingSoftware\booking.mde" /runtime

 

[Albert D. Kallal]

is there anyone willing to convert a db for me to see what it looks like ?

See my other post...you can try using the runtime switch...

 

[David Cleland]

When you say interface,

I have a switchboard driven system - is that enough ?

David

 

[Tony Toews]

There is an Access runtime. It doesn't create a small exe. Essentially, it
installs a version of Access that can't be used to edit the file. Once you
purchase the runtime, it is available to you for distribution with your
file. In Access XP and older, you had to buy the Developer edition of
Office. For Access 2003, you have to buy the "Access Developer Extensions".

http://office.microsoft.com/en-us/assistance/HA011208861033.aspx

Also see Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[David Cleland]

Getting there

I bought the tools package, arrived today but have met a wall.

It keeps asking me to cache the language it asks me for the office 2003 cd
which I give it and I choose the setup file but it says no write permissions
and stops.

it now keeps repeating the same question. It seems to need the access.msi
file but I only have office 2003 ?

David

 

[Tony Toews]

I bought the tools package, arrived today but have met a wall.

It keeps asking me to cache the language it asks me for the office 2003 cd
which I give it and I choose the setup file but it says no write permissions
and stops.

Have you searched on exactly that message at support.microsoft.com or
groups.google.com?

It seems to need the access.msi file but I only have office 2003 ?

Do you have Office 2003 or Office 2003 Professional? I would assume
you have the Pro version as you previously indicated you had created
an MDB.

Tony


--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[David Cleland]

Yes Office 2003 Pro,

I managed to get it to work by installing a different language - Swedish -
weird.

David