I have an application the adds records to an MS Access database. When the DataAdaptor.update command is issued I get a Syntax error in insert into statement. I am using command builder and only get the error on one table. That table has two fields which are the problem. They are called "Password" and "Usergroup." If I rename the fields it works without any problem. So why not just rename them? Simple right. No, the database is used by another application and chances of getting it changed is slim at best. Any ideas as to how to work around this? Any help would be greatly appreciated. Mike :((

I am seeing the same problem when running on a Windows 2003 server. My code works just fine on my local PC and a windows 2000 server. The system admin claims that all permissions are set properly. Both servers are with the same hosting company. Thanks, Mike