If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
OLE Object Makes Database to Large
Fire District has database for running cards -- directions from each
firehouse to each street in the district. My databse is split - front end and back end. We want to add maps of each street. We have scanned the maps and I created a table for the maps and linked it to the table with the directions. I'm pulling the maps in as a ole object. The problem is the database is too large with the maps. Is there a better way to bring the maps in so they show on the form for each street. We tried scanning the maps as pdf and jpeg, but they are ~ 65 to 80 kb each and I have 1000 to pull in. Any suggestions would be greatly appreciated. |
#2
|
|||
|
|||
OLE Object Makes Database to Large
Hi,
I would think Access could handle that number of images. What happens when you load all of them? If that is not feasible, how about storing the files separately outside of the database and just storing the paths to the files in the database? Then in your On Current event you could do something like this: imgMap.Picture = [txtMapPathName] Where imgMap is a unbound image control and [txtMapPathName] is a textbox, possibly invisible, that is bound to the map path name column in your table. There is also in Access 2007 the Attachment type that might be appropriate. I have not used it yet, as so cannot advise on it. Clifford Bass "plfiredis" wrote: Fire District has database for running cards -- directions from each firehouse to each street in the district. My databse is split - front end and back end. We want to add maps of each street. We have scanned the maps and I created a table for the maps and linked it to the table with the directions. I'm pulling the maps in as a ole object. The problem is the database is too large with the maps. Is there a better way to bring the maps in so they show on the form for each street. We tried scanning the maps as pdf and jpeg, but they are ~ 65 to 80 kb each and I have 1000 to pull in. Any suggestions would be greatly appreciated. |
#3
|
|||
|
|||
OLE Object Makes Database to Large
Storing images using an OLE field causes huge bloat and has other problems,
at least for all Access versions up through 2003. I heard that 2007 might have fixed the problem but can’t vouch for that. The way to do this is to store the pictures in a separate folder, and then store the location (path) and filen name in 1 or 2 text fields. Then use code to display the image in forms and reports. I’m not good enough to write the “how to” from memory, but there have been many posts in the Access forums on how to do that. |
#4
|
|||
|
|||
OLE Object Makes Database to Large
Storing images using an OLE field causes huge bloat and has other problems,
at least for all Access versions up through 2003. I heard that 2007 might have fixed the problem but can’t vouch for that. The way to do this is to store the pictures in a separate folder, and then store the location (path) and filen name in 1 or 2 text fields. Then use code to display the image in forms and reports. I’m not good enough to write the “how to” from memory, but there have been many posts in the Access forums on how to do that. |
#5
|
|||
|
|||
OLE Object Makes Database to Large
Hi Fred,
Thanks for the information. I have not used Access to store images, but rather a different back-end. Is an OLE field essentially a long varbinary? Or something different? Could you store images in a memo field? Clifford Bass "Fred" wrote: Storing images using an OLE field causes huge bloat and has other problems, at least for all Access versions up through 2003. I heard that 2007 might have fixed the problem but can’t vouch for that. |
#6
|
|||
|
|||
OLE Object Makes Database to Large
Hello Cliff,
I'm not smart enough to answer your question varbinary question. What I wrote is what I learned both from lots of experience doing it both ways, and from seeing it asked and answered in these Access forums lots of times. Sincerely, Fred "Clifford Bass" wrote: Hi Fred, Thanks for the information. I have not used Access to store images, but rather a different back-end. Is an OLE field essentially a long varbinary? Or something different? Could you store images in a memo field? Clifford Bass "Fred" wrote: Storing images using an OLE field causes huge bloat and has other problems, at least for all Access versions up through 2003. I heard that 2007 might have fixed the problem but can’t vouch for that. |
#7
|
|||
|
|||
OLE Object Makes Database to Large
Hi Fred,
Just found the answer at http://msdn.microsoft.com/en-us/libr...ffice.11).aspx which says that the OLE Object is a long varbinary. A memo is a long varwchar, which probably would not allow for binary data. It probably would clash with the UNICODE encoding in the memo field. So, from your experience and others, Access just does not handle it well. At least pre-2007. Useful to know. Thanks again, Clifford Bass "Fred" wrote: Hello Cliff, I'm not smart enough to answer your question varbinary question. What I wrote is what I learned both from lots of experience doing it both ways, and from seeing it asked and answered in these Access forums lots of times. Sincerely, Fred |
#8
|
|||
|
|||
OLE Object Makes Database to Large
Thanks for your suggestions. I'll try to figure that out. I am using 2007
and it is having problems. I brought in about 400 maps (ole) and it corrupted the database because it was too large. "Fred" wrote: Storing images using an OLE field causes huge bloat and has other problems, at least for all Access versions up through 2003. I heard that 2007 might have fixed the problem but can’t vouch for that. The way to do this is to store the pictures in a separate folder, and then store the location (path) and filen name in 1 or 2 text fields. Then use code to display the image in forms and reports. I’m not good enough to write the “how to” from memory, but there have been many posts in the Access forums on how to do that. |
#9
|
|||
|
|||
OLE Object Makes Database to Large
Fred,
When you say to store the path and file name in one or two text fields, do I create a seperate table for these and then link the tables? Thanks, Patty "Fred" wrote: Storing images using an OLE field causes huge bloat and has other problems, at least for all Access versions up through 2003. I heard that 2007 might have fixed the problem but can’t vouch for that. The way to do this is to store the pictures in a separate folder, and then store the location (path) and filen name in 1 or 2 text fields. Then use code to display the image in forms and reports. I’m not good enough to write the “how to” from memory, but there have been many posts in the Access forums on how to do that. |
#10
|
|||
|
|||
OLE Object Makes Database to Large
Hello Patty,
It would just be one or two text fields in the relevant table. (we do it using one, which is the combined path and file name) From your post, I'm guessing the relevant table would be your RunningCard table. Sincerely, Fred |
|
Thread Tools | |
Display Modes | |
|
|