I had an access database where I moved the Tables to a Database I created under my SQL server and then moved the Tables to this Database. I linked them back into My access and all the records, queries and forms work. However i am not able to modify any records. I get a conflict error about changes from another user even though I am the only user. I googled this error and many posts mention that this is an issue with having a Bit type in the table with no default. I checked and found several fields with Bit type so I added the default as 0 but when I try to save the Table I get a message as follows:
Saving the changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option Prevent saving changes that require the table to be re-created.
I am not familiar with SQL too much so any help deciphering this error would be greatly appreciated.
Thanks,
Sam