Solved

ODBC connection issue

Posted on 2011-09-05
14
282 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
  • 6
  • 5
14 Comments
 
LVL 8

Expert Comment

by:ee_reach
ID: 36484962
You will probably get access to more experts in SQL Server by moving this to the SQL Server forum instead of the MySQL forum.  Just a suggestion.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36486134
<Access 2010 to migrate my tables using ODBC to the SQL Server.>
Migrate or "Link"?

In any event run the linked table manager again and try refreshing the links.

<However, when I open one form, I get a ODBC failed message.  >
Or, check the Recordsource for this form and make sure that it is linked in the Linked table manager.

0
 

Author Comment

by:Bergan2
ID: 36486193
Thanks guys, I redid some VBA coding that worked in  Access 2007 but does not work in 2010 and now the connection is working well.

Thanks again.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36486411
If you post the code you "redid" you can accept your own post as the solution.
0
 

Accepted Solution

by:
Bergan2 earned 0 total points
ID: 36493372
I've requested that this question be closed as follows:

Accepted answer: 0 points for Bergan2's comment http:/Q_27292008.html#36486193

for the following reason:

I reworked VBA code.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36493373
http://www.experts-exchange.com/Database/MySQL/Q_27292008.html?cid=238#36486193
...only states that some code was "redid"

If the actual code is posted, then that post would be valuable as a solution.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Bergan2
ID: 36495631
I don't want any points.  
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36496402
...accepting your own post will not give you (as the asker) any points.

My point here was that if you want to "Accept" any post, then that post must contain a valid solution.

You originally wanted to accept (as the solution) your post that only said "I redid some VBA coding ..."
This would have marked that post as the "Solution".
This means that any other member searching here for the same issue would see that and wonder what the actual "Redid" code was that actually fixed the issue.

Again, so why not simply post the actual code and accept your own post...?
If the code is confidential and cannot be posted, then simply request that the Q be closed.

JeffCoachman
0
 

Author Comment

by:Bergan2
ID: 36498611
Thanks for the explanation.  I didn't understand.  

Please close this question.  Thanks.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36498994
Experts cannot close questions, only admins can.
So you must click the "Request Attention" link and ask that the Q be deleted.
0
 

Author Comment

by:Bergan2
ID: 36525335
Thanks for the information.  I do not have access to the code anymore.  I was working on a project via an RDC connection. I have finished the project.  Thank you everyone for your help.  
0
 

Author Closing Comment

by:Bergan2
ID: 36553499
I was able to solve my own problem and I am grading myself.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

920 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

12 Experts available now in Live!

Get 1:1 Help Now