D
Dudley
I have a database which runs OK on my work XP computers but I cannot work on
it at home because it will not run on my home Vista computer.
Several command buttons will not work on my home computer. I get error
Run time error '-2147352567(8002009)':
You can't assign a value to this object
on
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Minutes"
stLinkCriteria = "[EnvelopeNumber]=" & Me![EnvelopeNumber]
DoCmd.OpenForm "Minutes", , , stLinkCriteria
[Forms]!Minutes.EnvelopeNumber = Me.EnvelopeNumber
Yet this works on the XP computers. I have checked that they have the same
references.
Another problem is that when I close the database I often cannot open it
again because the lock file has not closed. Checking Task Manager, the
problem appears to be that Access sometimes fails to close in Processes, even
though it is closed in Applications. I do not have the same problem with
other databases. Compact and Repair solves this problem, but it soon comes
back. It appears to be some corruption in the database which only affects it
on my Vista computer.
Any suggestions?
Thanks
Dudley
it at home because it will not run on my home Vista computer.
Several command buttons will not work on my home computer. I get error
Run time error '-2147352567(8002009)':
You can't assign a value to this object
on
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Minutes"
stLinkCriteria = "[EnvelopeNumber]=" & Me![EnvelopeNumber]
DoCmd.OpenForm "Minutes", , , stLinkCriteria
[Forms]!Minutes.EnvelopeNumber = Me.EnvelopeNumber
Yet this works on the XP computers. I have checked that they have the same
references.
Another problem is that when I close the database I often cannot open it
again because the lock file has not closed. Checking Task Manager, the
problem appears to be that Access sometimes fails to close in Processes, even
though it is closed in Applications. I do not have the same problem with
other databases. Compact and Repair solves this problem, but it soon comes
back. It appears to be some corruption in the database which only affects it
on my Vista computer.
Any suggestions?
Thanks
Dudley