dbf file not a table

After new 2003 server and upgrading to vfp9 dbf files copied to a new folder
can not be opened. Program to copy was written in vfp8 . .dbf was created
in vfp9.
Can not open the file in 8 or 9.
Don't know what the problem.
Have tried setting validation to 0 and open, no luck.
Have tried setting validation to 0 and copying file and then open, no luck.
Don't know what else to try.

Leemi
Fri Aug 04 10:01:21 CDT 2006

Hi Sherry:

Try opening the table in Excel and then saving them as a DBF file.

The tables might truly be corrupt. If so, you need to get a third party
repair tool like this listed in this article:

87688 PRB: "Not a Database File" Error Using a Database File
http://support.microsoft.com/default.aspx?scid=kb;EN-US;87688


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003


>After new 2003 server and upgrading to vfp9 dbf files copied to a new
folder
>can not be opened. Program to copy was written in vfp8 . .dbf was
created
>in vfp9.
>Can not open the file in 8 or 9.
>Don't know what the problem.
>Have tried setting validation to 0 and open, no luck.
>Have tried setting validation to 0 and copying file and then open, no luck.
>Don't know what else to try.

Dan
Fri Aug 04 11:44:48 CDT 2006

What commands did you use to copy the files? Did you copy all the files
(i.e. corresponding index and memo files)?

What error message are you getting?

Dan

sherry wrote:
> After new 2003 server and upgrading to vfp9 dbf files copied to a
> new folder can not be opened. Program to copy was written in vfp8 .
> .dbf was created in vfp9.
> Can not open the file in 8 or 9.
> Don't know what the problem.
> Have tried setting validation to 0 and open, no luck.
> Have tried setting validation to 0 and copying file and then open, no
> luck. Don't know what else to try.

sherry
Fri Aug 04 14:17:02 CDT 2006

The command was copy file c:\<file name> to c:\
Yes I copied all three files.
There was also another different .dbf copied at the same time.It had no
indexes or memos, I copied fine.
thanks
sherry

"Dan Freeman" wrote:

> What commands did you use to copy the files? Did you copy all the files
> (i.e. corresponding index and memo files)?
>
> What error message are you getting?
>
> Dan
>
> sherry wrote:
> > After new 2003 server and upgrading to vfp9 dbf files copied to a
> > new folder can not be opened. Program to copy was written in vfp8 .
> > .dbf was created in vfp9.
> > Can not open the file in 8 or 9.
> > Don't know what the problem.
> > Have tried setting validation to 0 and open, no luck.
> > Have tried setting validation to 0 and copying file and then open, no
> > luck. Don't know what else to try.
>
>
>

Dan
Fri Aug 04 15:03:49 CDT 2006

And my second question? What error message are you getting?

I'm guessing it has something to do with a backlink, but I am literally
guessing because you haven't told us what error message you're getting.

Dan

sherry wrote:
> The command was copy file c:\<file name> to c:\
> Yes I copied all three files.
> There was also another different .dbf copied at the same time.It had
> no indexes or memos, I copied fine.
> thanks
> sherry
>
> "Dan Freeman" wrote:
>
>> What commands did you use to copy the files? Did you copy all the
>> files (i.e. corresponding index and memo files)?
>>
>> What error message are you getting?
>>
>> Dan
>>
>> sherry wrote:
>>> After new 2003 server and upgrading to vfp9 dbf files copied to a
>>> new folder can not be opened. Program to copy was written in vfp8 .
>>> .dbf was created in vfp9.
>>> Can not open the file in 8 or 9.
>>> Don't know what the problem.
>>> Have tried setting validation to 0 and open, no luck.
>>> Have tried setting validation to 0 and copying file and then open,
>>> no luck. Don't know what else to try.

Lew
Fri Aug 04 16:23:21 CDT 2006

