This email has been sat in my outbox and I didn't realise it, it was
originally sent about the 25th of August
Very sorry for not replying sooner but we have had a severe lightning storm
which blew out my router and a switch.
It also caused a number of problems for clients and I had to see them to
them first.
Thanks for all the replies, but: when I eventually restarted my computer
the error seems to have gone away.
So much for my help desk answer to most problems which is "have you tried
switching off your computer and restarting it.
I must have left the tables locked somehow and shutting the computer down
released them.
Funny but the server manager did not show the tables as being used.
Eurico Chagas Filho
Hi I can't do that as there are a number of control tables that are always
open in the default work area.
MB Software
I don't use the data environment. The tables sometime have to be moved so I
use a procedure which looks at a table for the location of each table and
loads it.
Then in the load method I issue lines like "OpenDbfs('customer')"
If I have to move the tables I open the location table and from the command
window issue replace location with
StrTran(location,"\\server1\Data\2010","\\server2 Data\2010")
This also allows me to create data folders for different years.
Fred Taylor
That was exactly what I was expecting and in each form that requires to open
a table exclusively I have used Try/Catch to detect if either I have more
than one form open or another user has the table open.
John Weller
If it happens I will try to include that in my error routine.
It's a pity I can't find a way of calculating how many data sessions are
open and then loop through the data sessions and use AUsed()
Tracy Pearson
I have used that before when I had difficulty debugging in the developer
environment.
Set Step on at the start of the main program then do program "The Exe"
That also allows me to skip the screen set up and the set error routine etc.
Allen
I have been using the same basic idea for the past 5 years without any
problems.
But I find it helps when to you want the user to be able to open more than
one form or the same form more than once.
Any way Thanks again
Peter
Peter Hart Computers
www.peterhartcomputers.co.uk
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/001b01cd8a11$3a99af80$afcd0e80$@peterhart.demon.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
