Updating access via email?

[Stuart Wright]

Hi,
im trying to get a database that exports its data at one
centre and then this information is sent in a csv file to
a central database which then imports this data the
problem is that i can't get it to import the data properly
and now the proceedure is too large for VB to handle so is
there a quick and easy way of doing this, i want a way of
linking 4 databases to one central one via email any ideas
as the above one isn't working?

thanks stuart

 

[John Nurick]

Hi Stuart,

Are you collecting data in four places and then transferring it to the
centre, or do you need to keep all five databases synchronised?

If the former, transferring via CSV or other textfiles normally works
very well. Problems can occur if the data is corrupted in transmission
or if for some reason the textfile isn't correctly formed. The latter is
seldom a problem if you're using the text export wizard or
DoCmd.TransferText with commas between fields and " " to qualify text
fields.

To rule out transmission errors, zip the file before emailing it: any
errors in transmission will cause an error when it's unzipped at the
other end.

Exactly what is going wrong?

When you say "the procedure is too large for VB to handle", do you mean
you have a single procedure of thousands of lines of code and VBA is
complaining? If so, just restructure it into sensibly-sized procedures
and place them in more than one module.

Hi,
im trying to get a database that exports its data at one
centre and then this information is sent in a csv file to
a central database which then imports this data the
problem is that i can't get it to import the data properly
and now the proceedure is too large for VB to handle so is
there a quick and easy way of doing this, i want a way of
linking 4 databases to one central one via email any ideas
as the above one isn't working?

thanks stuart

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.