I used tableadapter to insert records into my access database and it does so perfectly when run using the programs exe file in the bin/debug directory or directly from the vb programmin environment but when i publish the program and try to run it elsewhere it gives me an error that it cannot insert into database cos i'm not using an updateable query. what does it mean and how can i solve this error?
someone please.... help me. it is urgent.

If you copied the database to a harddisk from a CD, the database file will be read-only. Perhaps that is it?

Also, if the person running the program does not have write permission to the DB file, that will do it also.

Thanks brian. actually i copied the database from harddisk to CD which made the database readonly. I had to copy it back to the harddisk to remove it from the readonly mode after which i was able to query the database.
i also figured out as i have already written that as long as you are using visual basic 2005 express edition, you have install windows installer 3.1 and dotnet framework 2.0 for you to use your published or built program on any system.
Thanks again...

No .NET anything (VB Express, C#, whatever) will run without the framework in place.

hmm...It means something is still wrong then i guess i have to still figure it out. I know when i used VB 6 it didnt give me any of such problems.

VB 6 depends on VBRunxx.dll. Had you distributed a VB .exe without that, and put it onto a machine without that file, you would have run into the same type of problem.

Ok then so do u know any of such files that VB Express 2005 depends on? I know though that the minute i install the .NET framework it runs. I will like to check it out? Thanks

Well, you said it yourself above: The .NET Framework. This is the counterpart to the VBRun DLL.
I have not had much contact with Installer; I don’t know what exactly it is used for, when it is required, and so on. But it seems that you discovered that that too is needed.