Please help. Retrieval of data from copied db table.

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

Hi. Let me qualify this by saying I know next to nothing
about Access. I was given an Access db file (a glorified
address list) which needed several thousand entries
made. I enlisted the help of a friend to enter the
data. So we could both work on it simultaneously I
copied the database file to another computer. The
problem now is that I am unable to copy and paste the
entries from the MasterList table of the copied database
into my original database. Is there any way I can
retrieve this information? I know I probably went about
it the wrong way in the first place, so if you could help
me with 1)How to retrieve the data and 2)If I wanted to
be able to have 2 users enter data on different
computers, the appropriate way to do so.

I don't want to have more than one table because all the
queries and forms are designed to draw from the original
table.

Any help would be greatly appreciated!! Thank you.
 
You're not in too bad of a situation here....

You need to import the data into whichever database will be the surviving
database (File>>Get External Data>>Import). This will create a table with
the same name as yours and a 1 at the end of it.

You will then need to run an append query to take the records from table1
into table (the one you worked on).

Then, after the moving is complete, you need to split the database so that
you and your friend can both access the same tables from different copies of
the front-end.

Given that I am really bored today....I can do the data moving for you if
your boss will allow it to be sent to me. Contact me offline if you are
interested.
 
Back
Top