ODBC microsoft access driver login failed
Tue, 4 Oct 2005 08:39:12 -0700
I moved my 401 folder to a new drive. Mapped the path in the odbc data source
to the new drive (E: drive). Open it with excel, but cannot refresh the
datbase. error message:
c:\custom apps\401k.mdb is not a valid path.Make sure the path is spelled
correctly and that you are connected to the server on which ...
|
ODBC and iqy files
Mon, 3 Oct 2005 14:36:20 +0100
I have been using Excel iqy files to query a website and return the results
to Excel, but this can be very time consiming and messy.
Has anybody ever managed to create a link from Access directly to data on a
website.
I really need to send a product ID and get the results in Access e.g. send
http://domai ...
|
SQL Trigger fires, user gets "Data has been changed" error
30 Sep 2005 13:37:25 -0700
I'm using Access XP with linked tables to SQL server (not ADP)
When a user makes a change in an access form, the update is sent to the
SQL server. The server fires off a trigger on update that changes that
data further. When the user tries to re-edit the data, they get an
error message (7878) saying "Data ...
|
Local SQL Server connection string
Thu, 29 Sep 2005 20:05:02 -0700
I use the following connection string in VBA:
Provider=SQLOLEDB;Data Source=_;Persist Security Info=False;
User Id=_;Password=_;Initial Catalog=_;Enable Fastload=True;
Connect TimeOut=0
It works fine except when the data source is the local computer. It has
been working for me in SQL 7 and 2000, but now ...
|
access and sql server via odbc
Thu, 29 Sep 2005 23:37:33 +0800
When writing a pass-thru query in Microsoft Access to access an sql server
via an odbc system dsn, I can write a query like:
select * from MyTable
However, when doing:
select * from MyView
I get an error. Is it not possible to query a view in this manner or is the
syntax different for views?
...
|
Access 2000 to VFoxpro 6.0
Wed, 28 Sep 2005 12:53:07 -0700
Hi,
I have not been able to set up a successful ODBC Connectivity to a foxpro
database on the server. It keeps saying "Reserved Error -7778; there is no
message for this error". Anyone has any idea what is wrong?
Thanks for any suggestion.
...
|
can't connect to Access
Mon, 26 Sep 2005 11:49:34 +0200
Hi,
I try to connect to Access with php with te code below. The database and
table are ok.
<?php
include('../adodb/adodb.inc.php');
$db =& ADONewConnection('access');
$dsn = "Driver={Microsoft Access Driver
(*.mdb)};Dbq=newres.mdb;Uid=Admin;Pwd=;";
$db->Connect($dsn);
.....
I get the error:
Warning: ...
|
|
|
ODBC; docmd.apply filter creates new record after delete
Mon, 26 Sep 2005 15:43:08 +1000
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.ApplyFilter , "idxID= 114"
I start with 16 records: after the 2nd line I have 15 records: after the
third line I have 16 records. Record 114 already exists. idxID is the
primary key Identity (autonumber) field.
The ...
|
Extracting SQL Server data using MS Access / ODBC Timeout
Sun, 25 Sep 2005 21:50:01 -0700
I have a utility I wrote for Access that allows connections to virtually any
database server and extract data. DSN's are not needed as the utility
generates the connection string using parameters stored in the utility.
If I request relatively little data, it works fine. If I request a large
amount of da ...
|
Connect to dBase from VBA
Sat, 24 Sep 2005 13:34:43 -0500
I have a need to connect to dBase IV files that do not have the .dbf suffix.
Does anyone know how to do that using ADO or ? from my Access 2003
application? Thanks.
David
...
|
