Last post Jan 15, 2014 07:41 PM by DonnieS
Jan 14, 2014 07:52 PM|DonnieS|LINK
I am on a project to convert a large number of mdb applications as well as some later version applications, the 2010 and 2013 versions to dot net. Can someone point me at documentation on how to read (these are not password protected or anything like that)
the .mdbs and extract the information from them. Thanks
Jan 14, 2014 08:09 PM|hans_v|LINK
You can connect to Access files using OleDb. Note that you can only access the Tables and Queries. You cannot access the forms, reports and Modules.
Jan 14, 2014 08:39 PM|DonnieS|LINK
Thanks - that should get me started. I have a problem with "cannot access" lol, got to find a way to do get the forms, reports and modules.
Jan 15, 2014 04:52 AM|hans_v|LINK
I have a problem with "cannot access" lol, got to find a way to do get the forms, reports and modules.
Forms, reports ans modules are meant to be used in an Access Environment (you need ACCESS or the ACCCES runtime), and CANNOT be used in a ASP.NET environment (you CANNOT use Acccess or the Access runtime in a web environment). So why do you want to access
Jan 15, 2014 06:15 AM|DonnieS|LINK
Hans, because I am converting these mdb apps to asp.net C# and need to be able to list out what controls are being used in each form and report.
Jan 15, 2014 02:59 PM|hans_v|LINK
need to be able to list out what controls are being used in each form and report.
And why can't you do that in Access?
Jan 15, 2014 03:12 PM|DonnieS|LINK
Because I want to use C# to do it.
Jan 15, 2014 04:56 PM|hans_v|LINK
If you insist.... The only way you can access those objects is to use the Microsoft.Office.Interop.Access assembly. But read this before you do!
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit
unstable behavior and/or deadlock when Office is run in this environment."
Jan 15, 2014 07:41 PM|DonnieS|LINK
Hans, thanks so much, we are trashing these MS Access apps when we complete the conversion to dot net so we are ok. And these will be opened read only - we wont be changing anything.