Query to get around size of data

[pkost]

Hello,

I’m interning on a database project that has become a lot more complicated than planned. The goal is to store photos of the project I’m working for and be able to use a form to call up all the photopoints over the past 4 years at the different locations. I’m having problems getting around access’s 2 gig limit. Which I thought I solved by creating lots of separate databases and linking them together but now I can’t figure out how to write a query in which I don’t pull in all the photos or is that even possible. Is there anyway I can indirectly reference them and still get the pictures to show up in the forms? I’d appreciate any help. Thanks

 

[Remou]

Have you see these?

http://support.microsoft.com/kb/285820/

http://support.microsoft.com/default.aspx?scid=kb;en-us;103257

http://office.microsoft.com/en-us/access/HA011472041033.aspx

 

[pkost]

No I haven't thanks, I was kinda hoping this was a point and click thing. I'm not very good at writing code

 

[Remou]

Have a look at the Employees form of the Northwind sample database. You should find pretty much all the code you need.

 

[lespaul]

additionally, instead of storing the pictures in the database, store them on a drive and put the location in the database. Will eliminate the size issues.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins