compile error: invalid use of property

[OM]

Hi,

We have an access 97 db which is sitting on a Windows NT 4 server. All
the PCs which access the db are Windows NT 4 workstations. This has been
running fine since the db was installed

Lately, I have been trying to use one of the new Windows XP pro PC (not
upgraded from the NT 4 workstation) to access the DB and has been
getting the above error message on one particular from buttons. I tried
running the form from design view and it said

run time error: 2450
DB can't find the form "form_1" referred to in a macro expression or
Visual Basic code.

The form obviously is there and this is working on the Windows workstation.

The XP Pro PC is stilling running Access 97 and is patched with SR1 and SR2.

Any advice would be appreciated.

Thanks

Keith

 

[Guest]

Your email is not clear how the XP-pro is accessing the NT MDB database.
Try moving the MDB from the NT machine to your XP pro workstation and try
that first. If this works fine then you may have a security access problem
usually this is caused where the username and password on the XP machine and
NT machine are not synchronized or are the same. Remember security and folder
access across a network are very sensitive with XP.

Finally, try setting up a shared folder on the NT machine and see if you can
See and OPEN the MDB before accesing it from the XP machine via macros or
links.

RobertoM

 

[OM]

Your email is not clear how the XP-pro is accessing the NT MDB database.
Try moving the MDB from the NT machine to your XP pro workstation and try
that first. If this works fine then you may have a security access problem
usually this is caused where the username and password on the XP machine and
NT machine are not synchronized or are the same. Remember security and folder
access across a network are very sensitive with XP.

Finally, try setting up a shared folder on the NT machine and see if you can
See and OPEN the MDB before accesing it from the XP machine via macros or
links.

RobertoM


:

Hi Roberto

The DB is actually sitting locally on the XP pro machine now. There is a
access application(mdb format as well) to access the db.

Also, everything else seems running OK except this particular button.

Keith

 

[Tom Wickerath]

Does the VBA code compile properly on this machine? Have you checked for any references marked
as MISSING on the Windows XP pro machine? Also, have you split the database into a front-end and
back-end, and installed a separate copy of the front-end on each PC's hard drive? If you are
sharing one database, you may very easily have a situation where references that are valid on
most PC's are not valid on the new one.

Access Reference Problems (Doug Steele)
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Solving Problems with Library References (Allen Browne)
http://members.iinet.net.au/~allenbrowne/ser-38.html


Tom
__________________________________


Hi,

We have an access 97 db which is sitting on a Windows NT 4 server. All
the PCs which access the db are Windows NT 4 workstations. This has been
running fine since the db was installed

Lately, I have been trying to use one of the new Windows XP pro PC (not
upgraded from the NT 4 workstation) to access the DB and has been
getting the above error message on one particular from buttons. I tried
running the form from design view and it said

run time error: 2450
DB can't find the form "form_1" referred to in a macro expression or
Visual Basic code.

The form obviously is there and this is working on the Windows workstation.

The XP Pro PC is stilling running Access 97 and is patched with SR1 and SR2.

Any advice would be appreciated.

Thanks

Keith