Thanks for the reply! Yea, seems websites on the local IIS need to be ran as administrator, but doing this with projects causing some issues. Yay for Windows 7 security issues.

Thanks for the quick responses rashad! Basically these tables are just one column tables with multiple rows that contain links to PDF files. I know I could just use one table and set the links for that table, but I'd rather have 5 separate tables and have their Visibility properties changed based on the login. Thanks, Nate

Easy, easy now :laugh: "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Agree. Thanks Again. Nathan Lindley

Yea, I used MIN(), but what I essentially did was MIN(column1) As Column1, etc.. and inserted the records into a temp table, cleared the original table, and then loaded the records back into the original table. I don't know why I didn't do this in the first place, but i guess i was looking for a more concrete way to do it. Oh well, this works. Thanks again for the responses! Nathan Lindley

Tried the first one but it was to no avail, but the second one is money. Thanks. Nathan Lindley

Possibly ugly, back-end solution, but, have you tried de-installing JEdit to see if your MSI's then work correctly? Assuming, of course, you can re-install it after the fact...

Actually, the best example to follow in this case would be the first one. After the details are edited in the second form, the original form has to refresh its dataset so it can display the new data. The second form doesn't need to stay up if it's not editing anything. What I meant by "running two forms simulataneously" is that the user can switch back and forth between the forms at any time, or they are modeless. A modal form is a dialog box. You can't continue with the rest of the application unless that dialog box is dismissed (OK or Cancel). Dave Kreskowiak Microsoft MVP - Visual Basic

Good call with the casting it as a DataRow array. Nathan Lindley .NET Aficionado

Another way to do this would be to implement an MVP or similar (MVC, Passive Screen, Supervising Controller etc.) pattern. That way you could raise the event from the view, into the associated presenter, which can Notify through a model to anywhere in the application that uses that model. Making the event not dependant on the form. Of course, this might not be viable. It's something to think about though... Take a look here[^] for more info on the patterns

The BindingNavigator doens't expose any method of searching, so no, it's really not cut out for this. You're best method is to get the PK, open a new connection and fill a dataset with a query specific for returning records with that PK. Dave Kreskowiak Microsoft MVP - Visual Basic

Thanks Kschuler, Dave! I had checked it for being Nothing before and was still getting the NullReference, but when i checked if Not Nothing, it seemed to do the trick. Thanks for the advice. Nathan Lindley, .NET Aficionado

I was thinking the same thing but I did the connection over and it still didnt work. I came to the conclusion that it was the DB settings not letting it connect because I actually created the DB on the server as opposed to the System Admin. So I had the SA make a new DB and it worked like a charm. I am not sure what settings were causing the remote connections to not be allowed but its all good now. Thanks for the response. Big Pimpin, Spendin Gs Nathan Lindley, .NET Aficionado