Solved

ODBC connection issue for SQL Server 2005 Express

Posted on 2011-09-05
6
423 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 57
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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 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 57
ID: 36485566

 That's great!

Jim.
0

Featured Post

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!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

696 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