Import access to another access

  • Thread starter Thread starter Tung Dang
  • Start date Start date
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
 
Tung said:
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
Click to expand...

By far the best thing to do here is to have both working on the same
tables on a LAN.

If that is not possible you need to work out some complex problems like
how do you know which data to keep if both users have edited the same record
when you try to combine the data and of course you have the problem of
combining the data.

BTW each user should have their own "front end" located on their own
machine, which links to the "back end" located on a server (which in a small
network could be on one of the two machines).

So give us a little more information. Is it possible to link the two
users on a LAN?

If not, well it gets complex, questions like might they both be working
on the same record between syncs? How often do you need to sync, how are
they going to get the data physically from one to another?
 
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
 
Tung said:
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
in message news:[email protected]...
Click to expand...

It most certainly is possible. But there may be 20 different approaches
depending on the situation.

First we need to know more about the problem.

These two employees; do they share a machine? Do they work on the
database at the same time? Do they work on the same records at any time;
that is could one edit a record the other created? Are records edited or do
they remain static after they are created?

Most important are the two employees on a network? (this will make it
easy and is by far the best solution.)
 
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
 
Tung said:
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
....

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
Click to expand...

Great, they are working on the same data base.

If they both log off and then log back on, do they see the other's work?

I am assuming it is some of the work the other one is doing that they
don't see.

Here are a couple of things to consider.

They need to share, not only the database but the same tables. They do
not need to use the same forms or queries. In fact it is best that each one
has their own database, with out the tables that have the data that is
edited. This database should be on their own machine. These local or sure
or "front end" databases should have all the queries, forms reports etc that
they use. Their front end database is linked to the "back end" database
that has just the tables and it is accessed via the network in a place they
both have full access (read/write/create/edit/delete).

Access locks a "page" of data at a time when someone is editing it. A
page may be on record or a group of records, you don't get to choose. The
locking choices you define for the database will determine what happens when
they both try to edit the data that is on the same page.

Until the first user finishes their edit of the data and the second user
refreshes their data, the second user will not see the data.

Does this help?
 
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
 
Tung said:
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
Click to expand...

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.
 
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...
 
Back
Top