trouble with datasets

[davesil2]

I am trying to create a database application. I have had success with foxpro and access databases in the past. I have been trying to create my current app with access and have run into several snags.

 

I am currently just using the VB.Net wizard for the oledataadapter. I can create the adapter and the connection without difficulty. They both appear to work properly in that I can preview the data. However, I am unable to create a dataset that actually works. When I generate the dataset it says there were problems generating the dataset, please build the project, fix any errors, then generate data again.

 

Unfortunately I cannot locate the source of the problem but I have a hinkling that it may be the microsoft jet 4.0 sp8 update that I installed. I haven't been able to remove it so I can't really test.

 

I have tried several different versions of access but that has been unsuccessfull. If anyone knows anything that would be quite helpfull. As of now I have the option of rebuilding my machine and or trying MSDE (though that's not fixing the problem, just working around it).

 

Thanks in Advance - David

[Nerseus]

What kind of SELECT are you using? Make sure all columns have a name (if you use "SELECT MAX(fielda)..." with no alias on the MAX for example).

 

What line of code does it break on, dataadapter.fill?

 

-nerseus

[davesil2]

If I try to Fill a dataset and if I try to update I get an error fatal execption in db. I am using the wizard to I am not trying to do anyting fancy.

 

(ie. Select autoid, name, age from data)

 

Insert does not work when I can get the fill to work. It seems to be getting progressively worse. (Perhaps I'm getting progressively worse...lol)

 

BTW...I'm using SQL MSDE without any problems and have repaired my installation for visual studio .net 2003. In addition. I had several program that I wrote with access in the past but do not appear to be working anymore. The only common link I can find is the updated access engine jet 4.0 sp8. I can't uninstall it either because I did some clean up for space.

 

I may just need to rebuild my computer.

 

-David

[kutz]

I may have a veeery simple solution for you.

 

Apparently if there is an ampersand ( & ) symbol in the path to your project it can often break this wizard.

 

Give it a go. Rename any folders in your project that contain an ampersand and try to generate the dataset.