Tech Off Post

Single Post Permalink

View Thread: Microsoft Access and the new Office 2013
  • User profile image

    Hey Access Experts. Is there any tighter integration between Access, it's Jet Engine and SQL?? I guess what I am trying to ask is SQl 2012 more compatible?? Here is why I am asking. I converted a Access Db to a back end SQl 2008 Db, and there were alot workarounds to making it work effectivly in SQL. I guess one main thing is that the access Jet saves data instantly in a record when you enter data into any field and in SQL, it was updated after the whole recordset was updated. this cause some locking issues. Also, why don't you guys make the data types in access the exact same as in SQL to avoid those problems as well?? after my conversion to the SQl back end, troubleshooting all the quirks between the two was a nightmare!!