Search results

Quick thank you first, chew on it later Sent from my HTC_PN071 using Tapatalk

Still maintain non accessible Mdb is hung up by the OS file sysyem as there is no running recordset, no ldb, nor phantom MS Access at FE or BE: back to square one Sent from my HTC_PN071 using Tapatalk

Doc you may be just right; a dangling recordset is still opened at the front end, will certainly double checked that. HiTechFriend great mind think alike, will double checked it is a recordset not set to nothing. I hope i can see the ldb in the front!!

Rephrasing the problem Whenever a .mdb fouls up eg some unresolved codes in the FE, the task manager show no phantom access running nor is there a .ldb. This happen in xwpin & win7. YET there is no file access to the particular mdb. All other mdbs are not affected. Perhaps something is...

Latest finding When the msAccess FE using a BE .mdb foul up eg some unresolved codes, the task manager does not should that any msAccess is running or any existance of .ldb. YET the mdb that was touched by the FE will have no file access until the PC containing the mdb is relog on.

Dr Yes you double what I found Sent from my HTC_PN071 using Tapatalk

Thank You AGAIN Sent from my HTC_PN071 using Tapatalk

I presume compacting a Mdb to its original name we need to Rename it first & compact the renamed to the original Sent from my HTC_PN071 using Tapatalk

I will certainly look via task manager when it occur, thank you for the kind reminder that points to next action Sent from my HTC_PN071 using Tapatalk

My dear Dr GrandPa All that you say about giving full control for the folder & it content is noted. But i am sure that all FE user has full control as the problem does not happen most of the time. Any way in xpwin the security control is not extensive. As to opening a file exlusively, i...

Thanks friend, will check out your indepth advice. I was using OLD things ie Access in xp office 2002 Sent from my HTC_PN071 using Tapatalk

Late Thanks guy/gal. By the way is there any control that comes with office or window itself that can do the trick.

GREAT, GREAT lesson, i used the set to point to a non linked table.

Hi mates This is need expert inspection. I have a .mdb (access02) serving as the BackEnd in a Server using winxp or win7. At times after a few session using it, i try to compact it but it refused to do so saying that db is used. When the mdb is opened, there is no .ldb file. Any file access...

THANK YOU great guys, short & sweet!

Hi mates I have an existing table with a text field that i want to change its width using vba. Can someone show some codes. Thanks in advance.

Minty i read that some where but in Access 02/03 in the Data Tab there is no Text Format, only controlsource, input mask, default value, validation rules, v txt, enabled, locked, filterlookup. I must gone astray!! I look the table design to find the text format, of course not there, WHERE...

Friends just a quickie on above I have a memo field that i place on a form. How can the form be opened with this field in Rich Text Format on loading? That's it! :o

Thanks Raman From the Text export dialog, all these you mentioned can be set up and it can be saved as SpecName. I do this in Access.02 Text Export Wizard (same in 03 & 07). But in VBA using DoCmd.TransferText, this SpecName can't be used. Moreover the SpecName does not appear as a file that...

PS Solved the append after searching the web; essentially using FileSystemObject > ReadAll() & Write with vCrLf. Questions that remains, how to control the output to the text file especially to items 1. Date export only as short date 2. All strings without extra "" 3. Use different...