Visualise locked records per ODBC linkes tables
Fri, 13 Jan 2006 01:54:02 -0800
Hi, I am the first time in this group, my englisg is not perfect ...
I work with an Access MDB included tables via ODBC from a SQL Server 2000.
When 2 or more users try to edit the same record, there is no information,
that another user ia already editing this record (only on recordsaving there
is an error ...
|
Unable to Configure ODBC Drivers
Thu, 12 Jan 2006 17:14:02 -0800
I am using Works 2000. For the last 6 months I have been unable to access my
Calendar for important birthdays etc. I uninstalled the program, leaving the
calendar file alone. Upon reinstalling, I get five error messages.
"Unable to configure ODBC Driver..Microsoft Access Driver (*.mdb)"
-could not load se ...
|
Writing binary ('blob') data to Access with ODBC
Thu, 12 Jan 2006 14:23:53 -0600
Hi all - I'm having some trouble writing long binary data ('blob') to
Access using ODBC. SQLBindParameter is reporting an "Invalid precision
value" between preparing the Insert and Executing it.
Hopefully someone can help?
My code works with ODBC -> MySQL.
I'm using a binary test field of length 262143 ...
|
MS Access ODBC across domains
Thu, 12 Jan 2006 15:07:42 -0500
We've recently had a reshuffle of departments. The SQL databases that access
connected to are now on a separate domain from the access users. Looking for
ideas on how to configure the ODBC's to connect to SQL.
The security folks don't want to use SQL users b/c the passwords are sent in
clear text which is ...
|
Cannot Link to ODBC Database Because Dialogue Disappears
Thu, 12 Jan 2006 13:05:21 -0500
I'm having the same problem experienced by someone in July 2005, which he
stated as follows:
In Access 2003, I am trying to link a table to an ODBC data source.
I click:
"New"
"Link Table"
In the Files of Type dropdown, I select "ODBC Databases()."
At that point, the dialogue simply disap ...
|
Best way to duplicate row of table
Wed, 11 Jan 2006 14:55:45 -0500
Hello group,
I'm trying to create a copy of a record in an SQL Server table that
has an Identity key and string index based on a field, [ID]. I's
using DAO and the code curretly looks something like this:
strSQL = "SELECT * FROM tblX WHERE tblX.ID = '" & myID & "'"
Set RSource = CurrentDb.OpenRecordset(s ...
|
SQL server fields won't update from Access!
Tue, 10 Jan 2006 09:29:01 -0800
Hi folks,
a quick one and any suggestions would be welcome
we have a form with a subform both using Access queries looking at SQL
server linked tables.
The query is definitely updatable (as the tables have unique indexes) and
the query that is the recordsource of the form can definitely be updated when
op ...
|
|
|
Access ODBC HELP!
Tue, 10 Jan 2006 14:54:09 +0100
So I'm under the gun here at work and I can't seem to understand the
cause of my problem. Here it is:
I'm creating a SQL Server database using a web front end. In other
words, users submit information via an Active Server Page and it is
stored in an SQL DB.
Internally, we are using Microsoft Access to quer ...
|
Error Code Zero
Tue, 10 Jan 2006 08:37:38 -0500
I have a Java program that uses the JDBC:ODBC bridge to the MS Access 2000
ODBC driver. The program has worked successfully for months. The only
aspect that has changed is that the database now has about 100,000 records.
Suddenly, the program is getting the following error continually:
SQL: SELECT * FRO ...
|
ODBC Connection fails on XPpro but works on WIN2K and WinXP home
Mon, 9 Jan 2006 06:34:02 -0800
I have a front-end MSAccess database on my local PC, and a back-end mysql
database on a remote linux server which holds the data.
I have installed and configured the ODBC driver on computers running Windows
2000 and Windows XP home edition (using ODBC driver 3.51.11.2-win) and I can
get the database to w ...
|
