I have a problem adding pictures in my database. I add the pictures with command(I think made the application last summer and now I'm doing maintenance for it)
DoCmd.RunCommand acCmdInsertObject
And everything goes well otherwise than the fact that the filesize of the database has got totally out of hand. The original database was 5 MB and the size of the folder containing the pictures that have been added is about 7 MB. But now the databases s filesize is 225 MB. And nothing else that should take much space has been added except the pictures. I have used the "compact database" utility, but it doesn't have an effect. What is the reason for this and can I go around it somehow?
DoCmd.RunCommand acCmdInsertObject
And everything goes well otherwise than the fact that the filesize of the database has got totally out of hand. The original database was 5 MB and the size of the folder containing the pictures that have been added is about 7 MB. But now the databases s filesize is 225 MB. And nothing else that should take much space has been added except the pictures. I have used the "compact database" utility, but it doesn't have an effect. What is the reason for this and can I go around it somehow?