Compile the database to share with other user on their box Access 2003

  • Thread starter Thread starter cesemj
  • Start date Start date
C

cesemj

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,
 
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 said:
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.
Click to expand...

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
 
[email protected] said:
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?
Click to expand...

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 said:
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
Click to expand...

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".
 
Back
Top