Hi there,

I had created a database using access xp version. The table showed up fine. On one pc I upgraded to 2003 and on the other to 2007. Now the table is gone. I can still access forms and reports but I find this strange as where is the information coming from.

However I cannot create new forms etc as there is no table to obtain data from

Help please.

Gordon

I'd back up your current DB (copy and rename) then Compact and Repair.

I am always having "Weird" things happen to one of my clients DB's and after I've spent too much time trying to
figure out why, I just end up "Compacting and Repairing" and it fixes the problem a lot of the time.

Give it a shot and see if that helps then post back if you still have the same problem.

Hi,

No joy still same as before

G

OK, well I don't know of any issues with this happening...so..I am probably about to insult your intelligence...
I apologize in advance

Is there a Scroll bar at the botton of your Database Object WIndow? Is it possible the tables are just off screen?
Also, in the Original XP version, were the tables linked to another DB or BackEnd version? If so can you relink them?

Also, did you Compact and Repair the new DB's? If all else fails, go back to the original and Compact & Repair then
convert.

Other than that, you can post your original XP and new 03 & 07 versions for someone to take a look at.....

Hi,

I'll let you off for insulting my intelligence but also give you a laugh at the same time.

Previously i was going to put the database on a shared drive on the office pc so others could access it. I made the table a hidden object.

I have taken off office 2007 and office 2003 and gone back to office xp (2000? the original version used to create the database) Once the database was opened (as I had a backup file that was not converted to another version) I was able to go to options and select the view tab and check show hidden objects.

The table was now visible. Phew!!

Great I thought, saved database and put onto other machine that was running office 2007. Now again I cannot see the table.

I have gone through the commands that can be added to such as show, view, options etc etc but none seem to allow me to view the table.

Where do I go from here?

G

If you open the XP DB on an 07 machine and do NOT convert it, does it give you the same problem?
After you moved/converted the DB did you go back into Tools/Options/View and make sure Hidden Objects was
checked?


Put the XP DB that shows the table in a location accessible by the 07 machine, open the DB and in the Tables window, right click and try to import the table from the XP DB.

That is all I can think of. I'll look up some things to see if I can find any known issues with this.

Found this with a Google Search of your situation, not sure if it would fix the problem or not, but it's probably
worth a try...