Can return ms access RecordsAffected to .net app?

[zerkat]

does anyone know if the MS Access property RecordsAffected can be returned to a .net web app via the OLE DB provider? I know the provider does not support output params but since this is a property I would think it would be accessible. I looked all over the web and could not find a solution. I will also post this on the access forum.

Thanks.

 

[jmeckley]

not sure, but as cautionary advice. MS Access should not be used as a database for web based projects. MS Access is meant as a single to a few user database, Any more and you could run into issues with locking. MS Access also requires the user to have modify folder permissions on the directory containing the database for the locking file.

MS Access doesn't have any concept to indexing, transactions and other "standard" database features.

I would recommend using a different database.
MsSql is most common with .net projects.
SqlExpress is also a good choice. there are some limiting factors, but if you're currently working with Access they are not an issue.
SqLite greate lite weight database for small apps
MySql can be tricky to get working with ADO.Net and with SqlExpress as an option MySql doesn't play a huge role in .net development
Oracle but chances are this is out of the question.

Also if you use an ORM framework like ActiveRecord, NHibernate, LLBL Gen Pro. you can swap databases without changing your code. This is great for moving between development, testing and production environments.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[zerkat]

Thanks for the advice - I understand the problems with Access but I unfortunately don't have a choice in the matter. Maybe I will be able to change someone's mind - if it were up to me I would be doing this in SQL.