OK. Let me try it

Thanks a lot

Thanks.

==> If you are seeing the tables as read-only, chances are your userID in SQL Server doesn't have permissions to edit or append data.

But there is no problem for...

Rowan:

==> Firstly, what exactly do you mean by a proxy table? Are these just links to SQL Server created using ODBC or some form of (pass-through) query?

=====

There is no LINKED...

ok.

1. This is mdb

2. Subform are just imbedded into main form

3. Only subform is linked to the proxy table (because the table feeds continuous subfom) Other controls (dropdowns, textboxes) do...

Thanks to all. The intriguing fact is that the app that worked smoothly for 2 years SUDDENLY stopped working. It RESUMED working 6 hours after I posted this post. We...

OK. I'll try to run other ADO / command / recordset codes to see if there is a system problem.

Thanks

Nothing was changed (I like your motto re microsoft - this is just another example ...)

It IS an ADO problem. The procedure runs smoothly in SSMS. The mystery is that on Friday there was no problem with ADO either - and now ...

Wildcat: I wish I knew another way to do it (without cursor): for each row we need to look back and check, if we have related records within 30 min...

Thank you guys. I trust that DBA moved the database but did not allocate additional memory. And the reason to move the db to a new server was that the...

Look, the hard copy of pdf contains signature. If so, we probably should scan the signed copy to pdf first?

Sean, this article deals with R2 and mentions that "FILESTREAM RsFx driver is certified for Windows Server 2008 R2" - mine is just plain ss2k8 - does it matter?

Ha! and ... when selected will the pdfs have the same design? (I will read what you suggested)

I shrinked database and now I do not have this buffer message. And I cannot reproduce it from the top of my head. As soon as it shows up again...

PLE is ok.

Thanks a lot!