Ask a Question related to ASP Database, Design and Development.
-
Laphan #1
Transaction get around in Access and MySQL
Hi All
My apologies, but Bob did actually post me an example of a get around to do
Begin...Commit...Rollback in Access, but I can't find it anywhere. Wife
must have done a cyber spring clean!!!
If you can, could somebody post me examples of how to do this kind of
transaction in Access and for MySQL MyISAM tables (they don't have
transactions either only InnoDB does - I believe).
I know I should be looking at SQL Server or MySQL InnoDB if I want to do
this, but I have to do it in the above and I have a couple of SQL queries
that I think should be covered by the all or nothing transaction policy.
Thanks for any assistance.
Laphan
Laphan Guest
-
Access does not like Mysql
I am having a problem creating Access tables linked to a Mysql database. I get the widow to select a Data Source, click on the (system) DSN I... -
Access to mySQL db
How can I export my access db structure (and query/procedure), and import them to mySQL db? In SQL Server, it has function to 'Generate SQL'. In... -
MySQL to Access!
I now have to change my database from my MySQL to Access. Does it mean a lot? Do I have to do a lot? Can anyone throw light on this issue? ... -
Transaction id and transaction isolation
Hi Two questions. I am using Informix IDS 9.4 on Windows. 1. I would like to be able to get hold of the transaction id while still in the... -
MySQL vs. Access
Which should I use? And is MySQL free? Does it need special software to run? Advantages/disadvantages? And how difficult is it to move everything...



Reply With Quote

