472,127 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

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


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

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

Nov 12 '05 #1
2 4442
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......


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
Nov 12 '05 #2
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 ?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by rsbgm | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.