Recent content by sys_analyst47

Dear All, Can someone please elaborate the usage of Compact & close database option. What is happening with me when i select this option from MS Access options so when i close the database my main database is simply deleted and when i don't select compact & close option that's working fine...

Well not a prob if you can't provide your email address. I will revert you tomorrow

May i've your personal email so that once i will go to office i can send you email. I don't have internet in office will send from my office email And in access Options there are record locking option in Access with me its no locks & Shared also tick on open database by using record level locking

That our IT fellow was discussing i remember he said Windows but not to sure which version of Windows. Really i got a shock of my life i am not getting any assistance from anywhere like browsing ...but nothing you atleast provide me some solution .. will try to see in it. And even if as you said...

Yes you got it 100%. Record locking file should disappear well i will try once again tomorrow i am really fade up with that problem my entire project is completed just stuck coz of this. I myself was using the database today & no other user, at that time file got locked i restarted my PC but it...

And if my shared database on my server which can't be restarted then what is the solution i really amazed to see as i myself as a standalone using that and that record locking file was not disappearing & made my database read only. even i but a quit button on my main form so that the database...

Awaiting for your revert

see what is happening i & other users can delete the database (the main shared database) but not the record locking file. I don't understand why is it happening & why my database turn into read only mode when that record locking file is not disappearing after all users logged out.

is there any option for user access in MS access ?? Well I am in bank so network security changing is a huge task. And if you are talking about a user access within the MS access then tell me. Thx for your quick revert

Yes everyone do have read / write & deletion rights.

Dear All, I am facing one trouble which makes my entire project worthless. I have a database in MS Access which i split as a front end & back end. My back end is on shared drive & front end on user pc's. When i am opening my front end let say two users just logged in and both are using...

Dear i stuck in access as just want to convert digits to words i have code which is in module but showing error expecter variable or procedure not in module please reply