Compact error. Error Code 1206. Unrecognisable database format.

[tucker61]

Now and again when updating the vba code i get a unrecognisable database format error - and can see the error is logged in the below table.
Any ideas how I can trace what is causing this error ?
Anyways have backups etc - so able to roll back.

 

[CarlettoFed]

In one or more tables you use Descrition as the field name which is a reserved word, you must change it.

 

[tucker61]

In one or more tables you use Descrition as the field name which is a reserved word, you must change it.

Thanks, i had 2 fields named Description - So have renamed these.

 

[Pat Hartman]

Be careful. Jet/ACE use Description and SQL Server uses Desc as a reserved word. Actually, Newer versions of Access warn you about some reserved words but not all. Ignore these warnings at your peril. Name, Date, Now, Year, Month are the most troublesome but any word which duplicates a function or property name can cause a problem under certain conditions.

Here's a sample database that shows some of the worst effects.

Useful code AND the effects of using bad column names

This database has several useful code procedures that you can copy into your BE to fix up defaults you don't like: 1. Change the allow ZLS string property to No If you want to make a text field required, it makes no sense at all to have the Allow ZLS property set to Yes. 2. Turn off sub...

www.access-programmers.co.uk