debug error – acNewRec

[Trevor Howard]

Hello,

I have an Access 2003 developed database, works fine on Access 2000/3 and was fine on 2007 until today!
I get a debug screen, looks like it won't resolve the "acNewRec" line.

Code is as follows:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
DoCmd.GoToRecord , , acNewRec
End Sub

I checked my 2007, and I have SP2 installed, but I am not sure when this was loaded. I removed the "acNewRec" line, then the form opens as expected.

Thanks for any advice.

Trevor

 

[Trevor Howard]

Hi,

I thought I would let you know the outcome in case something like this happen to you.

Our server has a raid controller with a hot swap, and mirrored drives. One of the hard drives had failed. This was replaced, server rebooted and back in business. I don’t know why it had such an effect on the database but it seems to have recovered.
Thanks
Trevor