Hi

I know there is a wizard for upsizing from an Access database to the SQL
Server, but the server only allows tables, but queries. Where do you
store the queries? Does each query have to be written in SQL into the VB
front end or is there a better place to put them as stored queries -
perhaps in a middle tier between the front and back end?

Thanks

Hi Michael.

You should convert your queries to SQL Server stored procedures. This will
have to be a manual process, but you shouldn't have to modify you existing
queries very much.

HTH

and remember...

"When the going get tough, the weird turn pro."
        - R. Duke

I have not used the wizard but can tell you that the equivalent of MS Access
queries in SQL Server are called stored procedures and they are stored on
the server. Usually you create the procedure in a text editor and save the
text file then bring this into sequel server by loading it into the query
window and running it.

You can have the business logic in the front end or on the server as stored
procedures. SQL embeded in VB is not as efficient as stored procedures
stored on the server. This is because they are already compilied on the
server if stored procedures are used, and there is less network traffic.