melands2012
New member
- Local time
- Today, 02:35
- Joined
- Jan 9, 2012
- Messages
- 5
Hi All,
I am trying to connect my access front end to a SQL server 2008 database across LAN for which I will be using windows authentication. My front end is already developed in Access 2003 format.
I can connect to the database from Management studio.
I'm confused by all those methods out there; Adodb, Odbc, and also not sure if I have to use Access data projects instead of simply using .mdb as the front end.
Once the connection is done, I have to keep my frontend in a shared drive and then nearly 10 users will need to get a copy of this front end module on to their computers and will use it to connect to the backend. So I'm not sure where to copy the 'DSN' file if I'm to use one.
Can somebody please tell me which is the best method for me in this situ?

I am trying to connect my access front end to a SQL server 2008 database across LAN for which I will be using windows authentication. My front end is already developed in Access 2003 format.
I can connect to the database from Management studio.
I'm confused by all those methods out there; Adodb, Odbc, and also not sure if I have to use Access data projects instead of simply using .mdb as the front end.
Once the connection is done, I have to keep my frontend in a shared drive and then nearly 10 users will need to get a copy of this front end module on to their computers and will use it to connect to the backend. So I'm not sure where to copy the 'DSN' file if I'm to use one.
Can somebody please tell me which is the best method for me in this situ?
