Last edited by hanspeterusa 07-10-2013 at 08:30 PM. Unfortunately, our IT HelpDesk has not been very helpful because they claim we are using an "unsupported solution". If anyone has any additional information about this issue, please post. Our concern is that we think Microsoft will make another attempt at pushing this update which will again break our solutions. Transaction (Process ID 66) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. And use just the field itself for those you do want them to edit: SELECT y.ID + 0 AS ID, y.textfield & AS textfield, y. MS Access is a good prototyping tool to impress someone for a RAD and for a departmental database with its own internal tables (the database can be split to create a front-end and a back-end). Use a field expression instead of the field itself for those you dont want them to edit. When attempting an update to a table from SQL Server, for example, we would receive the following error message: You can give the users an Access query to limit which columns they can edit. After the PCs received the security update today, the MS Access solution could no longer perform the updates to any of these ODBC linked tables. Our MS Access solutions perform update queries on linked tables from SQL Server 2008 and also on linked tables from Oracle. We eventually discovered that the problem was caused by the KB2820197 update and everything began to work properly after we uninstalled this update from several PC systems. Inside road.mdb, I have a linked SQL table and the table name is student.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |