B
bob engler
I have a VBA module running OK under Access2002 but am trying
to also run it on Access2003 on a new laptop XP Pro SP2 all updates
installed. The 'ActiveX component can't create object' Run-time error
'429' fails at the beginning at 'Set RS = CurrentDb.OpenRecordset(
"test", dbOpenDynaSet)'. The references set are the same as in the
Access2002 except later versions: VB for Appl, MS Access 11.0 Object Lib,
OLE Automation, MS ActiveX Data Objects 2.1 Lib, MS HTML Object Lib.,
MS DAO 3.6 Object Lib.
The other thing that is different is when the mdb first comes up, it gives a
security warning 'Unsafe expressions are not blocked' I answer 'No' to the
blocking question. It then gives a window about making sure the MS Jet 4.0
is installed. I tried to load the MS Jet SP8 but it said my XP SP was of
later
date so didn't need it. The VBA module is executed on demand under the VBA
screen as it is still in development. Is there something new that needs to
be set
with Access2003.
Thanks.......
to also run it on Access2003 on a new laptop XP Pro SP2 all updates
installed. The 'ActiveX component can't create object' Run-time error
'429' fails at the beginning at 'Set RS = CurrentDb.OpenRecordset(
"test", dbOpenDynaSet)'. The references set are the same as in the
Access2002 except later versions: VB for Appl, MS Access 11.0 Object Lib,
OLE Automation, MS ActiveX Data Objects 2.1 Lib, MS HTML Object Lib.,
MS DAO 3.6 Object Lib.
The other thing that is different is when the mdb first comes up, it gives a
security warning 'Unsafe expressions are not blocked' I answer 'No' to the
blocking question. It then gives a window about making sure the MS Jet 4.0
is installed. I tried to load the MS Jet SP8 but it said my XP SP was of
later
date so didn't need it. The VBA module is executed on demand under the VBA
screen as it is still in development. Is there something new that needs to
be set
with Access2003.
Thanks.......