What is the best wysiwyg SQL solution for a beginner?

Forum|Forum|13 years ago
May 15, 2013
3 replies
2343 views

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

This topic has been closed for replies.

G

ghfsdjygdgAuthor

Participating Frequently

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

B

bregent

Participating Frequently

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.

S

Studio1

Participant

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.