Save attachements to a central folder

[bodylojohn]

Hello,

I have searched and searched for this but I dont seem to find a solution that suits me.

This is the situation. I have a a database wich is used by multiple users through a front-end. The back-end resides on a server.

Is it possible to select an attachement (word, excel, picture, etc) with the front-end and automatically save it to a folder on the back-end?

This way all the attachements are in a central place and NOT in the database.

I know I can easely solve this problem by saving the attachtments to the database itselve but I dont think that attachements belong in a database.

i hope that you guys can help me.

Thanks in advance

 

[KeithG]

Sure, check out the file system object to do this.

 

[Dreamweaver]

This link will give you what you need:

http://www.access-programmers.co.uk/forums/showthread.php?t=118612

Mick