Creating my Databases

[dredger]

I notice that Helm offers me the Option to create a database and says there are none set up for my domain.
However I have created a passworded access DB at work (much better tools available there) and have copied it into my DB subdirectory.

Simply
A) will it work there?

B) should by connection string be
"Provider=Microsoft.Jet.OLEDB.4.0;data source=d:\\domains\\ourladyoflourdesschool.co.uk\\ db\\olol. mdb; Jet OLEDBatabase Password=PASSWORD" ??
The extra slashes are there as it's stored in a Web Config file for .Net

c) If my site is up and running and I need to overwrite the DB with a newer version, Do I have to stop the website ?? (I have to stop the ASPNET WP on my work box )

[Jacob]

In answer to your questions:

1. Yes
2. Looks ok to me, you are using the right absolute path
3. No, but when upload the new db, your site will not be able to access the db, so an error message will occur. A way to get round this is to upload the database under a different name then rename the db's once uploaded.

Hope that helps, any further questions, just post back.

Regards,

Jacob

[dredger]

cheers!
now to get my .Net app working........

[dotnetmachine]

A good idea when uploading is to implement a maintenance mode based upon a key in the web.config. You flick the site to maintenance mode and every visitor gets a nice page (that doesn't access the DB) telling them to come back in five minutes.

There is an example on how to do this in the Code Snippets area of the forums.