MS Access Database

Hi,

I am using MS Access 2003 database for 1 of my website.
If I want to host this site then do I need to purchase MS Access database for hosting purpose ? or Can I just use it by putting the same into App_data folder and publish and upload that on my ftp. ?

What will be my connectionString in both cases..?
Pl note that, I am using we.config for connectionstring value
Pl help me.

Jesha

 

Hi,
Which dev tool are you using to code this? Visual Studio?
Reason I ask is there are nice Access DB features in newer versions of VS and Visual Web Developer.
You do not need to purchase Access.
You can write code to alter the existing DB, plenty of examples on-line for that.
As for having the conn string in your web.config for an Access DB I always suggest against that. It is much more reliable in Access to code your pages for it.
You can find examples here: http://www.connectionstrings.com/

And as for using the App_Data folder, yes either that one or your DASP _database folder.
All the best,
Mark

 

Check the thread call Acess 2007 database.
There is some sample code of how i got it working

http://community.discountasp.net/showthread.php?t=11070