Microsoft Access/Jet

[David Cabernel]

I've set up the database options in TestStand to use Access as the
database system. My Connection String Expression indicates that the
provider is Microsoft Jet OLDB4.0 so I installed from the Microsoft
website.

After I run the sequence the file "TestStand Result.mdb" file is
updated (filedate changes). Yet if I try and open this file in access
I get a "Unrecognized database format" error.

I don't know alot about databases, but I believe that the file should
open in Access shouldn't it?

[Dennis_Knutson]

What exactly did you download from the Microsoft web site. You should have created the database using your version of Access and then created the default tables as explained in the section Example Data Link and Result Table Setup for Microsoft Access of chapter 13 (assuming TestStand 2.0). You might also want to check on your version of Access. If you are using an older version, you might have to use the Jet 3.51. Instead of either Jet, you could also try Microsoft OLE DB Provider for ODBC Drivers.

[Scott_Richardson]

The example MS Access Database that TestStand installs is version 4.0 which is only compatible with Access 2000. You typically receive that error when you open a 4.0 file with an earlier version of Access than Access 2000. You can use the Database Viewer by clicking on the View button on the Data Link tab of the Database Options dialog box. This uses the 4.0 Provider which can read 4.0 files.

Note: You can create a new 3.5 file using Access and use the Database Viewer to create the tables using the appropriate SQL script files. Then your older version of Access will be able to view the file.

Scott Richardson
scott.richardson@ni.com

[David Cabernel]

On Wed, 21 Nov 2001 07:06:27 -0800 (PST), Scott Richardson
wrote:

>The example MS Access Database that TestStand installs is version 4.0
>which is only compatible with Access 2000. You typically receive that
>error when you open a 4.0 file with an earlier version of Access than
>Access 2000. You can use the Database Viewer by clicking on the View
>button on the Data Link tab of the Database Options dialog box. This
>uses the 4.0 Provider which can read 4.0 files.
>
>Note: You can create a new 3.5 file using Access and use the Database
>Viewer to create the tables using the appropriate SQL script files.
>Then your older version of Access will be able to view the file.
>
>Scott Richardson
>scott.richardson@ni.com

I was using Access 97 thank
s.