Any suggestions on how to make my access DB like an exe file to let
people run it on their stand alone. My access db updates the it
tables over the internet via obdc pass thru query. I have read my
access 2003 book and it said I need to order Visual Studio For Office.
Is this the only way to release my application or is their another way?

hi,

you can create an "mde" file. Also in the Startup section slect a form that
is launched when the application starts. You can then distribute the mde file.

If your database contains Microsoft Visual Basic for Applications (VBA)
code, saving your Microsoft Access database as an MDE file compiles all
modules, removes all editable source code, and compacts the destination
database. Your Visual Basic code will continue to run, but it cannot be
viewed or edited. Your database will continue to function as it did — you can
still update data and run reports.

Regards,

----------------------------------
Haris
http://www.Designing-Systems.com
------------------------------------------


"(E-Mail Removed)" wrote:

> Any suggestions on how to make my access DB like an exe file to let
> people run it on their stand alone. My access db updates the it
> tables over the internet via obdc pass thru query. I have read my
> access 2003 book and it said I need to order Visual Studio For Office.
> Is this the only way to release my application or is their another way?
>
>

The user needs a copy of the Access program on their machine or you need
to provide the runtime version that is available as part of the Visual
Studio as I recall. Sorry no cheep way out.

--
Joseph Meehan

Dia duit
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Any suggestions on how to make my access DB like an exe file to let
> people run it on their stand alone. My access db updates the it
> tables over the internet via obdc pass thru query. I have read my
> access 2003 book and it said I need to order Visual Studio For Office.
> Is this the only way to release my application or is their another way?
>

"Joseph Meehan" <(E-Mail Removed)> wrote:

> The user needs a copy of the Access program on their machine or you need
>to provide the runtime version that is available as part of the Visual
>Studio as I recall.

Actually it has a confusing name, VSTO or Visual Studio Tools for
Office. Which is not at all the same thing as Visual Studio.

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

"(E-Mail Removed)" <(E-Mail Removed)> wrote:

>Any suggestions on how to make my access DB like an exe file to let
>people run it on their stand alone. My access db updates the it
>tables over the internet via obdc pass thru query. I have read my
>access 2003 book and it said I need to order Visual Studio For Office.
>Is this the only way to release my application or is their another way?

Yes, this is the only way to run an Access app stand alone.

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

Tony Toews wrote:
> "Joseph Meehan" <(E-Mail Removed)> wrote:
>
> > The user needs a copy of the Access program on their machine or
> > you need to provide the runtime version that is available as part
> > of the Visual Studio as I recall.
>
> Actually it has a confusing name, VSTO or Visual Studio Tools for
> Office. Which is not at all the same thing as Visual Studio.
>
> Tony

They confused things way back when they put the word "Office" in the name. The
developer's tools have never had anything to do with Office except for Access.
They should never have deviated from "Access Developer's Edition".

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com