5 replies
by carquiza
Hi,
How big is the database? If the database is big in bytes you cannot e-mail it obviously there is a maximum bytes that an e-mail can handle. Why not try to reduce the size of the access file and e-mail it to him in series. The best thing is to download the file from your server through internet it will just take a long time. Hope this help a bit.
Cheers,
Mel Arquiza
Home Page Design
http://hdp.welcome.to
by mruiz
by bob sellman
You can't zip the database while you have it open. But if you're trying to update data from a remote user's database, why not set up code in the user's Access that will export the changed data tables to text or Excel file(s), then zip those with PkZip (to speed up the email)?
If you do that you should be able to substantially reduce the amount of data that has to be emailed so you don't run in to problems with very large files.
And if you still need to send a lot of data, having a separate file for each table that must be sent will mean that each table can be sent as a separate email.
The receiving (master) database can then import the data and handle it as appropriate to update the permanent files.
by mruiz
by mruiz
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending