By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,018 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,018 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.