Just a couple of thoughts...

1.) What protocols have you enabled in SQL Server?

2.) What network connection types are you allowing in SQL Server?

I have my SQL Server 2005 DE instance...

I wish I could draw that line for you, as I have zero knowledge or experience on the performance of .NET, but I do know when to call it quits...

Oh, I just realized you were concerned about having loaded the entire table into the recordset. If the table is large enough to cause that to be a...

vbguy,

I've been using the same code as in my sample code as my method of operation with Access for at least the last 5 to 6 years, and it works...

Jeff,

I hope you're not lumping me in with the "some answers that aren't quite right" group... at least I was the post with the REPLACE idea for the...

I don't know for sure, but can't you just add a decimal point prior to every occurrence of an operator? Seems to me that a nested replace ought...

The difference between an Access table and a linked table to SQL Server is almost no difference when it comes to writing ADO code. Here's some sample code...

Thomas,

Thanks for the feedback. Glad you have it working, and more importantly, that you now have a good idea of how it works, which can lead to being...

Ok, perhaps... Although I have to point out that you having available to you a "proprietary" technique (my assumption where "contractually not allowed to discuss" is concerned), that...

I think we're definitely talking different expectations. Every Access app I ever had to create required the utmost level of control, lest the user accidentally navigate away,...

Matt & Steveb,

Which version of Access are you referring to? If there's an easy way to control what Access does with bound controls in Office 2003, I'd...

The key here is to NOT let Access do ANY of the work. Set up your textboxes as UNBOUND controls, ALWAYS. The only controls that should...

Stuart,

Been there, done that. I understand completely.

Steve

(aka smunson)

:):):)

I've always found that the forms provided by Access are largely useless for anything other than browsing data, as they give you no control over what happens. ...

I'm wondering why, with SQL 2005 available, you're still using a solution that involves linking spreadsheets together. Generally, if you need to link spreadsheets, then you probably...