Import access to another access

T

Tung Dang

Hello, I have 2 users working on the same access database, some how they are
not getting the same information they have entered. I wondering of how to
import the work she has done to the original file so all the work she has
done can be import to the same database. Thanks
 
T

Tung Dang

i'm not sure what do you mean, but if i try to import them together it
created a new table instead of just import the data. Is this even posible to
get done? or should i just tell the user to retype their data over? Thanks
 
T

Tung Dang

Yes, they are on the network and they use their own seperate computer.
1. they share the database
2. they can edit the record
3. they work on the same database at the same time
Hope this answer your question. Thanks
 
T

Tung Dang

This is what happened. One user accidentally copies the database from the
server down to her local drive and work on it for a week. Finally she
realist that she's not works on the same database that every one is working
on. What she wants to do is import the work that she has done for that week
and import in to the database on the server. Thanks
 
T

Tung Dang

Thanks for all of you help....
Joseph Meehan said:
Given these facts, there is no easy way. You could update the original
table with the table in the copied database, but it would update any record
changed and add any new records. That could be a problem if any of those
records (no problem with the "page" idea here) were edited on the central
database. You would loose all the new data for any record that was edited
or added to the copy.

I suspect the best idea is to manually input all the data into the
real/original database if they are not certain they both did not work on the
same records over that time. That would be the only way to make sure the
data is good. It would be possible to use some queries to try and find miss
matched data between the two and that might help.

Good Luck with this one. Hopefully the users will now understand that
it has to be done the right way or it can get screwed up.

BTW there are ways of doing this in Access if you plan it from the
beginning. Check out the help files or books for suggestions. I have not
had to do that due to the nature of the work I did. It was high security
and my users would not have been allowed to take it out of the office.

If you want you might also try starting a new topic on the subject.

Just a quick check of the Access help file; you may still be able to use
Access, this is the section you can start looking at in the help file.

Synchronize an offline data access page with source data
1.. Open Microsoft Internet Explorer 5 or later.
2.. On the Tools menu, click Synchronize.
3.. In the Items to Synchronize dialog box, select the check box for the
data access page you want to synchronize.
4.. Click Synchronize.
The Microsoft Synchronization Manger merges the offline changes with the
data in the source database.

Note The rules for merging offline data with the source database are
defined either by the designer of the page or the database administrator.
Contact them if you encounter errors or conflicts during the synchronization
process. You might lose some of your changes during the merge operation,
depending on how the rules are defined.
Click to expand...
 
Top