ACCESS 2007: Limit attachement field

[bodylojohn]

Hello,

On my form I have an attachement field. In that field I want to store pictures.
However I want the picature to be less than 100 kb. Also I want that for each record only 1 picture can be inserted.

I hope that you guys can help me.

thanks in advance...

 

[bodylojohn]

BTW.. I think its better to store my pictures outside of the database.
Only thing is how.
I get brainbusted on that later.

The question above still applies (lol)

 

[bodylojohn]

Someone????

 

[GaryPanic]

check the samples

theres a sample there somewhere where you store the link to the file stored outside of access .. this seems to be the route to go ...

gp

 

[bodylojohn]

check the samples

theres a sample there somewhere where you store the link to the file stored outside of access .. this seems to be the route to go ...

gp

No...sorry but I cant find it.

I just want to limit the user to 1 attachement and control the size of the attachement.

 

[ssteinke]

Look up the 'FileLen' function to test for the size of the attachment