Welcome to WebmasterWorld Guest from

Forum Moderators: phranque

Message Too Old, No Replies

DreamweaverMX to SQLServer

upgrade DreamweaverMX to SQL

1:45 pm on Jan 13, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 23, 2002
votes: 0

Hi All,

I have been a user of DreamweaverMx since it was first available here in the UK. I was formally trained in raw coding but I use MX a lot for its ease of use and twek code as and when needed.

I use it to create ASP/Access sites, have done a number of projects with it now.

To increase my future employment options I was curious to know how easy it is to convert form Access to SQL and can it be done on the MX platform?

In short I want to beef up my server skills as it seems there is still a good demand for web developers.

Any online guides to learning SQL Server?

4:48 pm on Jan 13, 2003 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
votes: 0

You can connect to SQL Server just as easily as you can to Access with Dreamweaver. With SQL Server, you won't even need ODBC.

There are many tutorials and scripts available to convert Access to Sql Server, considering they are both MS products.

I ran a quick search on "SQL Server tutorial" and came up with quite a few. If you have version 7 (the previous version) you can buy books very, very inexpensively.

It's much better to get away from Access if you are writing ASP pages. Access is really designed as a desktop/small network DB and can't handle the demands of a web deployment.