Updating SQL table through access
Thu, 29 Nov 2007 07:02:04 -0800
I have a database I upsized on to a SQL 2003 server. I have access as the
front end, I now need to add a field on the access side and transfer it to
sql. It shows up in access under the local table, but not on the SQL table.
How do I make this transfer?
Thanks ...
|
Reading and updating an Sql Server 2005 database from Access 2007
Thu, 22 Nov 2007 21:44:48 +0100
Hi there,
I'm a newbie in Access. I would like to use Access 2007 to connect to a sql
server 2005 database to view and update data in the sql tables. I'm
currently using OBDC to link my "*.accdb" project to the Sql Server 2005
database. The problem is that I have (of course) foreign keys (and therefore
r ...
|
Access 2003 with SQL Server 2005
Wed, 7 Nov 2007 07:05:00 -0800
I have converted and mdb to an adp using the upsizing wizard. There were
multiple problems with queries being converted. If I try to edit a query or
use design view on a table I get messages saying 2003 is not compatible with
SQL 2005 and no changes will be saved.
I tried creating a query in SQL, but then t ...
|
Trap ODBC errors for bound forms
Fri, 26 Oct 2007 14:49:31 -0400
I have found tons of references for trapping errors (and they all use
essentially the same code) but nothing seems to work for a bound form. I
have tried a variety of events. The error seems to be trapped by the form
level Error event but the error collection doesn't contain a description of
the error that ...
|
Access 2003 / SQL 2005 Express low tollerance for poor network?
Wed, 17 Oct 2007 05:32:35 -0700
I recently converted an application that uses Access 2003 for Frontend
and Backend to Access 2003 FE / SQL 2005 Express BE. The tables are
linked with a DSN-less connection via SQL Native Client.
Several Customers use this application and some of them reported a
dramatic increase in connectivity related errors ...
|
"Dynamic cursors not supported by ODBC driver" Error for dynaset recordsets
Wed, 17 Oct 2007 02:14:36 +0530
Platform: Window 2003 Server Enterprise Edition, VC 2005 , ODBC version
3.52, MDAC 2.8, MSAccess2000 database
Hello
In our multithreaded VC++ application, we are accessing certain tables using
CRecordset (with dynaset properties set)
We are facing ODBC related error (for MS ACCESS database) i.e. "Dynam ...
|
ODBC mysql-access slow
Wed, 10 Oct 2007 09:54:52 +0200
I have a data base Access that links to another mysql by
mysql-connector-odbc-3.51.12. If I execute a query by odbc to a table with
1000 records this query takes between 5 and 6 minutes, whereas if I directly
execute it in server it takes less of a second. what I can do so that it is
executed but fast?
...
|
|
|
user id information for logging
Sat, 29 Sep 2007 01:13:00 -0700
I know how to get Windows authentication in .NET... how do you access this
information using ADO (not ado.net)
I want to retrieve user information to log transactions within my
application which is an ADP ...
|
ODBC connect error SQL-HY000
Wed, 26 Sep 2007 12:25:01 -0700
I am calling a perl scrip from my Access database. The perl in turn connects
to the database to write to some of the tables. I get a message that says,
"The database has been placed in a state by an unknown user that prevents it
from being opened or locked."
Does anyone know how I need to set up the databa ...
|
Record changes on a bound form after saving the record
Wed, 26 Sep 2007 14:16:23 +0100
I have an Access 2007 FE database that links to a SQL server 2005 with ODBC
linked tables.For most of the time the database works fine but every so
often things go screwy in one form.
The form uses a filtered record set in a continuous form view and allows the
user to add and edit the records. This will be ...
|
