Solved

ODBC connection issue for SQL Server 2005 Express

Posted on 2011-09-05
6
418 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
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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

816 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