Automated Import Newbee needs help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2007

I have a database "Database3" it has 3 tables, Master, Importer of Record,
Customer.
Here is the question I would like to have a button on my main form that will
allow the user to import data from a USB flash drive which is storing the
same database. This allows the user to work from home(Off a flash drive).
the import will updating the main copy of the database on the primary machine
can this be done,
 
Yes. The only issue is whether the flash drive will always have the same
drive letter designation. If it will, there is no problem, but if it will
not, then you will have to include code to allow the user to identify the
location of the other database.

But, the short answer is you can either use a macro of VBA code to do the
transer and you can execute the macro or code in the Click event of the
button.
 
Dave thank you for the time to responde, The flash drive will will always
have the same mapping.
Can I provide you any other details
 
Code for event
flash drive is f
data base is database3
master data base stored on c:\newwalt
 
Okay, but let's talk about exactly what you are doing. You are asking about
importing the data from the database on the F: drive which is a copy of the
databae on the C:\drive. Are you wanting to replace all the data in the
tables on C: with what is on F: or are you wanting to Merge the data.

I need to know exactly what you want, please.
 
A merge is a dangerous thing. When trying to merge two tables, adding
recordss from F: that are not in C: would be easy, but waht about records
that have changed? There is no way to know which is the correct record to
keep.

That is why there is replication. It takes care of that sort of thing. Why
don't you read up on replication in Access Help and on this site and see if
it would be better for you. If that wont do it, post back and we can work it
from there.
 
Dave I looked at the help file and this is what I found , So I guess that we
need to move forward on merging the data. It is not a problem because once
the records are created they will not be updated from the laptop. So only the
new records will need to be Imported or merged. And existing records will not
be changed

Replication is not supported in the Office Access 2007 file format. You can
use Office Access 2007 to replicate a database that was created in an earlier
file format, but not a database that was created in the Office Access 2007
format.
 
Back
Top