I'm still offering 5 dollars, better than nothing.

Anyway better than "I want (you) to cut my grass"!!:-P

By the way, I still need somebody...

This one is perfect for Wayne 😀

I think you can't avoid using dynamic SQL.

Well, if you run this statement directly from the program code, it IS dynamic SQL, so you could test for the column...

You can use ADO or DAO in Access. It only depends on the references you add to the Tools-->References menu in the VBA menu bar.

See this for more info: http://msdn.microsoft.com/en-us/library/aa164825(office.10).aspx?ppud=4

MyConnection...

Did you try with ADODB.Command as I suggested?

You could also create synonyms in db1 for the tables in db2.

I don't like this solution anyway, it's not very clean.

You could loop through all views and replace db1 with db2 in the text returned by sp_helptext @viewName.To get an alter statement you will have to replace again CREATE with...

I had to code an application to do that. The app got through all sp and added a call to a logging procedure as first instruction.

Ok, I think I got it from Mike's reply. Your question is a bit hard to understand indeed.

You can work with a stored procedure as Mike suggested, or build a...

Exclusive locking applies only to modified rows. I suggest you UPDATE directly.

Regards

Gianluca

This is Visual Basic, I dont' understand what is your problem.

Can you provide more information?

What error are you getting?

Where does the error happen? Visual Basic or SQL Server?

Try adding the column and then running the create procedure, it should work.

Regards

Gianluca

It is really difficult to identify unused objects.

I applied many strategies and I still need to combine them all to be quite sure when I move away unused objects.

1)...

I would say "none"...

I don't see anything that can't be done with a set-based solution, which performs much better. I suggest you to try to convert this into a set...