473,839 Members | 1,674 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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
2 4566
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..an d cause nothing but problems...
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pl************* *****@msn.com
http://www.attcanada.net/~kallal.msn
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 ?

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4847
by: mary | last post by:
I am developing an Access db which will be used by multiple users. My questions are: Does MS Access have problems with multiple users accessing the db at once? If yes, what is your solution to this problem? I was informed that Access is not a good application for multiple users accessing it at once.
1
1649
by: isaphrael | last post by:
I have a select query that has a WHERE clause that changes depending on the button that a user presses to search. this is the code that executes everytime one of 3 different search buttons are pressed. Depending on the particular button, the query grabs the info from a different control on a form. This works fine for a single user, but when I tossed it out onto the network and multiple users started using it, they would sporadically...
1
2638
by: dixie | last post by:
I have a .reg file that I need to run across a network. Currently, we run it for each logon on the network manually, which is not really working well as there are over a hundred users and they don't necessarily all use their own machines all the time. How does the system administrator run a .reg file for all users on the network. If this is off topic, could you please direct me to an area where I might get a response. The reason for...
6
539
by: mark | last post by:
I have an asp.net ecommerce web application on a remote web server. I'm using an Access database on the back end. I've notice a few strange things. When I mimic an multiple user environment by surfin it in multiple browsers simultaneously the site generates a generic runtime error after awhile. I'm thinking this has something to do with my access database and multiple connections. I'm using forms authentication with a login page. Is...
14
2965
by: rsbgm | last post by:
Dear ev1, I believe that a server side script for log-in of multiple users is the best solution. I see a lot of javascripts for multiple user log-in in the web. But, I haven't seen a PHP script on that. Can anyone point me to one, please? (I'm still surfing. If anyone can lead me to one, I'd appreciate it.) Also, will the script be a simple file saving type of script or would a database be required for this? Please advise. Lastly, I'd...
0
1729
by: kalinda | last post by:
I am trying to make multiple joins between two tables and am at a loss. I've tried a variety of things with this being the latest, but it pulls all records multiple times. Basically I have a main table of profiles that have several descriptors that are referenced with a SQL ID that is in a DropDown table. Table Profile profiletype (SQL ID) phoneprovider (SQL ID) Table DropDowns ID
7
15046
by: bullfrog83 | last post by:
I have an Access project on a shared network. I found that if a user is already in the app, no one else can access it. How do I allow multiple users to access the app at the same time?
1
1665
by: Dinesh Balani | last post by:
Background: I am currently working a medium scale project to improve the database system at my company. Currently there are 10 different ('97) Access databases which are used by different stations and multiple users. These databases are stored on a shared drive. I'm in the process of converting these DBs, cleaning them up, adding features, and publishing them to the shared folder. Problems: 1) We are interested in better supporting a...
1
1955
by: Nicholas Davenport | last post by:
Hi I hope someone can shed some light on this for me I have been tasked with creating an outbound database system for multiple users. The database will receive a new batch of data on a monthly basis, so I have created an import routine to collect the relevant data that is needed and that works fine. I have created my form that picks up data depending on the criteria from my query. The problem I am experiencing is when multiple users try...
0
9856
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9698
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10910
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10297
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7833
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5683
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5867
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4066
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3136
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.