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

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

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.


"zufie" wrote:

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

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 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

Previous Posts In This Thread:

On Wednesday, July 29, 2009 5:51 AM
zufie wrote:

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 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

On Wednesday, July 29, 2009 4:43 PM
GBA wrote:

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


"zufie" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to hold a successful meeting
http://www.eggheadcafe.com/tutorials...uccessful.aspx