Access writing wrong data to spreadsheet
Fri, 18 Jul 2008 09:47:24 -0700 (PDT)
I have a rather strange issue with Access (seems to happen with both
2003 and 2007) and SQL Server. It seems to happen both with Express
(local instance) and Standard over a WAN. The form enables the user
to generate a spreadsheet from select date range. Two things happen
to this user
1. The routine gene ...
|
Detect failed ODBC connection when vpn is not up?
Sat, 5 Jul 2008 23:49:38 -0700
Some users might not have the vpn connected when they start my app...the
odbc timeouts for the passthrough queries on the main form take a long
time (20-30 secs each) to return a failed odbc connection error. Does
anyone know of a quick way to test for an ok odbc connection? So far
I've not seen any differen ...
|
Can't link Access 2007 to Oracle ODBC connection
Tue, 24 Jun 2008 15:40:20 -0500
I'm trying to link to an Oracle table within Access 2007 via an Oracle ODBC
connection but I'm having no luck. The strange thing is I can go into the
ODBC Data Source Administrator in Control Panels->Administrative Tools
and successfully test the connection. However, within Access 2007 when I try
to link to a t ...
|
Problem for changing table link
Fri, 20 Jun 2008 10:24:03 -0700
I am using vista, SQL server2005 and Access2007. I copied an Access database
from my co-worker's computer which works very well there. But on my computer,
when I try to change the table link (select all then check "Always prompt for
new location then click OK), it keep showing me "ODBC call failed". Does
any ...
|
Problem with Microsoft Access ODBC driver.
Thu, 19 Jun 2008 07:53:40 -0400
Hi,
For some reason Microsoft's ODBC driver for MS Access reports an index
for every foreign key that exists on a table.
For example, consider the two tables.
create table parent(id integer primary key)
create table child (cid integer, id integer references parent(id))
For some reason, Access crea ...
|
Cannot Add to query to ODBC linked table if Identity column not sh
Thu, 5 Jun 2008 00:16:01 -0700
Recently had some weird behaviour in Access 2007 SP1 on Windows XP SP2.
Application with odbc linked tables ( SQL SERVER 2005). If I'm showing an
updatable query , linked to a table with an primary key by odbc connection,
and i don't include the primary key field, I cannot add a record! I am able
to do worka ...
|
capitals
Wed, 04 Jun 2008 11:50:34 -0500
This is probably a no-no, but will ask anyway.
I have a query that occasionally people edit data on or enter data
into.
I have a field that I want to always be "caps", if they enter "yes" I
want it to be YES or "no" to be "NO". If this were on a form I can do
a "build event" under code and I have some code ...
|
|
|
Odbc failed when I aggregate data an a slq linked table
Sun, 1 Jun 2008 09:52:08 +0200
Hi, whenever I try to sum data on a sql-linked table from an Ms Access query I get odbc failed error.
Any hint?
Diego
...
|
Connection pooling issue with pass through queries
Sat, 31 May 2008 13:55:06 -0700 (PDT)
I'm creating an MS Access application that connects to a SQL Server
2005 database using pass-through queries and ADO to call stored
procedures. I ran a SQL trace and started clicking through various
forms to look at how things were being handled on the database. I
noticed an alarming number of connections were ...
|
CONVERSAR
Wed, 21 May 2008 19:52:35 -0500
...
|
