I am using the Wrox book Begining visual interdev 6, on p139 it shows how 

to create a data environment.



The next steps are to create a command, add a record set nav bar to a page 

and then and connect to the DTC.



When you display the page no data is displayed and the DTC do nothing.



The connection string automatically created is:



Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data 

Source=C:\databases\WroxCameras.mdb;Mode=Share Deny None;Extended 

Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet 

OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database 

Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk 

Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System 

Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy 

Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet 

OLEDB:SFP=False



When I click on test connection it is OK.



The book suggests replacing the connections string with:



Provider=Microsoft.Jet.OLE DB.4.0;Data 

Source=C:\databases\WroxCameras.mdb;User ID=Admin;Password=""



but this gives an error the record set is highlighted in red.



Any suggestions as to what I can do to get it to work?



Do I need to check the realse of VID or the DataAccess, how? and update 

them, from where?



Do DTC and nav bars work???



Thanks, 

Jason.