Re: commit or rollback a transaction without first beginning a transaction
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/24/05
- Next message: Allen Browne: "Re: HELP NEEDED WITH AUDIT TRAIL"
- Previous message: Philip: "RE: upgraded to money 2004 to windows xp. Error (available only to .."
- In reply to: david epsom dot com dot au: "Re: commit or rollback a transaction without first beginning a transaction"
- Next in thread: david epsom dot com dot au: "Re: commit or rollback a transaction without first beginning a transaction"
- Reply: david epsom dot com dot au: "Re: commit or rollback a transaction without first beginning a transaction"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 09:50:35 +0800
Graham looks like he is on track for trouble-shooting this particular issue
for you.
The particular problem I was referring to is discussed in this thread:
http://groups-beta.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/7c7c883f2d5e2af5/9ef472d3db4c52a3?q=dbEngine(0)(0)+group:microsoft.public.access.*+author:Allen+author:Browne&_done=%2Fgroups%3Fas_q%3DdbEngine(0)(0)%26num%3D50%26scoring%3Dr%26hl%3Den%26ie%3DUTF-8%26as_epq%3D%26as_oq%3D%26as_eq%3D%26as_ugroup%3Dmicrosoft.public.access.*%26as_usubject%3D%26as_uauthors%3DAllen+Browne%26lr%3D%26as_qdr%3D%26as_drrb%3Db%26as_mind%3D1%26as_minm%3D1%26as_miny%3D1998%26as_maxd%3D23%26as_maxm%3D12%26as_maxy%3D2004%26safe%3Doff%26&_doneTitle=Back+to+Search&&d#9ef472d3db4c52a3
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:e%23FyVTgGFHA.1172@TK2MSFTNGP12.phx.gbl... > Although I know that dbEngine(0)(0) may not be CurrentDB > (because the CurrentDB has been loaded after another DB), > I am not aware of a situation where dbEngine(0) is anything > other than the default workspace. Might it happen using > the new feature which allows you to change workgroup from > within Access? > > This is partly old (Access 2.0) code, so there a couple > of things we would probably do differently now, but I > don't know of any way to refer to the default workspace > other than Application.dbengine(0) > > > "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message > news:eBBN3zVGFHA.392@TK2MSFTNGP14.phx.gbl... >> David there are some quite strange things that can happen if you are >> opening separate database or workspaces and running transactions. >> >> It is quite possible that dbEngine(0)(0) is no longer the default >> database after this kind of operation, i.e. Access may reassign them in a >> different order, so the default workspace could become dbEngine(0)(1) for >> example. >> >> May not be related to the issue you are describing, but thought you would >> like to be alerted to the possibilty. >> >> -- >> Allen Browne - Microsoft MVP. Perth, Western Australia. >> Tips for Access users - http://allenbrowne.com/tips.html >> Reply to group, rather than allenbrowne at mvps dot org. >> >> "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message >> news:e4crgEUGFHA.3908@TK2MSFTNGP12.phx.gbl... >>> ...Links (to separate databases >>> 'for each 'Set' statement) have the same problem as local tables.
- Next message: Allen Browne: "Re: HELP NEEDED WITH AUDIT TRAIL"
- Previous message: Philip: "RE: upgraded to money 2004 to windows xp. Error (available only to .."
- In reply to: david epsom dot com dot au: "Re: commit or rollback a transaction without first beginning a transaction"
- Next in thread: david epsom dot com dot au: "Re: commit or rollback a transaction without first beginning a transaction"
- Reply: david epsom dot com dot au: "Re: commit or rollback a transaction without first beginning a transaction"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
