>I mean actual table name, field names and data types as they appear in Access.

Ok, I put together a demo .prg and a test database to post on my FTP site for you or anyone to download, and discovered yet other factors.

In previous thread, I was having problems with ConversionFunc being ignored. You advised me to update a command object rather than the default record set. I added this code, which fixed the problem with ConversionFunc:


*** ConversionFunc won't work unless we do this
LOCAL dCom
dcom=createobject('ADODB.command')
dcom.ActiveConnection=loConnDataSource
this.UpdateCmdDataSourceType="ADO"
this.UpdateCmdDataSource=dcom
this.InsertCmdDataSourceType="ADO"
this.InsertCmdDataSource=dcom


But, it caused the other problems I have mentioned in this thread. If I remove this code, except for ConversionFunc being ignored, everything works 100%--no errors.

With this code in place, it fails, but I now discover fails differently, depending on how I connect to the database.


Normally, I access the database over the web using MSADC. In making the demo, I connected to a local table in order to simplify things, and behavior changed.

--------
Here is the connection string that accesses the data over the web using MSADC:

remote server=http://server;Provider=MS Remote.1;handler=MSDFMAP.Handler,sfdb.ini;data source=pda_golfballzone_sf;]

As I already described, I cannot update fields containing .null., memo fields containing > 255 characters, or memo fields containing a zero-length string.

The machine hosting http://server (which I am using for development) is running XP Pro and whatever version if IIS that comes with it. It has SP1 and the 2.71 MDAC. I get the same problems on my real web server running Win 2000 server, however.

Another program written by someone else, using this same connection, updates the data without these errors.


-------
Here is the local connection:

DSN=MS Access Database;DBQ=\\server\d\usr\webs\golfballzone\fpdb\local_storefront2.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;

I still cannot update memo fields set to a zero-length string. But I CAN update fields containing .NULL., and memo fields containing > 255 characters.


--------------------


I'll post everything at ftp://hosenose.com/cabug for anyone who wants to take a look.

Thanks,

Dennis