Not Loading from access dbase

[zagzebski]

I had several files QVW's loading from an access database with OLEDB connection.

Simply

Load

field, 1,

fiield 2,

field 3

SQL Select

field, 1,

fiield 2,

field 3

From Products;

When I step through it makes it past the connection string and Set variables on the main page but when it gets to the SQL statement it just sits there forever until I force close the file. Any ideas. It was working before this. I know they did some maintenance on the server - could something have happened?

[Gysbert_Wassenaar]

Try loading only 100 records to check if it loads anything at all:

First 100

Load Field1, Field2, Field3;

SQL Select Field1, Field2, Field3 from Products;

You can also try using the connection wizard to check if you can connect to the database server to make sure you can actually connect.

[rajeshvaswani77]

Hi,

You can run in debug mode and see.

Does it get past the connection string.

thanks,

Rajesh Vaswani

[zagzebski]

Thanks, yes I did run it in debug and it made it past hte connection but then got stuck on the SQL call to the access database.

[zagzebski]

Yeah still doesn't get me anywhere. Thanks for the feedback. I am going to create a brand new file and see if I can get anything to return from one of the tables in the Dbase.

[rajeshvaswani77]

Hi,

Access normally needs Microsoft OLEDB Jet 4.0 Driver.

Hope you are using the correct driver in your connection string.

thanks,

Rajesh Vaswani