No data found on Access database

[richardhowell]

I'm pretty new to dreamweaver, so have patience please! I'm creating a set of search/results pages querying a single table on a simple access database. In the results page I define a recordset, and to test it I've kept it simple (no WHERE clause). When I click the TEST button it comes back with No Data, and (predicatably) when I run the query through the search/results pages, again no data is retrieved. But I know that this table is populated with a few rows which I inserted through Access itself.
Before you reply -
YES I have synchronised the site with the remote site. The remote db has the populated table.
YES my connection is fine.
This is driving me round the twist - please help!!!

 

[TonyU]

What's your SQL statement to view the data???

 

[richardhowell]

Nothing awesome!

SELECT job_ttl, location, job_desc, mand_skil
FROM jobdet;

(I'm fairly au fait with SQL btw.)

 

[richardhowell]

Oops! Although my database connection looked good, I was in fact pointing to an earlier version in a different directory. So problem solved when I amended to point to live database.
Sigh!