Closing mdb interfaces ..

[Mr.Access]

Hi Friends,

3 small questions I need your help about ACCESS 2003 :

Note: I'm using a workgroup for users access through the network and the
.mdb located in PC as a server NO Front-end & Back-end .

1. Is there a software that can close the .mdb interfaces or forms in all
users PCs ? for design modification in case of a user left the work without closing the DB.
2. Could the users use the internet OR Intranet for fast or better access to the .mdb ?
3.In case of (Front-end & Back-end) strategy , How can I modify the forms since each user has its own ?


Kind Regards,,

 

[Guus2005]

1. No, not to my knowledge, but you can program it by setting a bit which must be checked by the users database to continue or close the application.
2. Depends how you define "better". Fastest is always local. Have the application on the users PC and it runs very fast. You can't accomplish this using on a network.
3. Easy. Give the users the new FE. Problem solved. The FE connects to the BE (you have to program that). The data is stored on the BE so that is never lost.

Always use FE and BE strategy. Can't think of a single reason why not.

 

[Mr.Access]

Thanks Guus2005 .

Have a look to the link for Ques.1 :

http://www.vb123.com/workbench/

How do you see it ?

Keep in touch ,,

 

[Guus2005]

If you want a quick solution, this might work. However it costs money and it's an application you must rely on. It is safer (and more fun) to do it yourself.
I use ldbviewer.exe to track all the users in the database. Then i use "Net use <compname>, "Would you be so kind to log of, before i log you of" to get everyone out. (They don't know that you can't)

Instead of ldbviewer there is a dll (ldbvwr.dll or something like that) which you can register and use in your database. It's free.

Enjoy!

 

[Mr.Access]

ldbvwr.dll

Nice Guus2005 ..

Regarding to ldbviewer.exe with its package (Msldbusr.EXE & Dblck.exe)

Really it's a simple great idea that i'm already use it but the thing that not included is a small button to Close all users interfaces since a user may left the work for dinner keeping the .mdb opening and even I could know him
How can I close it ? .

Is there a code for doing this ? and what about ldbvwr.dll ?

Many thanks ..

 

[Guus2005]

The msldbuser.exe contains the VB6 code to create the ldbviewer.exe, two sample access databases which also use the msldbusr.dll. After registering the dll you can create your own viewer.

Loose the Dblck.exe!! It is probably not safe. Run a virus check and a spyware check b4 you do anything with it.

I've added my version of the msldbuser and the ldbviewer.exe. Both zipped.
Run virus check and spyware detection tools and enjoy!

 

[Dennisk]

with regards to updating FEs, use an FE loader, that way you drop your updated forms into a network folder and next time a user opens the db the new FE will be copied to the local hard drive. I use one developed in VB6 by one of my collegues. But there is one available from this forum.

 

[edojanssen]

This file could work. It's a FE/BE version but it probably will work in a single mdb too.

 

[Guus2005]

This file could work. It's a FE/BE version but it probably will work in a single mdb too.

It is a nice example!

The same way you can close the database after it is idle for some time. The only thing you have to change is that you have to add a procedure in every mouse move and keyclick events!