Record Locks In SQL
Thu, 5 Jan 2006 21:25:01 -0800
Hi
I have an access application with backend in SQL Server. It works fine on
the test environment however on the production server on one Table after
adding a record the record is somehow locked and any attempt to edit it by
anyone results in the "Record has been change by another user since you
started ...
|
cross-post
Tue, 3 Jan 2006 13:43:37 +0530
trying to get a faster reponse.
From: "Ajay Bansal" <ajay.bansal02@gmail.com>
Subject: Problem with like keyword when Access DB is in chinese
Date: Tuesday, January 03, 2006 11:18 AM
Using "like" in my sql statement "select * from table where data like
'%sum%'" or "select * from table where data like '*su ...
|
Replication of Access database w/ linked SQL Server tables
Wed, 28 Dec 2005 11:37:06 -0500
OK, so here's the scenario. I've got an Access application
(MYAPP.MDB) which uses ODBC to link to my SQL server database. MYAPP
only contains VBA code, forms, reports, a couple of utility tables
(e.g. lists of forms) and so forth. So far so good.
I've been copying MYAPP and some associated documents to a r ...
|
Earn money Online - without risk! NO CHAIN - LETTER!!!
Tue, 27 Dec 2005 16:26:57 +0100
Earn money Online - without risk! NO CHAIN - LETTER!!!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often ...
|
Earn money Online - without risk!
Sun, 25 Dec 2005 02:36:18 +0100
Earn money Online - without risk!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often you
salary?
...
|
THE > SUPER-MONEY-SOURCE <
Thu, 22 Dec 2005 18:14:18 +0100
THE > SUPER-MONEY-SOURCE <
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program. Prohibited utilization
leads to the notice!
THE > SUPER-MONEY-SOURCE <
In this program, there is really money.
1200.- Euro / dollar and MORE are in o ...
|
How to change linked table automaticly
Tue, 20 Dec 2005 15:50:37 +0200
Hello
I have an Access (97) database with linked tables to SQL Server with user
'sa' and password 'bla'
I'd like to write a macors to change the user and password for linked
tables to 'user' and password 'nothing'
Could you please provide some exampes , as I would not want to drop the
tables and ...
|
|
|
TimeOut
Tue, 20 Dec 2005 09:12:07 GMT
Access97, Sql Server, Win 2000
I am creating a connection FROM an Acces97 FrontEnd TO an SQL Server
database as follows
NewTableDef.SourceTableName = "xxx"
'ODBC Driver is called JayRemote
ConnStr = "ODBC;DRIVER=SQL Server;SERVER=JayRemote_v2;_
APP=Microsoft Access;DATABASE=cnettestsqldb ...
|
Linking of ORACLE-ODBC-Tables to Access-MDB by VBA-Code fails...
Sun, 18 Dec 2005 22:31:34 +0100
Dear Developers,
My Access-application with ORACLE-8-Database as backend worked since years
without problems. At evry
launch of the MDE it checked the selected ODBC-source and relinked all
needed tables from that source by VBA-Code like:
Dim td As TableDef
set db = CurrentDB
sTable = "Orac ...
|
Lost ODBC drivers
Sun, 18 Dec 2005 11:34:55 +0000 (UTC)
I don't know how but I have lost all the ODBC drivers in the last couple
of days. I have managed to restore MySQL but I cannot get the Microsoft
ones back.
Any help would be very welcome.
Malcolm ...
|
