Running a DB without spending £300

Ian Stow

Registered User.
Local time
Today, 08:18
Joined
Aug 5, 2002
Messages
12
I am trying to write an Job/Invoicing system specific to my job (as a Chauffeur) and a couple of associates of mine have expressed an interest in using it themselves . If I give them a copy of it do they have to spend £300 on a copy of access to run it or is there a cheaper way of allowing them to run it.(Apart from the illegal ways)
 
One option is for you to purchase the Developer Edition of Access. This allows you to create packages with a run-time version of Access. I'm not sure on the latest $ for Developer Edition.

You could also write the forms in Visual Basic with an Access DB on the back-end. Reports could then be written in Crystal Reports.
 
Sadly, it would probably be cheaper for them them to purchase one of the acounting packages available. MYOB, Sage etc
 
If your users have Excel, it's possible to create an interface for an access database in Excel (I have seen it done)!

A lot of places won't license Access, but will install Microsoft Office including Excel. The Jet Database engine, and hence the DAO object model are usually included in the MSOffice install, even if they aren't you can download them free as part of MDAC (upto version 2.6, or separately from 2.7 onward) from msdn.microsoft.com

Obviously, it's a bit more work, you will need to create your own methods for retirieving recordsets, reading and writing values to and from controls; improvise, you're own navigation controls etc. I'm not sure whether you could get reports working, you may need to rebuild these in Excel.
 
Also...

If they have MSOffice already they can buy the access upgrade for MSOffice rather than the full software for under £100
 

Users who are viewing this thread

Back
Top Bottom