| Richard G. 2005-07-31, 3:24 am |
| I have a VB6 program that uses ADO against an Access 2000 database
sitting on an XP Pro SP1 box. On the second (and only other) user's XP
Home SP2 machine, database connection and reading work fine but the
program crashes with an "<application> has encountered a problem and
needs to close. We are sorry for the inconvenience" message whenever it
tries to update the database.
NTFS/Share permissions don't seem to be the problem - I have Simple
File Sharing turned on at the host, and the client computer can copy
files to the host data folder without problems. I've used optimistic
locking throughout. The provider is Microsoft.Jet.OLEDB.4.0.
I'm thinking the problem is likely an SP2 or MDAC versioning issue. But
before I go down that road, is there something else I should be
checking?
(Two quick admissions: for the moment I have the client accessing the
front-end on the host, and I haven't yet been able to test on an
non-SP2 box.)
Thanks for any suggestions...
Richard
|