OK. I think the lock table method is a good one. I considered it before this post but I wanted to heare some opinions on it before I make my...

Two questions regarding these techniques:

1) Performance: are systems of these kind fast engough? Do you have such systems running in production environment?

2) Human factor: is there any way to automate...

Yes, that's it. Thanks a lot.

Thanks for your suggestion. I don't want to get the $ amount. Just the top 10 customers with the most records per Month.

Problem:

I want to create a view to do it. Not...

THX to you all for your Help.

Markus

THX to you all for your Help.

Markus

Won't the users/data/persmissions table become VERY large? As I see you'll get one record per user/group per record in every other table. So if you have 2,000,000 records in all...

I considered using an vb ocx called from within sql-server. The ocx will connect to the client via winsock an send a message "there is something on the sql-server you...

No records found. (I have the german versionb of access. I think this should be the translation) This error appears wheter there should be records returned.