Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

ODBC connection issue

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
Bergan2
Asked:
Bergan2
  • 6
  • 5
1 Solution
 
ee_reachCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
<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
 
Bergan2Author Commented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jeffrey CoachmanMIS LiasonCommented:
If you post the code you "redid" you can accept your own post as the solution.
0
 
Bergan2Author Commented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Bergan2Author Commented:
I don't want any points.  
0
 
Jeffrey CoachmanMIS LiasonCommented:
...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
 
Bergan2Author Commented:
Thanks for the explanation.  I didn't understand.  

Please close this question.  Thanks.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Experts cannot close questions, only admins can.
So you must click the "Request Attention" link and ask that the Q be deleted.
0
 
Bergan2Author Commented:
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
 
Bergan2Author Commented:
I was able to solve my own problem and I am grading myself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now