Dynamic SQL in VB is ok but then I can't retrieve any output parameter or return code from the procedure...

I tried Parameters.Refresh but it fails all the time.

Apparently, when I do this, it seems to try and fire the stored procedure which does not work because some parameters are...

I have benefited so often from this web site, only happy to add my little bit! 😉

The answer was simple... Just press <Shift> while opening the database.

I used to know that trick but tried by pressing <Shift> while opening MS Access while it has to be...

I feel very much the same...

I'll have to give that a shot.

Thanks 😛

I like the idea! I'll have to try that

How was the performance?

OOhhh....

I like that!

Thanks

My MS Access knowledge dates back from 2000... so I might need to refresh a little bit.

I need to look into the Pivot form.

To display the result of the report...

Actually that was not exactly what I had in mind but I might be able to use your idea too...

I was more thinking of building a page capable of adapting...

Now, I run into the problem of Access thinking the view is not updateable...

How can switch my form back to Read/Write mode?

Thks

Since you seem to be an expert... may I ask you a couple of questions?

I used Access in anger back at version 1.1 and 2... while ago!

I consider myself an...

No I can't effectively do anything like that but I do all my DDL through script files anyway (hence neat deployment) so it did not bother me...

That's funny because I just connected to SQL Server 2008 from access ADP 2003 on my machine.

I did not notice any problem.

I flip back and forth between Sql Server 2005...