Multiple Users & ODBC over a Network......

[David]

Hi,

I have an MS Access database in which the tables have been exported to
a MySQL DB on a Cobalt Qube 3 server and then import linked back into
MS Access. This was all done via an User DSN (ODBC) I created on my
local machine.

I then put my front-end on a shared directory on our network. I have
one other user who needs access. I added a shortcut from this
front-end onto their desktop, but whenever I run MS Access, it says it
cannot connect using the ODBC Connection on their machine ?. I created
exactly the same User DSN (ODBC) connection on their machine with
their Username & Password and tested the ODBC Connection, it connected
fine.

So, when I run MS Access on their machine for the first time, I get
this error, and then the ODBC Panel opens. I then have to re-type
their password, press OK, then I can view all the data in MS Access on
their machine. The problem is that they have to do this everytime they
open the MS Access Front-End. Each of our PC's is trying to connect
using a local USER DSN.

Is their another type of ODBC Connection I should be using to run MS
Access Front End (My SQL Back-End) over a network ?

Appreciate your thoughts

David

[Albert D. Kallal]

I am not really sure what you exact problem is, however, you can not, and
MUST note allow multiple people into that front end.

You need to place that frond end on each pc. You need to do this when:

running a split mdb front end to a mdb back end on a network.

running a FE to sql server, or some odbc database (this is your case).

Further, each users should be getting a mde on their pc's. Again, EACH pc
gets their own front end.

You can run the front end with a dns-less connection if you wish...

Here is a nice link with some sample code......

http://members.rogers.com/douglas.j....LessLinks.html

DO NOT allow multiple users into the front end....you will reduce
reliability..and cause nothing but problems...
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pl******************@msn.com
http://www.attcanada.net/~kallal.msn

[David Gordon]

Hi Albert,

Many thanks for your reply.

I understand what you are saying, but what if each person needs to make
changes to Forms & Queries etc. If each person has a seperate copy of
the front-end there would never be one complete up-to-date copy ?

David
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!