Moving an Access DB

This topic is locked

Moving an Access DB	5/4/2004 5:33:12 PM
ASPRunnerPro General questions
author I can get all the files working when using the local host on XP Pro, but my Internet server has a specific folder for databases...If I upload the files from the local host into the "www" folder of my Internet host, then I can only view the files in the DB and not edit etc. I need to move the DB into the "databases" folder...how do I keep the connection to the db?


	Sergey Kornilov admin 5/4/2004
	Lets imagine you have the following directory structure on your web server: cgi-bin databaseÂ Â Â logs www/asp/db where: database - designated database folder www/asp - folder where ASP files reside Old connection string should look like this: strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("db\db1.mdb") & ";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;" New connection string in this example will be: strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("..\..\database\db1.mdb") & ";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;" If it doesn't help - post actual directory names here and I'll fix it for you.