A man called r Brick had a firm in the land of Far Away that made bricks.  
Every now and again they would improve their bricks and make them more
versatile so that people with a little training could construct very nice
walls and houses.  Some people who were experts were able to construct all
types of things.  Everyone was happy in the land of Far Away

But what if, thought Mr Brick, we could make a brand new brick that would be
so clever that anyone, even those without any training, could at least make a
wall that would look the part, even if it wasn’t that strong.  It will not
matter as most people just want a wall to stand up they don’t need it to
actually “do” anything like hold up a roof.  

So Mr Brick tried very hard to make his wonderful new brick.  But alas it
would not work and the research was very expensive.  Walls lasted a short
while then fell over.  Some people – the ones who had been expert with the
old brick, were in fact able to make strong walls with the new type of brick.
Well though Mr Brick, here s a great idea, we will sell our new brick to lot
of people and they will tell us what is wrong with them, “they” can do our
research for us – for free, and here is the best bit he thought – they will
pay us to do it for us.  We can then put out a few improvements that people
can use to make the bricks do what they thought they would in the first
place.  And so he started to sell his new Wonder Brick.

Of course they didn’t work very well but it didn’t matter because everyone
who’s wall fell down thought they had built it wrong an it was their fault,
and if only they tried harder everything would be OK.  Only Mr Brick new that
it was really the bricks that didn’t work and sooner or later everyone would
realise this.  As long as enough people told him of their problems he would
have enough free research to “finally” create a brick that would do the job
it was intended for.

Are the query names greater than 64 characters long?  AC2007 will not allow
you to create objects with names > 64 characters. I don't know what happens
if you convert long names from a previous version...

UpRider

On Sep 12, 6:10 am, choosetolaugh
<choosetola...@discussions.microsoft.com> wrote:

Going on the face value of your statement, I would guess that Access
2007 is not happy on your machine. I haven't used 2007 extensively,
but so far have not seen this happen.

Office Suites and Versions when you install "in place" over an older
one or mix versions etc... have been known to break badly.

I would guess from what you say, that this is not a problem with your
files, it is a problem with the Office installation not working
properly on your PC.

Have you tried your data files on another machine, preferably one that
has little history of use and only has Office 2007 on it and no
previous versions?

If your machine is modern and has lots of RAM, you could try running
VirtualPC and a readymade trial Office 2007 vhd and see whether there
is a machine specific problem.

HTH
Ananda

I don't know if anyone has suggested this but have you making sure the palce
you put the datanase you alos placed as in the Trusted Loactions?  Access
2007 will not run code or much of anything for that matter if it's not.