ODBC Version Compatibility

[dzdncnfsd]

I created an Access97 database and linked it to a SQL7.0 database. I am using the latest SQL ODBC drivers on my workstations (3.70.06.90), but have different versions of Access drivers installed. I can run reports, open tables, etc from the Access DB on both of my workstations, however, when I try to use it on a workstation with an older SQL driver, I get an error message. If I double click on a query, it says it can't find it, or if I try to run a report, it says there was an error executing the command. (The user has to supply a begin date and an end date as the first step in running the report.) Everyone has a DSN with the same name pointing to the SQL database regardless of driver version.
1. Is the problem caused by the SQL ODBC driver version?
2. How can I make the DB usable by those with older drivers?
Thanks in advance for advice.
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[jagilman]

I have been doing the same type of work. One thing you should take a look at is the references on the machine that fails. A similar message will come up if there is a missing reference.

John Gilman

John A. Gilman
gms@uslink.net

 

[dzdncnfsd]

By reference do you mean the DSN that links the SQL table to the Access database?
Thanks.

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[jagilman]

No, you need to open up a code window and click on Tools, then click on References and look for a line near the top that says 'Missing'

Then look down thru the Available references and find your missing item. (if there is one missing!)

John

John A. Gilman
gms@uslink.net

 

[dzdncnfsd]

Wow! I had no idea to even check that.
It turns out in this case that the DSN on one of the workstations I tested from was set to Named Pipes instead of TCP, but I would like to learn more about references. Are there some that you always have checked, like ActiveEx type library, etc or are they automatically selected when you refer to them in the code?
Thanks again.
Gladys



Gladys Clemmer
gladys.clemmer@fifsg.com

 

[jagilman]

If you start to write code to make your forms more interactive you will start to use more of what access has to offer. Each of the librarys listed provides access with new tools and capabilities. To get an idea what this looks like just locate the Object Browser button on the toolbar in the code window and you will get a look at the Librarys, classes, methods and properties.

If you don't have a book for programming in Acccess I would urge you to get one.

John

John A. Gilman
gms@uslink.net