Moving data from one table to another in access stopped working

Hi All,

I have the following code. I posted about it yesterday and then found a way to get it working. It worked for a few hours and now doesn't want to play ball, hoping one of you can help me please.

Please Login or Register  to view this content.

The bit of code that doesn't seem to work is the movement from table to table below:

Please Login or Register  to view this content.

It show the below in the immediate box

INSERT INTO [LHR Archive]Select * FROM[LHR Current]

Any help is greatly appreciated.

Thanks.

Thanks. Will try it when i get to work tomorrow. Such a stuoid mistake :/

This still isn't working, I have tried adding the spaces. Are there any other suggestions please?

I worked it out, I had changed some of the field names in the current table but not in the Archive table so it couldn't be moved across. Feel rather stupid for that one!