|
Home > Archive > MS Access Multiuser > May 2005 > ODBC over a LAN?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| SysAdminNewbie via AccessMonster.com 2005-04-28, 3:26 am |
| Hi.
I have a front-end Access (2002) database linked to a mySQL database -
residing on a Local Area Network.
I have set up the ODBC link and, when viewed from the server, I can see all
correct data.
However, when I access the database from another machine on the network, I
can see the front-end database ok but the ODBC connection does not appear
to be working.
Rather than set up ODBCs for each and every user, is it possible to have
one general ODBC (on the server) that everyone can use?
Finally, as mySQL can set users with different permissions, how do I then
prompt each user for their particular (mySQL) username and password when
they attmept to log into the Access database?
Many thanks
SAN
| |
| Van T. Dinh 2005-04-30, 3:27 am |
| Not AFAIK but you can use DSN-less connection. See Douglas J. Steele's
article:
http://www.accessmvp.com/djsteele/DSNLessLinks.html
--
HTH
Van T. Dinh
MVP (Access)
"SysAdminNewbie via AccessMonster.com" <forum@nospam.AccessMonster.com>
wrote in message news:e6b0bb3eda77478
78d05d4c7a5d84db1@Ac
cessMonster.com...
> Hi.
>
> I have a front-end Access (2002) database linked to a mySQL database -
> residing on a Local Area Network.
>
> I have set up the ODBC link and, when viewed from the server, I can see
all
> correct data.
>
> However, when I access the database from another machine on the network, I
> can see the front-end database ok but the ODBC connection does not appear
> to be working.
>
> Rather than set up ODBCs for each and every user, is it possible to have
> one general ODBC (on the server) that everyone can use?
>
> Finally, as mySQL can set users with different permissions, how do I then
> prompt each user for their particular (mySQL) username and password when
> they attmept to log into the Access database?
>
> Many thanks
>
> SAN
| |
| SysAdminNewbie via AccessMonster.com 2005-05-05, 3:24 am |
| I only have 5 users and was kind of hoping that I could set up individual
DNS / ODBCs on each machine to access the front-end database.
However, the linked-tables change everytime I link the front-end database
to a user's DNS / ODBC.
[And as each user has different username / passwords and permissions to the
database, I cannot have one generic DNS / ODBC]
Is DSN-less connection the only way forward?
--
Message posted via http://www.accessmonster.com
| |
| Van T. Dinh 2005-05-05, 7:25 am |
| You can set up ODBC DSN on each user's workstation which I though you are
trying to avoid.
In my case, MS SQL Server Back-End uses the Windows authentication so the
DSN-less connection works fine for all users.
--
HTH
Van T. Dinh
MVP (Access)
"SysAdminNewbie via AccessMonster.com" <forum@AccessMonster.com> wrote in
message news:a82ae75b45c9477
4bb235c9d4f7e8d6c@Ac
cessMonster.com...
> I only have 5 users and was kind of hoping that I could set up individual
> DNS / ODBCs on each machine to access the front-end database.
>
> However, the linked-tables change everytime I link the front-end database
> to a user's DNS / ODBC.
>
> [And as each user has different username / passwords and permissions to
the
> database, I cannot have one generic DNS / ODBC]
>
> Is DSN-less connection the only way forward?
>
> --
> Message posted via http://www.accessmonster.com
|
|
|
|
|