L
LMN
Hi, thanks for reading! I'm updating a database created in Access 2000 that
was then upgraded to 2003 and now I'm trying to open it in 2007. Here's what
happens:
1. Open old database file (MailingList.mdb)
2. Get login screen and see main switchboard
3. Fill in login information
4. Database opens but the Office Button shoes only one option -- Close
Database
5. Ribbon is disabled except for certain functions on the "Home" and
"Acrobat" tabs (can't even see the other tabs).
After reading this forum and trying to find similar problems among users, I
ended up doing several things. I enabled all macros, designated the old
database as a trusted source, and held down the shift key to open database.
When I hold down the shift key the following happens:
1. Database opens with NO login screen. At the top instead of saying
"Mailing List" it says "Mailing List Test: Database (Access 2000 File Format).
2. The Home button is fully functional
3. The Ribbons shows all tabs and all tabs are functional
4. I can edit/create reports, etc.
5. However, if I try to go into Design mode for the main table (tblCustomer)
I get the following error message:
Table 'tblCustomer' is a linked table whose design can't be modified. Ifyou
want to add or remove fields or change their properties or data types, you
must do so in the source database.
So my question is whether by holding down the shift key and bypassing the
login screen am I not actually in the database? Does anyone have any idea
what's going on? My goal is to export the data from the 2003 database into a
new 2007 database that I will be redesigning.
Thanks so much for any thoughts.
L
was then upgraded to 2003 and now I'm trying to open it in 2007. Here's what
happens:
1. Open old database file (MailingList.mdb)
2. Get login screen and see main switchboard
3. Fill in login information
4. Database opens but the Office Button shoes only one option -- Close
Database
5. Ribbon is disabled except for certain functions on the "Home" and
"Acrobat" tabs (can't even see the other tabs).
After reading this forum and trying to find similar problems among users, I
ended up doing several things. I enabled all macros, designated the old
database as a trusted source, and held down the shift key to open database.
When I hold down the shift key the following happens:
1. Database opens with NO login screen. At the top instead of saying
"Mailing List" it says "Mailing List Test: Database (Access 2000 File Format).
2. The Home button is fully functional
3. The Ribbons shows all tabs and all tabs are functional
4. I can edit/create reports, etc.
5. However, if I try to go into Design mode for the main table (tblCustomer)
I get the following error message:
Table 'tblCustomer' is a linked table whose design can't be modified. Ifyou
want to add or remove fields or change their properties or data types, you
must do so in the source database.
So my question is whether by holding down the shift key and bypassing the
login screen am I not actually in the database? Does anyone have any idea
what's going on? My goal is to export the data from the 2003 database into a
new 2007 database that I will be redesigning.
Thanks so much for any thoughts.
L