469,898 Members | 1,741 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Problem with upgrading Access 2000 to 2007

Hi All,

I am trying to upgrade an Access 2000 DB to 2007 (using linked tables and ODBC to connect to backend SQL 2000 database). In my DB, I have a mainswitch board and some command buttons on it. When I click the command button it should open another form to show some records.

My problem is that some of the buttons work fine but some others just stuck there and then poping out an error message asking me to manually choose SQL server and user name/password. What I don't understand is that although I have changed the ODBC data source, why it still goes to my old SQL server and why some of the forms open Ok and other havng this problem?

Any help will be appreciated.
Dec 22 '09 #1
2 1821
14,534 Expert Mod 8TB
That would depend on the data RecordSource of the forms in question. Can you take one of the forms as an example. Post the record source of that form and any code that is triggered in the load or open event of the form. Also post detailed information on the error you are getting when the form tries to open.
Dec 23 '09 #2
32,231 Expert Mod 16PB
We have no details from you related to the differences between the working forms and those that don't. In the circumstances we would be unlikely to be able to tell you what is causing the disparity between them.

If you can provide some of the related information about these items we can see what we can do.

ODBC data links to SQL 2000 come in two main security flavours :
  1. Windows Authentication.
  2. UserName / Password Authentication.
  3. There is a third - Application Authentication, but we won't go there. Very few developers do anyway it seems.
Which of these two are you using?
Dec 23 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Aidan Tobin | last post: by
15 posts views Thread by =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post: by
14 posts views Thread by Wayne | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.