View Single Post
  #7 (permalink)  
Old November 30th, 2008, 01:00 AM
Bob Bedell Bob Bedell is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

My apologies for pretty much missing the boat on this one. I didn't realize until after my second post that you were probably talking about the Table Adapter Query Configuration Wizard. Haven't used it since last December, and that was against a Sql Server database. Never tried using a typed dataset against Access, so generally speaking, I can't be of any help here (though you got me curious and I'll probably have to play with it tomorrow).

tool->options->Table/Queries refers to the main menu in Access. I focus all my limited data access attention on using custom business objects populated by SqlDataReaders and occassionally OleDbDataReaders. The code I posted would be useful if you were taking this approach, but is generally useless to you if you are using a disconnected typed dataset.