D
DRWale
Guest
I have a database that needs to update tables in a completely different database.
I dont want to link the two databases.
I have written a small code fragment that seems to do the trick.
'Docmd.TransferDatabase acExport,"Microsoft Access",<DatabaseName>,<TableName>,<DestTableName>'
This transfer is from a locally held database to a network database.
The problem is that sometimes the data in the network database does not seem to be refreshed after the code is run. Anyone know why ?
I dont want to link the two databases.
I have written a small code fragment that seems to do the trick.
'Docmd.TransferDatabase acExport,"Microsoft Access",<DatabaseName>,<TableName>,<DestTableName>'
This transfer is from a locally held database to a network database.
The problem is that sometimes the data in the network database does not seem to be refreshed after the code is run. Anyone know why ?