Hey all, I found this really great page that will help everyone advise me on Access issues no end ... http://weblogs.sqlteam.com/jeffs/archive/2006/06/06/10093.aspx

How would I go about using sql files for migrations instead of using code? I have an existing project that already has sql files to migrate the database. I don't want to have to recreate the schema with code if I don't have to. Thank you in advance.

Just incase someone is looking for some direction on this topic. It took me awhile to find all the pieces that I needed to load a dropdown from a view. Usually I use the subsonic dropdown but sometimes I need to load up a regular old asp dropdown. MyViewCollection coll = new MyViewCollection(); coll.Where(MyView.Columns.SomeVariableId, SomeVariableId...

FYI: If i remove the column from the db table and regenerate everything works, but when I add it back it in fails.

Have you tried to include ThumbUrl in Datakeyname list? I know that it is not a key but this way it should be ignored. Manu