Posted June 3, 201312 yr HiIt is possible if we change the dsn of one software that works with Ms.Access to SQL Server?
June 3, 201312 yr There's some differences but it could be worth a try.. http://technet.microsoft.com/en-us/library/cc917601.aspx has some info on it. Looks annoying though.
June 4, 201312 yr Author The software works with Ms Acess Database.I have already done the migration from ms acess to Sql Server.I'm asking if there is any way that this software that have in it's declarations the connection to acess database to connect with sql instead of acess database.The gereral idea is that the software coneccts to sql server and not in ms acess,so i can conect more than one pc to this sql.So increace the number of workstations.
June 5, 201312 yr Sure reverse engineer the database code and see how it's done. If you're lucky SQL is supported and it's just a simple small change. If you're unlucky you might need to do a awful lot of recoding.
Create an account or sign in to comment