?
Solved

Need a stand-alone access 2000 database

Posted on 2002-05-21
4
Medium Priority
?
407 Views
Last Modified: 2008-03-04
I have created a small access 2000 database.  I heard that there is a way to pack the database into an executable so that it will run on systems without office 2000 installed.  Is there such a utility?
0
Comment
Question by:astronot79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
Paurths earned 400 total points
ID: 7025440
hi astronot79

no, u can not create an exe from a mdb...

what u can do is use the Office Developer Edition, and create a package & deploy.
This way a runtime version of MS Access will be installed on the pc where u install, so that pc does not need Access installed to open your db.

hope this helps u in some way.

cheers
Ricky
0
 
LVL 3

Author Comment

by:astronot79
ID: 7025453
I am aware of the 'Package and Deployment Wizard'.  I need to know if there is a way to accomplish this (maybe 3rd party?) without office developer.  Thanks!
0
 
LVL 12

Expert Comment

by:Paurths
ID: 7025463
no, (at least not that ever heard of, or found)

the package & deploy will provide a runtime-version so the ms access mdb can be opened.

if u write your app in for example, Visual Basic, u can create an EXE and access the database via e.g. ADO.

Ricky
0
 
LVL 3

Author Comment

by:astronot79
ID: 7047372
Thanks for all of your help.. I could not use the package and deployment wizard, because it installs the mdb on the local machine and I need it centrally located on the network.  I have implented the runtime install, our technicians will simply install the runtime, then open the database..  
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question