StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Access 2007 & Concurrency

Access 2007 & Concurrency

Crones — Thu, 03 Apr 2008 12:43:04 GMT

I need help trying to figure out why the StrataFrame concurrency exception is not thrown when using a Microsoft Access 2007 database.
I've checked and double checked my settings... When I apply the same thing to an SQL Server everything works fine... Any ideas?

Attached is a sample project with the settings I am using.

RE: Access 2007 & Concurrency

Trent L. Taylor — Thu, 03 Apr 2008 12:43:04 GMT

[quote]

Thanks for the help Trent & Edhy Rijo. Much appreciated.

[/quote]

No problem :)

RE: Access 2007 & Concurrency

Trent L. Taylor — Thu, 03 Apr 2008 12:42:46 GMT

[quote] So far with the help of SF I am doing pretty good with this project and I am sure many things will have to be re-written after the training , but for now, just trying to keep things put and getting ready for the training.[/quote]

Well, I can already tell you that you will end up on top of things and be successful with your application. You have an open mind and are willing to learn and adopt new things and techniques. This is how you get on the top of the pile!

We live in a continuously changing business and we too are always learning better and more efficient ways to do things...so we refactor our code very often as well.

RE: Access 2007 & Concurrency

Crones — Thu, 03 Apr 2008 11:01:37 GMT

Thanks for the help Trent & Edhy Rijo. Much appreciated.

RE: Access 2007 & Concurrency

Edhy Rijo — Thu, 03 Apr 2008 10:40:38 GMT

[quote]

Regardless of the database, row versioning is always the best method as the query is far less complicated than when using all fields. This is actually a section that we cover during training and show the massive differences between using row versioning and any other type of checking.

[/quote]

Trent,

Thanks for the info. I am sure I'll have a lot fun in the training with all the material to cover. So far with the help of SF I am doing pretty good with this project and I am sure many things will have to be re-written after the training :D, but for now, just trying to keep things put :P and getting ready for the training.

RE: Access 2007 & Concurrency

Trent L. Taylor — Thu, 03 Apr 2008 10:33:29 GMT

[quote]One question, will the Version field be incremented automatically by SF or do we have to update this field in every change of the record to trigger the concurrency rule?[/quote]

It will be auto-managed just as the SQL Server and others do.

[quote]Also what would be the reccomended concurrency rule for MS-SQL2005?
[/quote]

RE: Access 2007 & Concurrency

Edhy Rijo — Thu, 03 Apr 2008 09:53:34 GMT

[quote][b]Trent L. Taylor (04/03/2008)[/b][hr]The only way that the concurrency will work with Access is by using a row version field. The Optimistic all fields and timestamp options will not work with Access. If you create a row version field and then set the CRUD settings on the BO, it will work. I updated and posted the sample that you had started. When you create the version field, be sure to have all records update with a 0 for teh default value or it will not work. The reason is when you add the new version field it will basically be empty...so it will get overlooked.[/quote]

Hi Trent,

One question, will the Version field be incremented automatically by SF or do we have to update this field in every change of the record to trigger the concurrency rule?

Also what would be the reccomended concurrency rule for MS-SQL2005?

RE: Access 2007 & Concurrency

Trent L. Taylor — Thu, 03 Apr 2008 09:28:57 GMT

The only way that the concurrency will work with Access is by using a row version field. The Optimistic all fields and timestamp options will not work with Access. If you create a row version field and then set the CRUD settings on the BO, it will work. I updated and posted the sample that you had started. When you create the version field, be sure to have all records update with a 0 for teh default value or it will not work. The reason is when you add the new version field it will basically be empty...so it will get overlooked.

RE: Access 2007 & Concurrency

Edhy Rijo — Wed, 02 Apr 2008 23:24:08 GMT

Ok, I am able to duplicate your results. Have you tried with OptimisticTimeStamp or OptimisticRowVersion?

My guess is that somehow Access is either not sending the event or SF is not catching it.

RE: Access 2007 & Concurrency

Crones — Wed, 02 Apr 2008 23:18:20 GMT

The steps to reproduce what SHOULD cause an concurrency exception is to start the project, and after the form loads and displays the values, open the database with Access and change the values of the table and save the changes. Then click the save button on the app.

When I do the same steps using SQLExpress, I get the concurrency exception which is what I need to happen.

Thanks for checking it out.

RE: Access 2007 & Concurrency

Edhy Rijo — Wed, 02 Apr 2008 23:00:13 GMT

Hi Crones,

I willing to test your sample project, please post steps to do the same test you are doing.

RE: Access 2007 & Concurrency

Crones — Wed, 02 Apr 2008 20:57:23 GMT

Bump :hehe: