SQL Server isn't supported on a compressed drive, so foxpro probably shouldn't be on a compressed drive either.
http://blogs.msdn.com/sqlblog/archive/2006/10/02/SQL-Server-databases-are-not-supported-on-compressed-volumes.aspx You may be able to copy off the database onto a non-compressed drive. --- On Mon, 12/1/08, Jeff Johnson <[EMAIL PROTECTED]> wrote: > From: Jeff Johnson <[EMAIL PROTECTED]> > Subject: Re: File Access Denied Question > To: [email protected] > Date: Monday, December 1, 2008, 9:52 PM > I changed the advanced attribute "compress files" > but I don't know if > that affected anything. It did not change the file access > denied. > > We have full access to everything. > > Ownership has not changed. > > My app has a command window. I walked through the program > in the > command window and no problem. Obviously typing "use > mydbf" in the > command window allows a ton of time to open the dbc. That > is what I am > thinking the problem is. > > USE mydbf && this is where I get the file > access denied > lntemp = mydbf.myfield > > > > Jeff > > Jeff Johnson > [EMAIL PROTECTED] > SanDC, Inc. > 623-582-0323 > Fax 623-869-0675 > > Phoenix Python User Group - [EMAIL PROTECTED] > > Michael Madigan wrote: > > Can you get them to uncompress that directory to see > if that's the problem? > > > > Do you have write permission on the temporary work > areas? > > > > Has the ownership of the files changed? > > > > > > > > --- On Mon, 12/1/08, Jeff Johnson > <[EMAIL PROTECTED]> wrote: > > > >> From: Jeff Johnson <[EMAIL PROTECTED]> > >> Subject: File Access Denied Question > >> To: [email protected] > >> Date: Monday, December 1, 2008, 9:02 PM > >> My application opens up a dbf on a network. The > dbf is > >> contained in a > >> dbc. When I open up the table on a network shared > drive > >> and the dbc is > >> not opened it normally opens up when you open the > table and > >> does not > >> cause any problems. > >> > >> My customer compressed all of the files on their > network > >> drive. This is > >> a major corporation that contracts with a major > computer > >> company for > >> their IT support. > >> > >> The problem is now when my application opens up > the table I > >> am getting a > >> file access denied message. If I go into the > application, > >> open the dbc > >> and then open the table; there is no problem. > >> > >> I haven't had a chance to open the database in > the app > >> to try it yet. > >> That will be kind of involved. But I was > wondering what > >> you folks felt. > >> Could it be a timing issue? > >> > >> Any other ideas? > >> > >> -- > >> Jeff > >> > >> Jeff Johnson > >> [EMAIL PROTECTED] > >> SanDC, Inc. > >> 623-582-0323 > >> Fax 623-869-0675 > >> > >> Phoenix Python User Group - > [EMAIL PROTECTED] > >> > >> > >> _______________________________________________ > >> Post Messages to: [email protected] > >> 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/[EMAIL PROTECTED] > >> ** 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. > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[EMAIL PROTECTED] ** 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.
