create a web database

Hello,


I would like to create a web page that read and write from and to data base. My data base is Access data base.


I would like to use this web database for log-in and for my customers information data.


I was wounding if you have any tools to enable me to easily design my web database.


Thanks


Farzad


Post Edited By Moderator (Joel Thoms) : 7/10/2006 8:44:02 PM GMT

 

Access isn't really suitable as a web database becuase it only allowed a very small number of concurrent connections (I think it might even be only one!). I'd consider using mySQL or SQL server instead.

Luke

 

Here are a couple of good articles to get you started. If you have any specific questions let me know and I'll try to help.


http://kb.discountasp.net/default.aspx?cNode=5A0K7N&pNodes=6E0U3I
Rookie

 

I am also interested in having an Access database the same as you describe. I look at the links given above and found them no help. I am interested in using OLEDB. I would also like to write my own code instead of using the wizards for the oledbconnection, olddbdataadapter, etc. Can anyone offer any more advice?</font>

 

I'll always advise against using access. It might be a good short term solution, but it will cause problems in the long run.



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

I honestly agree with you, but with the few resources, time, and knowledge that I have, Access seems the best way to go. Once I get my application up and going, I can always go back and research a better way to write it using some other backend.</font>