Application questions

[AlexChang]

Hi my name is Alex. I am new to the board. Howdy everyone!

I am writing a small app for work. It generates some error messages that I could not figure it out. They are listed as below.

First error: Everytime I press "Add New" button, the error message reads:
"Run time error '91': object variable or with block variable not set"
Press debug button:
rsParts.AddNew is highlighted

I aleready declared rsParts = Recordset in the beginning of the app. What do i need to do?

2nd error: Sometimes I see this error when clicked on my form. The error reads:
"run time error '-2147467259(80004005)'. The database has been placed in a state by user "admin" on machine "Machine_Name" taht prevents it from being opened or locked."

How do I open this app on my local machine?

Thank you very much!

Best Regards,

Alex

[mmetzger]

Take a look at this article. Your message doesn't match exactly, but the error code does.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518

Basically, it's likely permission oriented...