Access back end

solotoo

Registered User.
Local time
Today, 01:05
Joined
Nov 16, 2004
Messages
14
Hi,

My query is similar to this one here.

I am part of a small intranet team who build internal applications, mostly in Excel using VBA.
However Excel isnt always the answer and we would like to use Access more, however our employer wont pay for the number of Access licences required!!
We have been advised that we could use an Access back end (with all queries) and have a web or ExcelVBA based front end!? As this would be more efficient than a shared Excel/XML database.
Could someone point me to any information about how this could be done??

Thankyou.
 
you could develop it in access then just use the runtime files so you can use the application on another pc.
 
If you have any volume of traffic, I would suggest that you not rely on Access. Take a look at SQL Server. Since your boss is a tight-wad, you probably should start with SQL Server Express. It will make him happy since it is free. ;-B
 
M8KWR said:
you could develop it in access then just use the runtime files so you can use the application on another pc.
You must purchase the "Developers" edition of Access to legally distribute the Runtime version of Access. The Developers edition of Access also gives you the right to "freely" distribute the Runtime version of Access.
 
Thanks everyone

However,
as they are unwilling to spend, we wont be getting Developer "oooh, far too much money!!" and unfortunately we are not allowed to use any free software (!).
The only official software we are allowed to use is what we already have.
Access/Word/Excel/Powerpoint 2000
Homesite/Dreamweaver 4.53
and any XML/VBA we can cobble together!!!!

DONT WORK IN THE PUBLIC SECTOR :mad:
 

Users who are viewing this thread

Back
Top Bottom