Problem with upgrading Access 2000 to 2007

[Jiwei06xie]

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.

[MMcCarthy]

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.

[NeoPa]

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?