Search results

Thanks for the replies. I have a big mdb file which is growing and getting slow - the plan is to move to SQl back end/Access front end as a quick interim move before rewriting the whole thing in .NET. So I want to move as many of the queries into SQL now, so that when I port to .NET it's...

THis is probably a simple question, but if I have a pass through query that includes a SELECT statement, how do I see and retrieve a recordset that I can then step through and manipulate? I know recordsets retrieved by pass through queries are read only - how do I display the results, or walk...

I want to migrate from an Access mdb database to Access mdb front end/SQL back end. I want the flexibility of mdb, with local tables etc, so don't want to go to adp. I would like to run stored procedures in my SQL server as well, and I know how to do that using pass through queries, but that...