Asp, Access question

[SethCall]

I was curious, is there a script floating out there that is great for viewing databases (that are in a true relational form) or

is there a convention or method to follow when parsing a query?

I am about to make a web site with alot of queries, but so far, I am treating each query as individual. I was hoping that perhaps there was some sort of "smart" way to parse a query.

Ah well. Thank you in advance!

[txbakers]

I'm not sure what you mean about viewing a true relational database script. You can write scripts to view data from a relational database.

You can combine tables into one query based on relationships between tables. Some databses also support sub-selects, which allow you to create queries within queries.

If your website is going to be used by a lot of people, and you intend on writing data to the database, then you definitely want to get away from Access. Access is primarily a desktop program, not a true client/server application. It can handle maybe 10 simultaneous connections if you are lucky before IIS just stops sending ASP pages.

I migrated to mySQL one long weekend, and never looked back.

[SethCall]

oh well. I am currently using a query and parsing it. I mean I completely understand what you mean by .. what you just said ;)

but no this is a very "in-house" project. 2 people max accessing database, and trust me, if the person wanting this done would let me use mySQL, i would ;)

thank youthough