Permissions problem.

Phenno

Hi!

I have a table and permission filter on it. I must enter new records through c/al into that table.
Problem is that my primary key is not "auto increment" so i have to find out max number of it and then increment it manually.

How can I find max entry no. while I have permission filters on that table and cannot see that last record at all (or, I am not allowed to see it).

If I set "auto increment" on my primary key, i receive SQL Server error (discussion thread about this error is here http://www.mibuso.com/forum/viewtopic.php?t=7262)

Phenno

Shame on me, I missed last answer on previously mentioned thread.
Anyway, permission problem still stands but it can be escaped by autoincrement (that now works, thx jetpilot).