How to prevent multiple connections when using linked tables to SQL server
17 Jan 2006 10:29:37 -0800
Hello,
I have a VB app that tries to read/write data from an access 2002 DB
that has linked tables to a SQL server.
My problem is that my read after the begintrans creates a new
connection (SPID) in SQL server therefore causes an update on an
already locked record. How can I make sure that all my reads a ...
|
How to disable use of Access databases on IIS 4.0
Fri, 13 Jan 2006 05:47:02 -0800
Hello,
We host multiple sites on an NT 4.0/IIS 4.0 server. However, standards
dictate that Access databases are not allowed. Can anyone advise on a method
to disallow/disable the use of Access databases on a web server or from
websites? All the access database files are local on the server.
We have ...
|
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 ...
|
