ODBC Refresh Interval
Tue, 25 Sep 2007 18:15:20 GMT
We are using SQL Server as a back end to an Access front end on a LAN using
ODBC linked tables. Users are periodically getting the "data has been
changed by another user" error, and it's causing them to have to re-enter a
lot of data.
The ODBC refresh interval has been left at the default (1500 sec) on all ...
|
odbc timeout using begintrans on linked sql server tables
Tue, 25 Sep 2007 00:32:03 -0700
Hi,
I have two different Access 2003 applications, they both have linked
tables to the same SQL Server 2005 database.
Since my applications often have to perform several related inserts,
updates, I prefer using transactions.
After carefully reading Microsoft sites and Google discussions, I
decided to use the ...
|
Re: difference linking view with file dsn and system dsn
Sat, 15 Sep 2007 00:35:18 +1000
Only if you have directly linked a query.
(david)
"Brian" <s@y> wrote in message
news:efx5TS%238HHA.3400@TK2MSFTNGP03.phx.gbl...
> David,
> Why would I have to refresh the querydef?
> When I change the source of my tables I have never needed to refresh the
> querydefs for my queries (based on tables) to w ...
|
Rowsource for combo box doesn't work anymore
Thu, 13 Sep 2007 19:56:01 -0700
I'm working with ADO for this Access Data Project (ADP), I have a combo box
that fills up with supervisors related to cost centers selected in another
table.
I used to just fill the rowsource with an SQL String on the GOT FOCUS event.
This used to work fine.
I decided to use Transactions with ADO and now ...
|
DSN-Less question:Decyphering ODBC and ACCESS linked tables?
Tue, 13 Mar 2007 14:08:18 -0800
I have a database with about 150 MySQL linked tables, and based on the
perfect code often cited here written by Doug, have two routines which I
can call at will, to change between our production database, and our
testing database. It all works great.
Now I am running some queries based on data that is no ...
|
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting
Thu, 08 Mar 2007 04:07:41 GMT
Search Engine Optimization http://www.yourseoconsulting.com/ Seo Optimization , Semantic Results, Artificial intelligence in Search, Auto Content Generators, Search Engine Results. SEO optimizer. SEO consulting
...
|
^*^*^^*^*^*^^*^*^ Microsoft Vista ^*^*^^*^*^*^^*^*^*^^*
Tue, 06 Mar 2007 03:00:41 GMT
1.01 million is perfect I need the land , I will bleed purple in july and christ help me you hang me out on this one I will do myself.
http://scotiabanksealsthedeal.blogspot.com/
...
|
|
|
Cover up attempt
Wed, 28 Feb 2007 09:28:05 GMT
http://toiletseatcoverup.blogspot.com/ - Yahoo ads not performing well? Publisher profits in the toilet? Join the best affiliate program known to man.
Operation Release the hounds aka puppies.
Snooogy bear is no name for a pet cat.
...
|
A2000 command-line reference needed
Mon, 26 Feb 2007 11:05:32 -0500
Looking for a reference to command-line parameters for Access 2000.
Google did not yield any links.
Thanks. ...
|
DSN-Less connection to SQL Server for Access linked tables
Mon, 26 Feb 2007 04:22:05 -0800
I am looking for simple method of using a DSN-Less connection for SQL Server
tables that I have linked to an Access 2003 Database mdb file through a file
DSN.
The reason I am doing is that, every time I open a realated (to the SQL
server) object in Access. I am prompted with a SQL Server dialog box for a ...
|
