Ways to make an Access Db available to multiple remote users?

meanster99

Meum cerebrum nocet!
Local time
Today, 02:58
Joined
May 2, 2006
Messages
62
Having researched further I am now under the impression that I can actually make my db available THROUGH my website i.e through the users browser (does this eliminate the need for Access to be installed on the users machine?). From what I can gather (and I am not at all clear with these things) there are several options :

Use SQL/mySQL etc etc as the b/e and then do something!?

Use PHP or ASP.NET to put the db onto the site and then do something?

Use DAP and then do something?

Now I am quite prepared to go away and learn more about these various methods (which is clearly needed) but i wanted advice first as time is of the essence and I don't want to do more than i have to YET!

Which is the EASIEST (a relative term I know!) method considering :

1) There will only be around 5-10 users to begin with (not all working simultaneously). This may increase to around 20-30 users within a year or two.
2) I know very little about SQL or scripting in ASP, PHP etc
3) My db holds around 7k records (will be upto 20k within a year), approx 15 tables, 25 Queries, 15 forms, 20 reports, 8 modules and 15 macros (must macros be converted to code before I can make mde files? I know I should convert them all to VB but they were so easy to use when i first started!)
4) Buying legal copies of MS Access (even the runtime version) is not cheap!
5) I could do with having it complete within a week!
6) All home users have broadband (1-2Mb) connections
 
Last edited:

Users who are viewing this thread

Back
Top Bottom