How do I kill user connections to an Access Database?

permalink · #10 (**permalink**) 28-Jul-2006, 08:36 AM

How do you see who is logged in? That would work, but i assumed there was no
way to do that. I come from a SQL Server background, so I know the commands
for SQL.

"Albert D.Kallal" wrote:

> Actually, this might sound silly, but the way you do this is to ask all
> users to log out....
>
> You can actually go into the server, and display who has the file opened,
> and actually CHOP the user....
>
> However, doing the above is nearly the same as un-plugging the machine while
> the user is working. So, don't use the file admin tools to chop out users
> that are connected, as you will simply blow out (corrupt) your data file...
>
> Users MUST be shut down in a orderly, and graceful manor, else you risk data
> not being saved, and as mentioned a much worse issue of user damaging the
> data file..
>
> I explain with some nice diagrams as to why corruption will occur if you
> don't allow the user to finish up their writing of data here
>
> http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html
>
> It is also assumed you split your applciation....I expalin this here
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13277-how-do-i-kill-user-connections.html
>
> http://www.members.shaw.ca/AlbertKal...plit/index.htm
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@msn.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
> http://www.members.shaw.ca/AlbertKallal
>
>
>

permalink · #11 (**permalink**) 28-Jul-2006, 08:36 AM

Darren" wrote in message
news:6414BC6D-EA97-42B5-A222-C91167E995A2@microsoft.com...
> How do you see who is logged in? That would work, but i assumed there was
> no
> way to do that. I come from a SQL Server background, so I know the
> commands
> for SQL.

Not a question of is logged in, but WHO has the file opened. Remember we are
taking about a plane Jane file.

We are not taking about ms-access anymore, but simply mdb file sitting on
the disk drive...and who has it open. There is no database server here, but
only windows file system.

So, what happens is often a admin tries to back up a file on the hard disk,
but finds it is opened by someone else (that means the backup software will
usually skip the file). It also means you can't delete, or move the file
while someone else has it opened. So, often a admin will kill that user who
has the file opened.

To see who has a file open (be it a word file, excel file, or mdb file),
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
you go

start->control panel-> Administrative Tools->Computer management

on the left side, you expand the tree item Shared folders, and the highlight
open files...

On the right side, you will see a list of open files....it is also at this
point that over zealous admins kill open files....
(you can right click on any file in the list..and choose close to "CUT" the
connection).

As I mentioned, closing the file is really not different then pulling the
plug on your computer when you have a word document open...the changes never
get back to the disk drive. If you took time to read/view that diagram in
the above wans aritcle, you can see when changes to a ms-access file don't
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
get back to the disk drive, you can damage and currupt data..

The fact that you don't know how to do this is a good thing!!! (cutting
connections to a file while it is open is a bad idea!!).

So, really, at the end of the day, you need users to gracefully exit the
file, and that ensures their changes are written back to disk...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

permalink · #12 (**permalink**) 28-Jul-2006, 08:36 AM

ie kicking them out via a timer_event
(gracefully offcourse)

Pieter

"Albert D.Kallal" wrote in message
news:%23fQ8HVTqGHA.3820@TK2MSFTNGP05.phx.gbl...
> Darren" wrote in message
> news:6414BC6D-EA97-42B5-A222-C91167E995A2@microsoft.com...
>> How do you see who is logged in? That would work, but i assumed there
>> was no
>> way to do that. I come from a SQL Server background, so I know the
>> commands
>> for SQL.
>
> Not a question of is logged in, but WHO has the file opened. Remember we
> are taking about a plane Jane file.
>
> We are not taking about ms-access anymore, but simply mdb file sitting on
> the disk drive...and who has it open. There is no database server here,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
> but only windows file system.
>
> So, what happens is often a admin tries to back up a file on the hard
> disk, but finds it is opened by someone else (that means the backup
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13277
> software will usually skip the file). It also means you can't delete, or
> move the file while someone else has it opened. So, often a admin will
> kill that user who has the file opened.
>
> To see who has a file open (be it a word file, excel file, or mdb file),
> you go
>
> start->control panel-> Administrative Tools->Computer management
>
> on the left side, you expand the tree item Shared folders, and the
> highlight open files...
>
> On the right side, you will see a list of open files....it is also at this
> point that over zealous admins kill open files....
> (you can right click on any file in the list..and choose close to "CUT"
> the connection).
>
> As I mentioned, closing the file is really not different then pulling the
> plug on your computer when you have a word document open...the changes
> never get back to the disk drive. If you took time to read/view that
> diagram in the above wans aritcle, you can see when changes to a ms-access
> file don't get back to the disk drive, you can damage and currupt data..
>
> The fact that you don't know how to do this is a good thing!!! (cutting
> connections to a file while it is open is a bad idea!!).
>
> So, really, at the end of the day, you need users to gracefully exit the
> file, and that ensures their changes are written back to disk...
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@msn.com
> http://www.members.shaw.ca/AlbertKallal
>

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len