Search results for query: *

I've tried to find this info via Google and Tech-tips searches to no avail. I've got a multi-client SQL Server 2000 database. I've got a client identifier (partial or full primary key to some tables, column value in all) and I've got RI set up through the DB. I want to pull out ONE client...

I have an Access MDB (data only) running under an ASP application (old fashioned ASP - VBscript; Jscript). My MDB is about 25MB, and response time is fine at this time. Specs say it can get to 2GB. We will migrate to SQL Server, but want to put that off to a prudent point (ie as long as...

Do you know of any good texts on SQL Server and standard ASP coding? We are currently using ASP against Access 2000 database and we need to migrate to SQL Server. I've been learning SQL Server 2000 and now need to move to programming against it but I do not have a good text, with good examples...

Flavioooo, I did not see another way to send you a question... I am considering converting an Access 2000 DB to a SQL Server 2000 DB. How did the size of your DB compare? What size was it in Access and what size did the same thing end up in SQL Server? Can you give me a sense of this...

I was unable to get a report to 'use' the current Filter active on a form. I ended up creating a query within which I placed a parameter which the query prompts the user for each time it is run and basing the report on that query. This still requires the user to enter the same data twice...

I need to do something very simple (or so it seems to me). I have a form with a matching report. On my form I have a button to print the report. I only want the report to print the data on my form as I restrict it with a FILTER (while on the form). I always set the filter such that only ONE...

Thanks to mmaz. I'll look into it.

As I understand your actual need is:"I am attempting to use this disconnected recordset in client side script so that when a department is chosen from a drop down menu another menu will then display all employees from a database whose area match the area chosen. " I think a solution...

We're using ODBC connections. We open a connection in virtually every page and close it in the same page. This has worked fine in development under Win 98. We are using server side VBscript. We just moved to Win 2000 and although we close the first connection it is consistently blowing off...

I'm new to this forum.... may I expand on the original question? I'm looking for a report writer that will work with both Access and SQL Server (current and future versions) that can be used to set up a report with parameters (like dept. number) which the user of the web page supplies and then...