So I see that several types of Enterprise Resource Management software use MS SQL Server as their database platform. I was wondering, is it possible to use MS Access to access the database that these programs use the same way that you would access any other MS SQL Server database?
I think what I need to know is, when a piece of software says it is based on the SQL Server database platform, does that mean it stores its data in an MDF file that can be opened the same way as any other SQL Server database? Or is it possible that the database can somehow be encrypted and unable to access from a program outside of the ERP software, even if the programmer owns the ERP Software that created the database?
I thought this wasn't possible until I heard someone say that competing ERP software can convert their competitor's database since they are both based on SQL Server. Is it really that easy and if so how difficult would it be to instead write an Access program to work with the database that my ERP software creates (for example, if I don't like the ERP's front end or I want custom-made modules/features)?
I think what I need to know is, when a piece of software says it is based on the SQL Server database platform, does that mean it stores its data in an MDF file that can be opened the same way as any other SQL Server database? Or is it possible that the database can somehow be encrypted and unable to access from a program outside of the ERP software, even if the programmer owns the ERP Software that created the database?
I thought this wasn't possible until I heard someone say that competing ERP software can convert their competitor's database since they are both based on SQL Server. Is it really that easy and if so how difficult would it be to instead write an Access program to work with the database that my ERP software creates (for example, if I don't like the ERP's front end or I want custom-made modules/features)?
Last edited: