duplicate access design view in asp

[esthera]

I have a db taht I moved the frontend from access to asp. (but backend is still in access)
Is there anyway to duplicate the frontend design view for queries from access?

What do you recommend?

[Ubik]

I have not found a way to do this other than re-coding it all by hand in asp.

But recoding access forms shouldn't be too hard, just a little tedious.

[Bullschmidt]

You can do something like this:

Response.Write strSQL & "<br>"

And then on your page where you see the SQL statement you can copy and paste that into a new Access query's design mode (actually in the SQL view). And of course you'd want to change any instances of % (i.e. the Like wildcard for ASP) to be * instead for inside Access.

[esthera]

no actually i am doing the opposite -- I wrote a program with many search features but my client is used to the design view of sql query in access and it has more flexibility then what i wrote so I was worndering if there was a way to duplicate in asp.

[Bullschmidt]

Well any SQL statement that works in Access should be able to be copied and pasted into your design code for an ASP page too (just change a * to be % and of course deal appropriately with any parameters)...