Access and MS SQL ?

J

Josh Grameson

Access 2K.

Using transactions - What are the differeces whether the data is linked to
SQL or access??? Are their things that are supported in one and not the
other, or other differences?
 
D

david epsom dot com dot au

Only very simple, single level transactions are available on linked
ODBC tables. You can't read after you have written, (until the
transaction is completed), and you may get conflicts with any open
forms.

Jet Transactions on ODBC linked tables are irritating, dispiriting,
and have limited functionality.

(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Access & MS SQL server ? 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Adding data to MS Access from csv file 0
MS Project Center-Autolink column fields 0
Keeping Access Running Between SQL Server Reboots 3
Autonumber field in Excel that behaves the same as Access 0

Top