Once you've got your store published to your server, you may well find that the path to the database is not correct and the database doesn't have write permissions. Below we've outlined the simple steps to take to right these issues.
The easiest way to do this is by setting up a quick test file and then copying the contents into your db_conn_open.asp file in the vsadmin folder - here's how to do it:
sDSN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<%=server.mappath("vsproducts.mdb")%>;"
The best place for your database is outside the web root. Most hosts provide a special folder for this with the database permissions already set. Using a folder outside the web root will make it difficult for anyone to download your database and gain access to your username and password. Otherwise you must set the permissions on your database folder so that your database cannot be downloaded. More information is available here.
Rename your database from vsproducts.mdb to a name of your choice, (keeping the .mdb extension of course).
Examples would be (though don't use ours) yourstore591.mdb or database2221.mdb
This will make it harder for anyone to find your database if your database folder permissions are set incorrectly.
Once that is done it's possible you will see a message that your database doesn't have write permissions. Your host will be able to change this for you
If you are using Godaddy as your host then you can follow the steps in our pdf document here