Attachment in Access 07

[pedie]

'm trying to add Attachment fiels in form which when click i want it to be transfered to the table in other database....
Does vba/query transfer the attachement to the table field?
Is this possible?


Thanks in advance for helping....

 

[xenou]

Because i do not know how to transfer it directly to backEnd

Here I think what is meant is (as I also suggested), not transferring data from one database to the other, but just linking your front end to your back end. Then it's in the backend already and no need to move it.

You can script all this and move things from one DB to another if you like, but it's more work, and with attachments and multi-value fields its even more work than usual as these datatypes are a slightly different animal.

 

[pedie]

Here I think what is meant is (as I also suggested), not transferring data from one database to the other, but just linking your front end to your back end. Then it's in the backend already and no need to move it.

I tried linking tables to backend ['m new to acccess, however it is really easy to delete all the datas in linked table and there is no way to protect it]...if macro is not enabled then everything is Gone!

 

[xenou]

That's true, but it's also really easy to delete all your files on your computer. Do you really think that your users will be opening tables, selecting all records, and deleting them? My opinion is that users have an investment in their data too and it's generally not in their best interests to delete it all. A well designed database uses forms for interaction with tables, and not raw tables directly. So it's not easy to make such mistakes *by accident*. My preference is to keep backups and not worry about every contingency (but I don't have to deal with mission critical systems).

You are welcome to work harder than me at making your databases 100% secure, though. But really consider if it wouldn't be enough to disallow deletes in your form. A user can't delete anything that way, and all your users should be working with forms, not tables. That plus regular backups should be pretty good security unless you really think there will be malicious users using your database, or it would be exposed to an unknown public.

 

[pedie]

Xen, you are right...any one who access to folder can delete database very easily if they are brave enough
But from my part i try to my best that the things/data loss does not happen because of my poor frontend

Thanks again for all the advice...'ll try to make this point when i team have next project meeting...

Thanks

That's true, but it's also really easy to delete all your files on your computer. Do you really think that your users will be opening tables, selecting all records, and deleting them? My opinion is that users have an investment in their data too and it's generally not in their best interests to delete it all. A well designed database uses forms for interaction with tables, and not raw tables directly. So it's not easy to make such mistakes *by accident*. My preference is to keep backups and not worry about every contingency (but I don't have to deal with mission critical systems).

You are welcome to work harder than me at making your databases 100% secure, though. But really consider if it wouldn't be enough to disallow deletes in your form. A user can't delete anything that way, and all your users should be working with forms, not tables. That plus regular backups should be pretty good security unless you really think there will be malicious users using your database, or it would be exposed to an unknown public.