Error: Operation must use an updateable query

Issue: I get the error message: "Operation must use an updateable query" when I try to create a new patient or save a movie in my Tekscan database.

Solution: This error message: “Operation must use an updateable query” will be displayed whenever the Tekscan software does not have change permission for the Tekscan database file. This database file is an *.mdb file stored in the "Database" folder beneath the "Product Installation" folder. Whenever you create a new patient, or save a new movie to the database, the Tekscan software must make changes to the database file. There are several possible problems that would produce this error message:

1) The database file *.mdb is a read-only file, which is not allowing the Tekscan software to change it. Look for the "Database" folder, which is probably in a subfolder of the program installation folder C:Tekscan...Database. Make sure this entire folder is not checked for read-only in the Windows properties. Sometimes if the "Database" folder is copied to CD and then to another computer, it will retain the Read-Only status that it had on the CD.

2) The database is not marked as Read-Only, but the Windows account used to log onto the Windows XP computer does not have permission to make changes to the database. If you are logged onto the computer with a user account that is in the “Users” group, this would restrict changes on any files that are not in the “My Documents" folder. You must use an account that is part of the “Power Users” group and you must make sure that this user group allows full rights to the C:Tekscan folder and to all of its subfolders. This may also occur if the database resides in a network location that the current Windows user does not have permission to change. You may need to have a network administrator make these changes to the user account.

« Back to the FAQ