You don't seem to have any code at all in your form to actually locate a file, or its path, which it initially looks like you want to do. Having had a look at your forms it would actually appear that you want to store the image in the database, rather than link to it.
First off, you need to remove the Option Compare statement in the VBA for the browse button click event, that's your initial stumbling block, but it still won't solve your problem of not being able to open a file, or create a reference to it.
If all that you are going to do it store the image as a reference (but watch out for the pictures being moved, deleted, or renamed outside of the application) then having the field Image of type text is adequate (provided the length of the path does not exceed 255 characters - memo might be more suitable). If you actually want to store the picture inside the database table then you'll probably need to set the type for the Image field to OLE Object.
Before you go any further, have look at the sample Northwind database supplied free with Access. In particular examine the form Employees and its associated table. Note that all of the pictures associated with the database are stored in the same folder as the database, so length of file path should not be a problem. In the VBA editor, when examing the code behind the form, got to Tools\References to see what references are required for the database to operate, ensure that your database has at least the same references.
You should also be aware of the cautions in using the Office (number) Object Libraries. Before you get into heavily copying the Northwind database have a look at
this post by Ghudson.
If, having done all of this you have some specific problems get back to us.
HTH
Tim
