hello Richard

The sp is like this

CREATE procedure dbo.[sp.DDSGetdetail]

(@TABL nvarchar(100),

@ID sql_variant,

@Detail nvarchar(50),

@ID2 sql_variant = Null,

@idname nvarchar (50) = Null,

@numfield smallint = Null,

@VAR01 nvarchar...

De values doesn't change a lot, but every day there are new records. The problem is how fast a form opens. If it's possible, I declare a global variable for...

We are working with an SQL server with an access frontend. In this we experiences some performance problems with drop down boxes.

To solve this I want to go into...

Hello Paul,

Thank you for your advise. I ran that query and.......personal Edition!! If you ever be in Holland, I buy you a beer!

Manig

I'm sure i've the enterprise edition. I've asked the system admin if we have a version for enough users. Tomorrow I get the answer

thanks in advance

Yes I did, maximum concurrent user connections = 0