Updating 'Remote View' to Access table

[foxrainer]

I made a connection to an Access table successfully. However, right clicking on the View (in the DBC Designer window), selecting BROW, then making changes does not save changes to either the view or the remote access table.

I did check 'Aynchronous execution'.

Are there any hidden controls I am not seing?

Thank you in advance

 

[DEDMOD]

Have you checked all the fields you want updated in the Update Criteria tab in the view? And did you remember to check the send SQL checkbox?

And what sort of buffering, if any, do you have (I'm not sure what the default might be when browsing). Dave Dardinger

 

[foxrainer]

I am afraid that I messed up the ODBC driver for MS access. When trying to make a connection or remote view, I now get 'Unable to get column information, maybe due to corrupt ODBC driver or ...' error.

What is the best way to re-initialize the drivers?

Any help would be appreciated, I am obviously new to ODBC

Thank you

 

[DEDMOD]

Are you talking about the drivers themselves or the connection. I'd assume you could delete the driver from your system and then reinstall it from whatever disks your MS Access came from or from the MS website. I admit I haven't had to do so. Contrawise, if it's the connection which is corrupt, just eliminate it and start over. Dave Dardinger

 

[foxrainer]

It's actually the ODBC. Somewhere along the line, in a time of insanity, I deleted the Access Driver User Data source.

I since figured out how to make the connection, define the Remote View, and have it write back to access.

Thanks for all the help, sometimes it's good just to be pushed the right direction.

Oh, yes, I did reinstall the whole ODBC set from the VFP install disk.

Thanks again,
Rainer