?
Solved

ODBC connection issue for SQL Server 2005 Express

Posted on 2011-09-05
6
Medium Priority
?
426 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 58
ID: 36485185
<<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
ID: 36485212
I get the error message on form load.
0
 

Author Comment

by:Bergan2
ID: 36485260
I can run the qry underneath the form without problems and it is updatable.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 36485311

 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
ID: 36485407
I found the error, in my VBA code.  Thanks.
0
 
LVL 58
ID: 36485566

 That's great!

Jim.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

771 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