Just an update:

This question has been resolved ... thank you Google ....

If anyone would like to see the solution to this dilemma, you can view the rather...

Michael,

I have built a moderately sized application using SQL Server 2000 and Access 2002 as the front end. I chose Access over VB for two reasons:  I know VB at...

Louise,

I think Kathi was on the right track by using an aggregate query. You do have to keep in mind what...

Shawn,

The following comes from VBA's Help file in the Bookmark Property Topic. I think it partly explains some of your problems:

Requerying a form invalidates any bookmarks set...

Stewart,

Thank you so much for all your help.

Kyle.

Thank you VERY much to all that responded!

After making a few changes in the way the SP is called, the first few tests seem to indicate that everything is working...

Dinakar,

Yes. The SP that doesn't work in Access will run from query analyzer with hard-coded parameters and I have checked the strings that VBA sends to SQL server to ensure...

mattbristow,

I'm not sure from where you are calling "QryFrmSearchCentre", but if it is used as the RecordSource for a form, you might try dropping the "dbo". I've had a similar...

m,

I had a similar problem with my Access app. I re-wrote a stored procedure without setting NoCount ON at the beginning of the SP. This caused the report to open,...

David and athurgar,

Thank you very much for the quick replies. I was thinking MSDE would be the best bet. I hear that SQL Server Express doesn't connect to an Access...

I agree with Mr. Smilevski that 50K records is a lot for a combo box. Could you use another combo box to limit the combo box recordset to something more...

I'm very new to programming in general, especially db stuff. I've used the Microsoft SQL Server 2000 Bible by Paul Nielsen from Wiley Press. It's very thorough. The book covers...

Gerardo,

I don't know the details of what kind of page you need or how to create one, but I think the ASP.NET website might be a good place to start.

At...

Peter,

Thank you very much for your quick reply. Your solution is close I think, but I will need to do some testing on it to see if it can be...