Config File for MS Access 2010 Front end with SQL Backend.
- or -
Post a project like this2718
$$
- Posted:
- Proposals: 2
- Remote
- #1334645
- Completed
Description
Experience Level: Intermediate
I am looking to get a config file produced to allow me to easily connect frontend MS access database to backend SQL on remote server.
Currently, if I move the database from one server to another, I have to recreate the DSN file and use the table link manager to re-link all the tables in the database.
Ideally I would like to distrubute the install file with a config file that has all re-connection info included and avoid having to re-connect the tables manually.
Kindest Regards
Les
Currently, if I move the database from one server to another, I have to recreate the DSN file and use the table link manager to re-link all the tables in the database.
Ideally I would like to distrubute the install file with a config file that has all re-connection info included and avoid having to re-connect the tables manually.
Kindest Regards
Les
Les G.
100% (12)Projects Completed
12
Freelancers worked with
14
Projects awarded
29%
Last project
17 Jan 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi
At the risk of doing myself out of some work have you seen
http://stackoverflow.com/questions/23497584/connecting-to-sql-server-using-access-vba
RoyLes G.25 Oct 2016Hi Roy,
Many thanks for that link. I have done research into this, and I have seen this before.
However, this is beyond my skillset, hence looking for someone that understands it sufficently to complete.
I have also seen this post : https://accessexperts.com/blog/2012/04/04/part-2-linking-tables-using-a-sql-server-table/ which is almost a walk through, but feel it would be better if someone that understands this could do it in a shorter time.
Regards
Les
202493
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies