moving a vfp database

Hi all,

I have created a VFP 8.0 database and tested and application that use it.
Now I want to move to another directory the database. I copied all the data
files, index files, database file to that directory and looks something is
wrong.

open database k:\control\data\mydatabase validate

I got an error " k:\control\data\mydatabase.dbc is an invalid database"

What is wrong??
or what should I do to move a database to another directory?

TIA

Cindy
Mon Jun 18 15:26:25 CDT 2007



"Fanor" <xreed2000@yahoo.com> wrote in message
news:eG$pGMcsHHA.1672@TK2MSFTNGP06.phx.gbl...
> Hi all,
>
> I have created a VFP 8.0 database and tested and application that use it.
> Now I want to move to another directory the database. I copied all the
> data files, index files, database file to that directory and looks
> something is wrong.
>
> open database k:\control\data\mydatabase validate
>
> I got an error " k:\control\data\mydatabase.dbc is an invalid database"
>
> What is wrong??
> or what should I do to move a database to another directory?

Hi Fanor,

Ordinarily, copying/pasting a database in Windows Explorer and all the
relevant DBFs, indexes, etc. from one directory to another is all you need
to do. Be sure none of the files are open when you copy it. Can you still
open your original database without errors? Have you tried making another
copy and opening that? Have you counted the files in both directories to
make sure all the files have been transferred?

--
Cindy Winegarden
cindy@cindywinegarden.com

VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

Fanor
Mon Jun 18 16:02:44 CDT 2007

Thanks Cindy,

I just did that and got the error I mentioned.



"Cindy Winegarden" <cindy@cindywinegarden.com> wrote in message
news:8E951D54-89BA-4B14-9E4E-84A715428C61@microsoft.com...
>
>
> "Fanor" <xreed2000@yahoo.com> wrote in message
> news:eG$pGMcsHHA.1672@TK2MSFTNGP06.phx.gbl...
>> Hi all,
>>
>> I have created a VFP 8.0 database and tested and application that use it.
>> Now I want to move to another directory the database. I copied all the
>> data files, index files, database file to that directory and looks
>> something is wrong.
>>
>> open database k:\control\data\mydatabase validate
>>
>> I got an error " k:\control\data\mydatabase.dbc is an invalid database"
>>
>> What is wrong??
>> or what should I do to move a database to another directory?
>
> Hi Fanor,
>
> Ordinarily, copying/pasting a database in Windows Explorer and all the
> relevant DBFs, indexes, etc. from one directory to another is all you need
> to do. Be sure none of the files are open when you copy it. Can you still
> open your original database without errors? Have you tried making another
> copy and opening that? Have you counted the files in both directories to
> make sure all the files have been transferred?
>
> --
> Cindy Winegarden
> cindy@cindywinegarden.com
>
> VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
> VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
>
>
>
>

Josh
Tue Jun 19 12:02:59 CDT 2007


do you have any stored preocedures or references to external prg's dll's etc?

On Mon, 18 Jun 2007 12:15:13 -0400, "Fanor" <xreed2000@yahoo.com> wrote:

>Hi all,
>
>I have created a VFP 8.0 database and tested and application that use it.
>Now I want to move to another directory the database. I copied all the data
>files, index files, database file to that directory and looks something is
>wrong.
>
>open database k:\control\data\mydatabase validate
>
>I got an error " k:\control\data\mydatabase.dbc is an invalid database"
>
>What is wrong??
>or what should I do to move a database to another directory?
>
>TIA
>

Fanor
Tue Jun 19 13:19:57 CDT 2007

I found the error, for some reason I got one table created in other
directory so when I moved that file to the right place everything works

Thank you so much guys.


"Josh Assing" <XjoshX@jAssing.com> wrote in message
news:q03g73l9367f90f77fucpa298r73f4jia7@4ax.com...
>
> do you have any stored preocedures or references to external prg's dll's
> etc?
>
> On Mon, 18 Jun 2007 12:15:13 -0400, "Fanor" <xreed2000@yahoo.com> wrote:
>
>>Hi all,
>>
>>I have created a VFP 8.0 database and tested and application that use it.
>>Now I want to move to another directory the database. I copied all the
>>data
>>files, index files, database file to that directory and looks something is
>>wrong.
>>
>>open database k:\control\data\mydatabase validate
>>
>>I got an error " k:\control\data\mydatabase.dbc is an invalid database"
>>
>>What is wrong??
>>or what should I do to move a database to another directory?
>>
>>TIA
>>
>