Error "There was an error executing the command"

Question

Hi All,

I am getting this error within my database but only on two forms from the switchboard. Just need to give you more details incase its relevant or not.

So we had a power cut, which effected the pc. When the power returned someone wiped the pc (big mistake) so the pc had to be rebuilt but once this was completed and the database re-installed and it is at this point the database only partly works. Now this database is on numerous pc's and works perfectly fine, the BE is our U:Drive and each pc has a FE on their C:Drive. BUT on this particular pc two forms from the switch board will not open and gives this error.

So far I have re-installed a few times and followed the repair options, I have even opened straight from the U:Drive and it doesn't work! but if I do this on any other pc it will work!

Now our IT dept. are saying they they had to load an older version of Access (2010) and that this could be the issue but some of the other pc has the old version but do not have this problem.

If anyone has any ideas I would appreciate your help..

BR

Jo

Answer 1

One issue I see is that you prompt the user for the table name at runtime.

Hi Scott,

Sorry I not sure what you mean here? Can you give an example please?

BR

Jo

Answer 2

I may have misinterpreted this:

FROM [Enter Talyform Data] INNER JOIN Tolerances ON [Enter Talyform Data].Type = Tolerances.Type

WHERE ((([Enter Talyform Data].Variant)=2))

ORDER BY [Enter Talyform Data].[Date:] DESC;

Is your table/query named Enter Talyform Data or are you prompting the user to enter the table/query name?

Answer 3

Hi Scott,

Enter Talyform Data is the name of the table..

BR

Jo

Answer 4

Ahh OK, my mistake. Usually such an object indicates a prompt.