Is there a /b binary switch for copy that may be having an effect? copy...
may append a chr(27) to the end of the file, although I don't think this
should make a difference.
-Lew
"Dan Freeman" <spam@microsoft.com> wrote in message
news:%233anaEAuGHA.1512@TK2MSFTNGP03.phx.gbl...
> And my second question? What error message are you getting?
>
> I'm guessing it has something to do with a backlink, but I am literally
> guessing because you haven't told us what error message you're getting.
>
> Dan
>
> sherry wrote:
>> The command was copy file c:\<file name> to c:\
>> Yes I copied all three files.
>> There was also another different .dbf copied at the same time.It had
>> no indexes or memos, I copied fine.
>> thanks
>> sherry
>>
>> "Dan Freeman" wrote:
>>
>>> What commands did you use to copy the files? Did you copy all the
>>> files (i.e. corresponding index and memo files)?
>>>
>>> What error message are you getting?
>>>
>>> Dan
>>>
>>> sherry wrote:
>>>> After new 2003 server and upgrading to vfp9 dbf files copied to a
>>>> new folder can not be opened. Program to copy was written in vfp8 .
>>>> .dbf was created in vfp9.
>>>> Can not open the file in 8 or 9.
>>>> Don't know what the problem.
>>>> Have tried setting validation to 0 and open, no luck.
>>>> Have tried setting validation to 0 and copying file and then open,
>>>> no luck. Don't know what else to try.
>
>

Fred
Fri Aug 04 21:40:30 CDT 2006

This is the VFP COPY command, not the DOS COPY command. There are no
"switches" for VFP COPY FILE.

--
Fred
Microsoft Visual FoxPro MVP


"Lew Schwartz" <lschwartz@sionline.com> wrote in message
news:OhiWUvAuGHA.4648@TK2MSFTNGP04.phx.gbl...
> Is there a /b binary switch for copy that may be having an effect?
> copy... may append a chr(27) to the end of the file, although I don't
> think this should make a difference.
> -Lew
> "Dan Freeman" <spam@microsoft.com> wrote in message
> news:%233anaEAuGHA.1512@TK2MSFTNGP03.phx.gbl...
>> And my second question? What error message are you getting?
>>
>> I'm guessing it has something to do with a backlink, but I am literally
>> guessing because you haven't told us what error message you're getting.
>>
>> Dan
>>
>> sherry wrote:
>>> The command was copy file c:\<file name> to c:\
>>> Yes I copied all three files.
>>> There was also another different .dbf copied at the same time.It had
>>> no indexes or memos, I copied fine.
>>> thanks
>>> sherry
>>>
>>> "Dan Freeman" wrote:
>>>
>>>> What commands did you use to copy the files? Did you copy all the
>>>> files (i.e. corresponding index and memo files)?
>>>>
>>>> What error message are you getting?
>>>>
>>>> Dan
>>>>
>>>> sherry wrote:
>>>>> After new 2003 server and upgrading to vfp9 dbf files copied to a
>>>>> new folder can not be opened. Program to copy was written in vfp8 .
>>>>> .dbf was created in vfp9.
>>>>> Can not open the file in 8 or 9.
>>>>> Don't know what the problem.
>>>>> Have tried setting validation to 0 and open, no luck.
>>>>> Have tried setting validation to 0 and copying file and then open,
>>>>> no luck. Don't know what else to try.
>>
>>
>
>

Mike
Mon Aug 07 03:04:25 CDT 2006

On Fri, 4 Aug 2006 12:17:02 -0700, sherry
<sherry@discussions.microsoft.com> wrote:

>The command was copy file c:\<file name> to c:\
should have <newfilename> ?

Mike.

Lew
Mon Aug 07 07:40:45 CDT 2006

oops!

sherry
Mon Aug 07 12:23:17 CDT 2006

Thank you all
The problem came from the securities set on the new server. This folder was
marked read only. It now works fine .
thanks again
sherry

"Mike McDowall" wrote:

> On Fri, 4 Aug 2006 12:17:02 -0700, sherry
> <sherry@discussions.microsoft.com> wrote:
>
> >The command was copy file c:\<file name> to c:\
> should have <newfilename> ?
>
> Mike.
>