I have been using a database built in 2003.
Yesterday I installed Access 2007. All was fine & I can open the 2003 database in the new Access programme and everything works - or appears to.
I then thought I would create a 2007 format so created a black database and imported all of the database objects into it.
However, I am missing only one table out of 14 in total Everthing that is associated with that table (queries & forms) do not operate.
I then tried to import the table in isolation again and found that it was not visible in the 2003 file format. I then opened in 2003 file in 2007 programme and could not see the table. However the query is there with all of the data in. Also the form using this tabel and I can edit add etc as normal.
I then thought I would create a table from the query, but when I tried to save in the correct tables name, it said the table already existed?
Has anyone any experience of this. I simply cannot acertain what is happening.
Thanks in advance for any guidance.
Yesterday I installed Access 2007. All was fine & I can open the 2003 database in the new Access programme and everything works - or appears to.
I then thought I would create a 2007 format so created a black database and imported all of the database objects into it.
However, I am missing only one table out of 14 in total Everthing that is associated with that table (queries & forms) do not operate.
I then tried to import the table in isolation again and found that it was not visible in the 2003 file format. I then opened in 2003 file in 2007 programme and could not see the table. However the query is there with all of the data in. Also the form using this tabel and I can edit add etc as normal.
I then thought I would create a table from the query, but when I tried to save in the correct tables name, it said the table already existed?
Has anyone any experience of this. I simply cannot acertain what is happening.
Thanks in advance for any guidance.
