 You might prefer to store the images in a directory and simply save the name of the file in the database. Add the path if the images need to be stored in many different directories.
That way, you could still keep working with Access, although I would recommend that you make the step up to SQL Server. Access is rapidly losing ground for serious development, and SQL Server is a lot more powerful. Just too bad that you have to write most of your SQL. The query generator in Access made you work a lot faster for the generic SQL that is used most of the time.
Then, depending on the type of use (multiuser vs single user), you could create a local SQL Server database. This is a type of connection where the database attach automatically to the local server, which is usually the way SQL Server Express is installed. Make a search for 'local data overview' in the documentation to get more information.
Another way is to attach the database through your code. This is the way I install my sample database when I give training in-house. Here is the code I use. Sorry for the comments in French, this is code I use in my training that is always in French. You might try to send this through an online translator. What it does is first check to see if the database is already installed on the server, and if not, it installs it.
JBFI.Photo.PhotoData.ServeurSQL is a constant containing the name of the server. I set it manually in the code at the beginning of each training session, but this could be something that is simply defined through a dialog or a text file.
'cmd.CommandText = "EXEC sp_detach_db 'PhotoCat'"
'cmd.CommandText = "Select * From sysdatabases Where name like 'PhotoCat'"
'BD non présente sur le serveur. On demande confirmation pour l'attacher.
"@filename2 = N'" & fichiers(1) & "';"
'pour celui utilisé dans votre environnement.
PhotoData.ServeurSQL = PhotoData.ServeurSQL	'Inutile, mais aide à la navigation si on a besoin de régler le nom du serveur au début du cours.
This works no matter if I am working on a local SQL Server Express server or on the big production server in the company where I give my training.
As for the connection string, there are many scenarios depending on the situations.
With SQL Server Express, Microsoft recommends to always make an installation by default, and use Windows authentification. The default server name is then.\SQLEXPRESS and you can use the same connection string everywhere.
If the server name changes from place to place or if you need specific login credentials, then it would have to be provided from outside the application. One way to do that is to use a UDL file. To make one, you simply create an empty.txt file and rename it with the.udl extension. Double-click on the file, and you will have an interface that enables you to define a connection string. That job could be done by the administrator everywhere where you install your application. You connection string then becomes simply something like "File Name = PhotoCat.udl". Add the path to the file if it is not installed in the application working directory. The system will open the.udl and retrieve the connection string from there.
There are techniques I use, there are others. It is really a case by case scenario.
A very simple option is to store the pictures in a separate Access database with just one table containing a picture field and a unique Id you join to the relevant table in the otherdata-database. Of course, you are still limited by the max. size of an Access database.
Note also that many installers can automate the installation of SQL Server, so your initial install program could add a new instance of SSE if desired (which many prefer). From there, you'd just run your DDL scripts to generate the database, and populate it as needed with INSERT statements.
I apologize for my delay in getting back to you, I had a situation that kept me tied up on another vastly different project for a while, and couldn't find the time to get back...
All of these solutions help somewhat... but let me be a little more specific....
For starters, I will be storing all of the images inside of the database... I have my reasons for this, but they are irrelevant at this point... my real issue is duplicating my database on the target computer, and archiving the data for storing it offsite and / or restoring that data if and when needed...
LSMConsulting mentioned running a DDL script to generate the database if it didn't exist... This is what I need to know how to do...
I have to be able to install SQL Express (Or whatever flavor would work the best) on the target machine (I suppose I can do this with the visual studio Setup and Deployment wizard by checking it as a prerequisite to my app when building the installer)... Then I need to generate the database, or copy it (This is what I typically do using access, as I can just copy the file from the installer... but how does this work in SQL?... and Lastly, I need to be able to create / Restore backups of the data, which I suppose is loosely related to generating the DB... All of the other ins and outs I believe I can deal with, but these items (Specifically the last two I listed here) elude me.
3. Import all your tables from Access DB with Import and Export WIzard.
4. Create connection to your Access FE and test it.
5. Detach DB from SQL Server.
7. Use JamesBurger's code to attach DB to New SQL server and your FE.
The Athletics Department Needs ME Tutors!
We are looking to hire 2-3 students that would be willing to tutor here in athletics in the fall. Looking for all ME courses, but we use a lot of mid to upper level courses. They must have already taken the course and received a B+ or better. We also require that they have an overall GPA of 3.0 or better. We do hire both undergrad and grad students.My best friend Sam, I married him 32 years ago. We're still "best friends".
Four great kids, Vicki, Andy, Jeff and Pam.
Five very special grandkids: Matt, Danielle, Jasa, Heather and Michael.
Traveling....Italy was the BEST! Be sure and go if you get the chance.
Fishing....surf fishing is the most fun, but I'll fish anywhere, just ask me.
Golfing....great way to get together with friends and enjoy the outdoors. Member Centre Hills Country Club.
Bridge....Not a great player, but I love it. Carry a deck of cards in my golf bag in case it rains.
Reading....seems lately all I'm reading is real estate related, need to work on changing that.

It is my pleasure to welcome you to 1kbb.com. Thank you for taking your time to learn more about us and real estate in Centre County. As you explore our website you will learn 2 very important things. KBB knows the market and KBB has knowledgeable agents that want to be your REALTOR. I look forward to meeting you. If I can help you in any way please contact me.
What a wonderful and fulfilling profession. Starting with a company that had a market presence plus great training, I learned from the best. My thanks to Ralph Brower for teaching me the real estate business and providing me the support to achieve my goal to be successful in the real estate business. EXPERIENCE, there is no substitute! Years of listing and selling all types of properties in Centre County is challenging as well as exciting. It also has taught me how important CLIENT CARE and CLIENT REPRESENTATION is to a transaction. Thus I continued on with my education to get my Broker's license and become a Certified Real Estate Instructor for NAR, PAR and the state of Pennsylvania. As Sales Manager and Trainer I can now share my experience with the agents at KBB which in turn means I share it with you. You and all our clients past and present are the reason we are proud to be the #1 Real Estate Brokerage in Centre County.
The cooperative form of the organization has been an important option for the development of small organizations. However, as well as it occurs in other organizations, the cooperatives need to be evaluated using the category of efficiency to evaluate how was his activities performance. The efficiency evaluation is very important for these categories of organizations because the cooperatives own an administration that should attend the needs to yours several cooperated. In this work was accomplished the application of the denominated method Data Envelopment Analysis (DEA) to evaluate the performance of rural credit cooperatives of São Paulo state. The accomplished study show that the cooperatives that had larger resources managed was able to obtain better performance, concerning your operation goal (credit concession). One of the most important results, evidenced in the study, was that the cooperatives that had larger resources managed obtained better efficiency rates when considered the total relation assets and administrative expenses relatively to the volume of conceded credit. The results obtained show that the DEA can be an interesting alternative option for evaluation performance.
People are in the Toronto and Vancouver for jobs and a diversified economy. The housing affordability problems extends well beyond Toronto and pretty much affects all of southern Ontario. 

But most people don’t want to move to calgary. The oil based economy means economic uncertainty and throw in the poor weather