Transfer data between Access 2003 & 2007; Data does not show on formheader

[zufie]

Hi had 2 questions:
1)What is the best way to transfer data that was entered into an MS
Access 2003 database
by using Access 2007?!
(User opened her Access 2003 database using Access 2007, then entered
her data.)
Should I open this database using Access 2007?!
Then save the database as Access 2003 since the production version of
the
database is in Access2003?
Lastly, should I try to copy the data entered in the various
individual tables from one database to the production version of the
database?
(That is, copy-->paste-->paste options: Amend Data to Existing Table)
Or is there a better way?
2)User adds data to a subform on the switchboard of an Access 2003
database.
The previously added data does not show on the form header of another
form that is on the switchboard of an Access 2003 database.
What did I do wrong?
Thanks,
Zufie

 

[GBA]

the entering or viewing of data is not affected by whether one uses Access 03
or 07

the question of copying data from one db to another db is not caused by the
version of Access. it sounds like you are operating two independent and
separate databases (that also may be different versions of Access).

if one has a database i.e. MyDatabase.mdb and then open it using Access
07...and put in data...when you later open that same file MyDatabase.mdb
using Access 03 - - you will see all the data that was put in using Access 07.

 

[yaghoub ghavami]

how teransfer access 2003 to 2007.



zufie wrote:

Transfer data between Access 2003 & 2007; Data does not show on form header
29-Jul-09

Hi had 2 questions
1)What is the best way to transfer data that was entered into an M
Access 2003 databas
by using Access 2007?
(User opened her Access 2003 database using Access 2007, then entere
her data.
Should I open this database using Access 2007?
Then save the database as Access 2003 since the production version o
th
database is in Access2003
Lastly, should I try to copy the data entered in the variou
individual tables from one database to the production version of th
database
(That is, copy-->paste-->paste options: Amend Data to Existing Table
Or is there a better way
2)User adds data to a subform on the switchboard of an Access 200
database
The previously added data does not show on the form header of anothe
form that is on the switchboard of an Access 2003 database
What did I do wrong
Thanks
Zufie

Previous Posts In This Thread:

Transfer data between Access 2003 & 2007; Data does not show on form header
Hi had 2 questions
1)What is the best way to transfer data that was entered into an M
Access 2003 databas
by using Access 2007?
(User opened her Access 2003 database using Access 2007, then entere
her data.
Should I open this database using Access 2007?
Then save the database as Access 2003 since the production version o
th
database is in Access2003
Lastly, should I try to copy the data entered in the variou
individual tables from one database to the production version of th
database
(That is, copy-->paste-->paste options: Amend Data to Existing Table
Or is there a better way
2)User adds data to a subform on the switchboard of an Access 200
database
The previously added data does not show on the form header of anothe
form that is on the switchboard of an Access 2003 database
What did I do wrong
Thanks
Zufie

the entering or viewing of data is not affected by whether one uses Access 03
the entering or viewing of data is not affected by whether one uses Access 0
or 0

the question of copying data from one db to another db is not caused by th
version of Access. it sounds like you are operating two independent an
separate databases (that also may be different versions of Access)

if one has a database i.e. MyDatabase.mdb and then open it using Acces
07...and put in data...when you later open that same file MyDatabase.md
using Access 03 - - you will see all the data that was put in using Access 07

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to hold a successful meeting
http://www.eggheadcafe.com/tutorial...6d-cab220b2f1b9/how-to-hold-a-successful.aspx