Hi,
We a have a small office network of 3 users.
Each user has their own copy of an MS Access Front-End which is linked
via their own local ODBC connection to our server's MySQL database
(Linux Machine)
2 of our 3 users machines can import/link the data back into their
front-ends instantly. The third machines will connect, but it is so
ultra slow that you just cannot import all the tables and use the
forms.
We took their patch cable and connected it to my machine. The data is
instant, so that was not the problem. Their ODBC connection / settings
are exactly the same and work fine.
When we open their front end, select import/link via ODBC, after
selecting the ODBC connection, eventually the tables appear in the
window to select, but even if you select just one table, it takes
about 30 seconds to import/link, and by the sound of it, the pc is
trying to read its disk and then deciding to go via the network to get
the data ??
Has anyone come accross this issue ?. We upgraded their office to MS
OFfice Pro 2003, but this makes no difference.
So, it's not the network connection & it's not the software, what else
would cause this ultra slow data link ?
Appreciate your replies.
Thanks
David
3  1924 
David wrote: Hi,
We a have a small office network of 3 users.
Each user has their own copy of an MS Access Front-End which is linked
via their own local ODBC connection to our server's MySQL database
(Linux Machine)
2 of our 3 users machines can import/link the data back into their
front-ends instantly. The third machines will connect, but it is so
ultra slow that you just cannot import all the tables and use the
forms.
We took their patch cable and connected it to my machine. The data is
instant, so that was not the problem. Their ODBC connection / settings
are exactly the same and work fine.
When we open their front end, select import/link via ODBC, after
selecting the ODBC connection, eventually the tables appear in the
window to select, but even if you select just one table, it takes
about 30 seconds to import/link, and by the sound of it, the pc is
trying to read its disk and then deciding to go via the network to get
the data ??
Has anyone come accross this issue ?. We upgraded their office to MS
OFfice Pro 2003, but this makes no difference.
So, it's not the network connection & it's not the software, what else
would cause this ultra slow data link ?
Appreciate your replies.
Thanks
David
What OS is the slow machine using?
We had a Win98 machine with MyODBC version 2.5x and it took forever to
start up. However, once we upgraded the machine to WinXP (actually - it
was a completely fresh install), and installed the latest MyODBC driver,
the problem went away.
Still don't know what caused it though.
Smitty,
We located the problem.
It was to do with their Local ODBC setup, just ensure you switch Tracing
to OFF !.
I have been trying to fix this problem for weeks now :-)
Thanks again.
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
David Gordon wrote: Smitty,
We located the problem.
It was to do with their Local ODBC setup, just ensure you switch Tracing
to OFF !.
I have been trying to fix this problem for weeks now :-)
Thanks again.
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Argh! I never thought to check that.
Mind you, I doubt that would have been our problem. The users here don't
even know what the close button is. No, really! :)
Thanks for the info though; it will come in handy as another item to
check for. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: *no spam* |
last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:
Access --> New --> Project (Existing Database)
This asks for the name of the .adp file to create and then launches
into the Data Link Properties dialog box (so far so good) I select my
MSDE server from the drop-down, enter the sa account & passwd, attach
a database file and try to...
|
by: Davor |
last post by:
I have to migrate database from AIX DB2 to MS Sql Server 2000. In one
table there is field with GIF image. I have tried with "Import/Export
Data" wizard on SQL server to import that table. All other fields are
successfully migrated except for that field with gif image (I get only
"GIF89A" as value in that field on MS SQL). Also, "Import/Export Data"
wizard on SQL server "sees" that field as LONG VARCHAR???? (isn't this
supposed to be...
|
by: ms |
last post by:
Access 2000:
I am trying to delete duplicate records imported to a staging table leaving one
of the duplicates to be imported into the live table. A unique record is based
on a composite key of 3 fields (vehicleID, BattID, and ChgHrs). VehicleID and
BattID are a TEXT datatype and ChrHrs are a number(long int.) datatype. Since
records to be imported can have duplicate records of the composite key I need to
clean all but one of the...
|
by: Kevin |
last post by:
Hi
I have a table that is imported from excel
the records are updated as required by the user
my question is
Can only the new data entered be appended to the table in access
ie if i update the table in the morning and import 10 records
when i next update the table i want to import only the new data
any help would be welcome
|
by: deko |
last post by:
Is there a way to set a custom property on Access tables and/or queries to
prevent them from being overwritten by import wizards? Any Access database
can be easily destroyed if a user mistakenly imports an object (or Excel
spreadsheet) with the same name as an existing table or query.
Import wizard: "Overwrite existing table/query?"
User: yes
Import wizard: overwrites key table or query
| | |
by: Lorenzino |
last post by:
Hi, I have a problem with bindings in a formview.
I have a formview; in the insert template i've created a wizard control and
inside
it i have an HTML table with some textboxes bound to the sqldatasource of
the
formview.
If i put this textboxes outside the table everything works well, but as soon
as i put them inside the table (in order to organize the layout in the right
way)
they doesn't work. They works only as eval() and not bind()...
|
by: dba123 |
last post by:
I need some help and direction on what classes and an example or two
(article) on how to read an Excel Worksheet and insert one column into a
database table column. I am using .NET 2.0 only. What namespaces and
classes should I use and how?
--
dba123
|
by: afr0ninja |
last post by:
Hello!
I'm fairly new to access, but I'm starting to get the hang of it.
This will be a bit lengthy but hopefully it'll have enough information
for some kind soul to help me out. I'm currently working on a database
where I export data from another program, import the data into access
and then run various queries and what not to generate information
needed for business planning. I can't link directly to the existing
program, so I need...
|
by: NEWSGROUPS |
last post by:
I know that I can import data from my Outlook inbox by going to File -Get
External Data -Import -Select Files Of Type Outlook() etc... using the
wizard but can this be done systemically via VBA code similarly to transfer
text. I actually need to import data from a group account at work. I have
searched hi and low through the Newsgroups and web and have found nothing.
Any help would be much appreciated.
Thanks to all in advance,
Markco
|
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...
|
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...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
