Discussion Locked

non-Access Access front-end

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Odd question, I know; but I want to deploy an MDB without having to install Access on every machine. Is there an ODBC\Access-compliant manipulatable database front-end or interpreter that's fairly thin, but still robust enough to be flexible for field changes and/or design changes. It should be able to search/query and have input data capabilities.
If there isn't one, and I need to use Access and pretty-it-up a little, let me know how you tried to find another database and you can still get the points.
Thanks,
John

4 replies

by halleyc

If you want to deploy your mdb file on the machine which don't have Full Version of MS Access installed, you can install MS Access run-time on user machine. The run-time version of Access disable all application design functions. To get run-time version of Access, you have to buy Access Developer's Toolkits (For Acess 95/97) or Office 2000 Developer (for Access 2000). If you don't want to buy the kit, ask someone who has the kit to build installation diskette for you.

Procedures to build theinstallation diskette

1.You need to install Microsoft Access Developer's Toolkit on you machine (the machine you used to develop your Access Application) first

2.Use setup wizard to create setup diskette. The setup diskette should contain a run-time version of Access (including msaccess.exe and some dll files) and your mdb and mdw files

3.Run setup.exe locate on the installation diskette you have just built.

After step 3, you can run Access application on the computer without full version of Access inst

by inspectorclave

The Microsoft Office Developers Toolkit comes with a royalty-free version of runtime Access. It is similar in method to the PowerPoint viewer that ships with MS PowerPoint. Here is a site that sells the toolkit:

http://www.cdw.com/shop/products/default.asp?EDC=158726

Another neat feature of the toolkit is that it comes with InstallShield. This allows you to take your databases and add all the files to a "setup.exe" file that, when clicked, automatically creates directories and puts thefiles where you want them. This makes for standardized installations. The price you will find anywhere is about $350. There is also an Developer edition upgrade to the MS Office suite. It goes for around $550.

This discussion is closed to new replies.