ODBC connection issue for SQL Server 2005 Express

Bergan2
Bergan2 used Ask the Experts™
on
I have a Access 2010 frontend connected to a SQL Server 2005 Express backend.  

I was able to use Access 2010 to migrate my tables using ODBC to the SQL Server.

I can open my Access 2010 frontend.  I am able to open tables, run queries, and open some forms and see data.  

However, when I open one form, I get a ODBC failed message.  

This does not make sense to me that it would connect and show me data from all tables but not show me information on this one form.

Please help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<This does not make sense to me that it would connect and show me data from all tables but not show me information on this one form.>>

  There are a number of things that might cause this; type of locking, the recordset is not editable, problem with a specific field type in one of the tables, etc.

  Where/When exactly are you getting the error message?

Jim.

Author

Commented:
I get the error message on form load.

Author

Commented:
I can run the qry underneath the form without problems and it is updatable.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:

 You'll need to drop in some code then on the error handler for the OnLoad event or possibly the forms OnError if this is an error that Access is generating rather then your code:

ACC2000: How to Trap Specific ODBC Error Messages
http://support.microsoft.com/kb/209855

 Subsequent errors in the errors collection should give you an idea what's wrong.

Jim.

Author

Commented:
I found the error, in my VBA code.  Thanks.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:

 That's great!

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial