General discussion

Locked

Stand-alone DBs

By M.R.Chambers ·
How do you make stand-alone DBs?
I have heard that you need to have MS Access Developers' Edition to legally make stand-alone Access DBs. Is this true?

If so, any idea how much it costs (just Access, not all of Office) in Australia, and where to get it?

Thanks,
M.R.Chambers

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Stand-alone DBs

by dave34243 In reply to Stand-alone DBs

I'm assuming you are talking about writing an Access apllication that you can distribute as an .exe file that does NOT require the user to have MS Access to use it. There are two products that would fit the bill: Office Developer Edition (http://www.provantage.com/fp_34353.HTM) for $856 from ProVantage (I don't think you can buy just Access 2000 Developer) or the Access 7.0 Development Kit (http://www.provantage.com/FP_09179.htm) for $418. Office Developer is, obviously, stand-alone, but theAccess Delopment Kit requires a licensed version of Access '97.
Either one can be had from ProVantage for (probably) the best prices on the web.

Hope this helps.

Collapse -

Stand-alone DBs

by M.R.Chambers In reply to Stand-alone DBs
Collapse -

Stand-alone DBs

by fofa In reply to Stand-alone DBs

It is cheaper to buy VisualBasic (Pro edition) and create an application that way.

Collapse -

Stand-alone DBs

by M.R.Chambers In reply to Stand-alone DBs
Collapse -

Stand-alone DBs

by mightyduk In reply to Stand-alone DBs

A simple solution (if you don't have a complex table structure) is to use flat file databases. Advantage: completely cross platform, simple to setup, performance is good for small db's. Disadvantage: query's have to be created rather than using SQL (although there are modules/libraries available in many languages that accomplish this).

Collapse -

Stand-alone DBs

by M.R.Chambers In reply to Stand-alone DBs
Collapse -

Stand-alone DBs

by daniel.graham In reply to Stand-alone DBs

I purchased Microsoft Office 2000 Developers edition in the US for about $600. I recommend going to the Microsoft site to check prices, first.
The stand-alone Access database that you create with this is not, however, an .exe file. Your Access database will still be a .mdb or .mde file that you can distribute to anyone even if you don't have Developer's edition. The Developer's edition provides a licence to distribute the Access Run-Time (ART) along with your .mde's or .mdb's. The ART is the MSACCESS.EXE file combined with support .DLL and other files, that allows you to manipulate your .mdb and .mde data files. I hope this was clear.

DG

Collapse -

Stand-alone DBs

by M.R.Chambers In reply to Stand-alone DBs
Collapse -

Stand-alone DBs

by mickfranzen In reply to Stand-alone DBs

Hi
Firstly to make stand alone DB you just need Access Developer edition. There is a directorey called AccessRT which you can copy royalty free and set up on as many pc as you like. Its aprox 140MB (this include w95 and NT version) so you need a CD to write it on. It basicly sets up all your DLLs etc. You compile you MDB into a MDE App
which compiles all the code.

In Australia talk to
www.ht.com.au Harris tech
or estore www.estore.com.au

I got MS Office Developer edition which includes word and excel etc approx $1400AUS
at estore.

Collapse -

Stand-alone DBs

by M.R.Chambers In reply to Stand-alone DBs
Back to Web Development Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums