I recently shifted all my back end tables of Access to Microsoft SQL Server 2005 keeping front end as is i.e. MS Access. I re-set all tables with a primary key as this is required by each Server table. I used ODBC linked tbl method.
Some table are running without any problem but my sales header and sales footer table don’t run smoothly. I have yes / no type fields in both tables. Initially they also produced problems but I managed to solve it. Now every code line works ok but after opening record set and manipulation, it wont update records and displays below error.
Run-time error ‘3197’
The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
And halts at below line
rst.Update
I don’t have any other user as SQL Server 2005 is installed on my laptop and sa is the only user.
Can you let me know how to come over this problem?
Also I am planning to set one separate high configuration pc for server and like to make different users in future. I hope in that case I have to set the permissions for work stations from server itself and hopefully the above error will not appear then.
But not it appears on my laptop.
Any idea?
Thanks in advance
Ashfaque
Some table are running without any problem but my sales header and sales footer table don’t run smoothly. I have yes / no type fields in both tables. Initially they also produced problems but I managed to solve it. Now every code line works ok but after opening record set and manipulation, it wont update records and displays below error.
Run-time error ‘3197’
The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
And halts at below line
rst.Update
I don’t have any other user as SQL Server 2005 is installed on my laptop and sa is the only user.
Can you let me know how to come over this problem?
Also I am planning to set one separate high configuration pc for server and like to make different users in future. I hope in that case I have to set the permissions for work stations from server itself and hopefully the above error will not appear then.
But not it appears on my laptop.
Any idea?
Thanks in advance
Ashfaque