Only one person open a execl file - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> Only one person open a execl file

Reply

Search this Thread

#1 (permalink)

Old

11-01-07, 13:51

myle

myle is offline

(Making Your Life Easy)

Join Date: Feb 2004

Location: New Zealand

Posts: 1,143

Only one person open a execl file

I have this excel file on the network

it has a Auto_open running a program

is there a way to stop other user from running it

if it already has been open

yes they get the read only message but they can't read

would like a way to stop other user from runing it.

__________________
hope this help

See clear as mud

StePhan McKillen
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment:
Access based on my own environment: DAO3.6/A97/A2000/A2003
VB based on my own environment: vb6 sp5
ASP based on my own environment: 5.6
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
MYLE

Reply With Quote

#2 (permalink)

Old

11-01-07, 18:27

gvee

gvee is offline

www.gvee.co.uk

Join Date: Jan 2007

Location: UK

Posts: 10,156

So what you really have to do is detect whether there is anyone else with the file open or not...

voila!

__________________
George
Twitter | Blog

Reply With Quote

#3 (permalink)

Old

11-02-07, 14:02

myle

myle is offline

(Making Your Life Easy)

Join Date: Feb 2004

Location: New Zealand

Posts: 1,143

Yes george
only cause it Starting Printing a 500 report

__________________
hope this help

See clear as mud

StePhan McKillen
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment:
Access based on my own environment: DAO3.6/A97/A2000/A2003
VB based on my own environment: vb6 sp5
ASP based on my own environment: 5.6
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
MYLE

Reply With Quote

#4 (permalink)

Old

11-29-07, 10:22

Peak Consulting Peak Consulting is offline

Peak Consulting is offline

Registered User

Join Date: Nov 2007

Posts: 20

If you administrate that doc you should be able to put a password on it.

__________________
Peak Consulting - Business Intelligence Experts

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules