dbTalk Databases Forums  

Access Database on Website?

comp.database.ms-access comp.database.ms-access


Discuss Access Database on Website? in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
HB2
 
Posts: n/a

Default Access Database on Website? - 02-28-2004 , 05:11 PM






Is it possible to store a MDB file in my website and have an access page on
my website that writes to the MDB file?



Reply With Quote
  #2  
Old   
John Shaw
 
Posts: n/a

Default Re: Access Database on Website? - 02-29-2004 , 12:45 PM






I think you can put Access on a web site, but the only way users can
directly interact with it is to download the entire database. You can
use ASP or Cold Fusion as the interface between the web user and
Access. But Access is single-threaded. Two users could access it at
the same time and cause problems.

John




"HB2" <bgreer24 (AT) comcast (DOT) net> wrote

Quote:
Is it possible to store a MDB file in my website and have an access page on
my website that writes to the MDB file?

Reply With Quote
  #3  
Old   
Ira Solomon
 
Posts: n/a

Default Re: Access Database on Website? - 02-29-2004 , 03:23 PM



You have to use ASP or JSP or other methods that allow a web page to
talk to a db.
Access can be used by multiple users at the same time.
Just looking or running queries You could do about 15-20 users before
things got really slow. For updating 10-15.

Many website hosting servcies do not allow ASP. Those that do also
have SQLServer, so you could just upsize your tables to SQLServer and
avoid the user limitation. The code would be 99% the same. Note that
ASP requires the ADO model. DAO won't work.

Although expensive Macromedia's Dreamweaver allows for construction of
websites that interact with databases and it will do a lot of the
basic work for you.

If you don't have an ISP that will handle ASP, try www.mavweb.net.
I use them and they are quite reliable.

Good luck
Ira Solomon

On Sat, 28 Feb 2004 23:11:28 GMT, "HB2" <bgreer24 (AT) comcast (DOT) net> wrote:

Quote:
Is it possible to store a MDB file in my website and have an access page on
my website that writes to the MDB file?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.