Apparently unreadable form

Questions and Answers about DataEase for DOS

Apparently unreadable form

Postby JohnBaldwin » Wed Jan 15, 2014 10:02 pm

These last few days I have encountered a DfD issue that I do not recall having previously met. However that may well be the fact that anyone still using DfD is quite likely now to have a memory whose functionality is noticeably deteriorating ... and I know for a fact that mine is. I write in the hope of locating someone who is blessed with better memories of DfD issues.

The database which I use every day has suddenly decided that one of my forms is no longer accessible to me. The form is named Timings and when I try to open it to see values, which I have done without problem for at least the past year (and very old ones cleared out when interest in them will not be relevant), now when I try to open it I get the diagnostic "You don't have access to Timings".

Is this possibly because Timings is a 'reserved name' (and if so how was it that I didn't know about it and not had it 'perform' in this manner until very recently)?

Another piece of info is that when I try to write a procedure to list its records as a way of seeing the contents, I get the diagnostic "You don't have access to System" as soon as I click on the form name.

The database is used daily, and records are written to Timings at key stages, and I do want to see the values.

Any idea what is the cause and why it might suddenly have shown its head after months of apparently perfectly satisfactory use and operation?

And I'd also appreciate guidance as to what I would need to do to to get existing data out of the form.

(Whether recent days' worth of production have failed to write records therein has yet to be ascertained. The task for which the database is designed appears to work as previously.)
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Graham Smith » Thu Jan 16, 2014 1:12 pm

It's highly possible that Windows has some kind of lock on the file it won't release. The most direct approach is as follows:

Rename the database directory and create a new one with the name of the old one. Copy everything from the old directory into the new one. Open the database in the new directory and try to open the form. If it opens, then you can delete the old directory and it's contents.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 

Re: Apparently unreadable form

Postby JohnBaldwin » Thu Jan 16, 2014 1:52 pm

Thank you for that suggestion, Graham. I had a feeling that it might just work ... but it didn't.

Any other ideas or suggestions, anyone, please - even Pete (who may know more about what goes on behind the scenes to tell DfD what it is that makes a form appear to be one to which 'the system' only should have access)

John
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Phil Winkler » Thu Jan 16, 2014 2:47 pm

John,

Have you tried to View or Modify the form? Perhaps you can load it and then save it under another name?

Do you own Jada Tools? If so, try reorging the system forms.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby JohnBaldwin » Thu Jan 16, 2014 2:57 pm

Thanks also for that one, Phil.

I must admit that I had wondered whether Jada (which I use with some degree of regularity) might prove to be a way ahead, but its reorganisation of system forms didn't solve the problem.

John
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Phil Winkler » Thu Jan 16, 2014 4:05 pm

I would also try the Forms Troubleshooter in Jada to see what that form looks like in it.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Paul Nelson » Thu Jan 16, 2014 4:13 pm

Hi John

Not a solution to the problem but if you want the data you could use DataGrab.exe.

Paul
Paul Nelson
 
Posts: 71
Joined: Mon Sep 10, 2007 8:30 pm
Location: Leicestershire UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby JohnBaldwin » Thu Jan 16, 2014 4:56 pm

Thanks Paul - that's not something that I've used before, and I'll try that.

Perhaps another thing to throw into the discussion is that when I try listing the forms with Application Status, I get the diagnostic

»»ERROR«« FORM FILE CANNOT BE OPENED, STATUS CODE 9

when it gets that point in the list of application forms.

John
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby JohnBaldwin » Thu Jan 16, 2014 5:55 pm

And what I should have added, in answer to Phil's other helpful suggestion, is that Jada gave no impression that there is any problem with this form.

John
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Phil Winkler » Thu Jan 16, 2014 6:02 pm

Something is corrupt in the rdrr file and I would attempt viewing/editing a copy of it to try and fix the problem. I think Jerry Netherton wrote an rdrr editor, but damned if I can think of the name of it. Let me look in our UTILS folder....nope.
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Fred Kingston » Thu Jan 16, 2014 9:01 pm

You have a backup, right John?

Delete the form, and re-install it from the backup...
Fred Kingston
 
Posts: 281
Joined: Sun Aug 01, 2010 10:54 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby JohnBaldwin » Thu Jan 16, 2014 9:45 pm

Thanks Fred - I'd thought of that too, but it won't allow me even to delete the form!

Have I missed something glaringly obvious?

John
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Fred Kingston » Thu Jan 16, 2014 9:46 pm

Jada will delete the form...
Fred Kingston
 
Posts: 281
Joined: Sun Aug 01, 2010 10:54 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby JohnBaldwin » Thu Jan 16, 2014 10:28 pm

Thanks for that reminder ... and it enabled me to proceed as you outlined.

All OK again, which is a HUGE relief and for which many thanks indeed, Fred (et al). Much appreciated

But can you explain what might have happened and postulate how it happened?

John
John Baldwin (029 2055 4457)
JohnBaldwin
 
Posts: 221
Joined: Wed Sep 26, 2007 8:58 pm
Location: Cardiff, UK
Has thanked: 0 time
Been thanked: 0 time
 

Re: Apparently unreadable form

Postby Fred Kingston » Thu Jan 16, 2014 10:52 pm

No tellin' John... Obviously, the RDRR got messed up... How many forms in the DB, and what number was the form?

Sometimes. it's just easier to whack it, and restore the forms...
Fred Kingston
 
Posts: 281
Joined: Sun Aug 01, 2010 10:54 pm
Has thanked: 0 time
Been thanked: 0 time
 
 
Next

Return to DataEase for DOS

Who is online

Users browsing this forum: No registered users and 2 guests

cron