Sandbox Mode - Can't Access Access

[Todd]

Since installing a security patch from the Web on XP
sometime in January 2004, I am unable to us
ADODB.connection open to create a connection to an Access
database. Before Jan. Everything was working fine. I
have installed Jet 4.0 SP8, MDAC 2.7SP1a, and Office 2000
SP3. I'm running XP SP 1. I have edited the registry to
set Sandbox Mode = 0. Nothing seems to be working. I
receive the following error 2147024769, Method 'Open' of
object 'Connection' failed, ADODB.Connection. Any ideas
would be welcome.

 

[Yuan Shao]

Hi Todd,

Thanks for your post. According to your description, I understand that the
error "2147024769, Method 'Open' of object 'Connection' failed" occurred
with ADODB.Connection after installation of Jet 4.0 SP8, MDAC 2.7SP1a, and
Office 2000 SP3. If I have misunderstood, please feel free to let me know.

Please check the references of the Access database to see if there is any
abnormity.

Open your Access application-> Click on Tools in the VBA environment->
References-> uncheck the object that you feel could be the problem, click
OK, save your Access database. Open the References list one more time and
check back the one that you previously uncheck, Browse to the DLL (Object)
to find it with the right Path. Save and Make your Access database.

What is the version (service pack) of the operation system? Please upgrade
your operation system with the latest service pack.

Thanks for posting in community.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Yuan Shao]

Hi Todd,

How is the issue going on your side? Let us know if you need further
assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.