What is the best wysiwyg SQL solution for a beginner?

[ghfsdjygdg]

Hi there,

I want to go from Access to SQL due to the fact that SQL can handle more users, posts etc..

Only problem is I'm quite used to the Access interface and seeing/reading directly off the tables,

something I understand is not that easy when it comes to SQL. So in order to get started I need

to start off with a program that is easy and understandable for a beginner.

Is there a WYSIWYG program out there that can make this transaction to SQL easier?

And final question, what type of SQL is best suited for windows/ traditional asp pages?

Regards,

Christian

DWCS5.5 | Access | Asp

[Studio1]

I have used Access in the past to connect to a MySQL database via MyODBC when I first started dabbling in ASP.  There is a fairly comprehensive installation and setup guide here.

Regards,

Dave

[bregent]

SQL stands for Structured Query Language and has nothing to do with a specific DBMS as MS Access also supports SQL as well. If you are looking to move away from Access, then any of the major DBMS will work - Sybase, Oracle, MS SQL Server, MySQL, etc - with ASP.

As Pegaprint points out. MS Access can be used as a front end to any ODBC database. I work with large enterprise databases and have many front end tools available, but still use MS Access often to design queries because it's simple and works great. In any event, your first task is probably to get a good understanding of SQL as that will be crucial.

[ghfsdjygdg]

I didn't know that Access could be used to handle an SQL Db like MySQL and so on, so that reply really made my day!

Thanks to both of of you for good answers

Regards,

Christian