Attachments field and increase the size of the database

[azhar2006]

Hello all
Is it possible that in the case is being processed size of the database to add a field (attachments).
Is there a way?
thanks for the help .

[ItsMe]

I am not understanding what your concern is.

Are you worried about too many attachments making your database so large that you database will break?

Yes, too many attachments can make your database reach its maximum size.

It takes complex VBA code to automatically remove and add attachments.

Here are some code examples ...

[azhar2006]

Thank you Moreau
Yes, this is what I'm trying to do, I'm a little confused about the size of the database and where a lot of documents and attachments for each employee.
Thanks again .

[ItsMe]

Microsoft Access has a limit to the file size of 2 gigabytes.

There is an exception to this rule if you use a computer with 64 bit Microsoft Access installed. However, it is the default option to install 32 bit Microsoft Office. It is the popular thing to do to install 32 bit Access.

If you build a form and add an Attachment control to the form, Users can interact with the files attached to the database.

[ranman256]

Yes , size IS the attachments.
dont use attachments, instead store the documents in a folder, then write the PATH to the document in the db.

\\server\folder\myFile.doc

[azhar2006]

Thanks ranman256
But it will be moved attachments in the case of the transfer of the database, right?
What is the best way to so ordered?
Thank you my friends .

[ItsMe]

If you move the database, the attachments will move with the database.