Maybe a dumb question but...

... how hard is it to switch form access to msSQL?

[Gert_Jan]

If you build a site in asp with an access database how hard is it to switch to an msSQL database? Do i only need to change the connection string or is it more than that? Next to making sure that the datasebase has the same layour ofcourse...

Thanks

[bateman_ap]

When i changed it was very very easy. Store your connection string in an include file so its easy to change.

Access has an upscaling wizard that makes the MSSQL database for you and i think the only bit of code i had to change was a slight change on a SELECT statement using a date, can't remember exactly off the top of my head but % became & around the date or something like that.

Took less than a few hours on a pretty large site.

[Gert_Jan]

Thanks!