Solved

ODBC connection issue for SQL Server 2005 Express

Posted on 2011-09-05
6
415 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Bergan2
  • 3
  • 3
6 Comments
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<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.
0
 

Author Comment

by:Bergan2
Comment Utility
I get the error message on form load.
0
 

Author Comment

by:Bergan2
Comment Utility
I can run the qry underneath the form without problems and it is updatable.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
Comment Utility

 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.
0
 

Author Comment

by:Bergan2
Comment Utility
I found the error, in my VBA code.  Thanks.
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility

 That's great!

Jim.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now