|
by: Maddman |
last post by:
Newbie here.
I've got my database set up in SQL 2000, and have started an Access adp
for a front end. I have 10 licenses, and at the moment the only
accesses are the server through Remote Desktop and one person into the
ADP. I started getting ODBC timeout errors when running a complex
query, so I started poking around. In the logs there's messages saying
the maximum of 10 user connections has been reached, over and over
again. I'm...
|
by: Ellen Manning |
last post by:
Using A2K and adp. Is it necessary to open a connection (to SQL
Server 2000) everytime you call a stored procedure or open a
recordset? Or will opening a connection one time do, like at
Form_Open?
I have a number of combo boxes that call the following public sub when
the NotInList event is fired:
Public Sub InsertItem(strCommandText As String, strParameterName As
String, _
|
by: Jerry Boone |
last post by:
A long time ago Larry Linson (MVP contributor to this group) made a point to
me that mdb's could do anything ADP's (Access Projects) could by using
linked tables to leverage Sql server databases. It's been years since then,
and I still sometimes think about that statement when evaluating the
usefulness of the ADP's I build. Larry and I discussed this technique and
he found it "Credible" (hope you don't mind me quoting you sir) so what the...
|
by: aaron kempf |
last post by:
I find that ADP does not support any Stored Procedures that use the 'CREATE
PROC spHAPPY' syntax.
CREATE PROC syntax is listed in books online.
This syntax should be supported
Here is a scenario:
1) create proc using query analyzer and CREATE PROC spHAPPY syntax
2) open this proc in ADP
|
by: Neil |
last post by:
I have a situation with an ODBC linked view in an Access 2000 MDB with a SQL
7 back end. The view is scrolling very slowly. However, if I open the view
in an ADP file, it scrolls quickly.
I needed to use an ODBC link for the view because it needs to be editable.
Otherwise, I would have used a pass-through query.
In previous discussions about using an MDB file vs. an ADP file as a front
end for SQL Server, the impression I got was that...
|
|
by: VivN |
last post by:
I want to use Access 2000 as a front end to a SQL server database and
have decided that Access 2K project is the way to go. This mean that I
can largely reuse my existing forms and reports (with a bit of
tweaking).
I will need a number of stored procedures to call when processing data
and have some example code using ADO to call these. This code involves
creating a connection object each time, then detroying it when
finished.
My...
|
by: Arno R |
last post by:
Hi all,
I am about to distribute an A97-runtime app. which will be used on a LAN by approx. 30 users.
The network is pretty good, but there are a few managers who have wireless laptops...
Of course they also want to access the db.
I am a bit afraid of possible corruption due to the wireless connections.
==> Do I have to be afraid indeed?
If so, what is the best way to deal with this?
Should I trace the wireless connections...
|
by: TD |
last post by:
Hello All-
We are in the process of converting the back end of our large MS
Access application to PostgreSQL. My question today concerns linked
tables and how their connections are managed by Access. It appears that
Access does a *lot* of connecting and disconnecting to these linked
tables. This is causing me a major headache, as I'd really like to
store some session-based information in the back end that can be
referenced by the linked...
|
by: =?Utf-8?B?TXJOb2JvZHk=?= |
last post by:
Hi, I'm using Sockets classes from this web site:
http://www.adp-gmbh.ch/win/misc/sockets.html
to create a very simple server
Is it possible to limit connections to my server to localhost only? (so not
accept any remote connections)
What would I have to do?
|
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: 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,...
|
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
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...
|