I am wary of moving away from having Daylight Savings Time.  With no DST here in Minnesota the sun would be rising at 4 am in the summer and setting...

Is the MS Access front end an mdb file? If so have you ever tried using ADO? I know it is "old" and deprecated with newer versions of...

Wait until you teach her how to drive! The ability of a good dad is the ability to adapt to your child's strengths and weaknesses. My first two...

I have developed with Access 2003 using both ODBC and ADO to connect to SQL Server 2000 and 2005. What I like about ADO is that you can have...

Have you tested the ODBC setup? During the Create New or Editing of a connection you can run a test of the connection. I think when I set...

Ahmed is right. It is a connection issue. Last year I was hooking up an Access 2003 to a SQL Server 2000 database. I found that when...

Scott,

Update Batch appears to do the trick!

I also compared the table's properties with another table that I...

Kevin,

As a SQL Sever newbie I think I understand what you are saying. If I wanted to use a stored proc I would have to pass up the data...

fOK is a boolean variable on the form and it equals the boolean outcome of the Public Function OpenConnection(). cnnlocal is the ADO Connection object. It is declared...

I removed the rstADO.Requery and ran the procedure. Same outcome where the code runs fine but nothing is posted to the table.

Thanks for the idea.