Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Intermittent error 1705 on CREATE TABLE
Message
De
10/03/2014 13:32:26
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01595953
Message ID:
01596033
Vues:
62
>My first two suspects would be antivirus and/or backup.

I'm already asking them about antivirus. I think I'll check the data I have to see if it's always happening around the same time of day, which might implicate back-up.

Tamar

>
>>I'm running into something weird and I'm out of ideas. This is one of those things that happens only occasionally.
>>
>>As part of a complex process, I create a set of DBFs on the fly. (The simple explanation is that they're an intermediate step between an object model and an XML file.) Every now and then, a user gets error 1705: "File access denied" on the CREATE TABLE command for one of these files. Sometimes, it's for the DBF; sometimes, for the FPT.
>>
>>The files are being created in the user's data folder, which is in the appropriate location (Users\Public\Public Documents\...). I added code last week to make sure the problem wasn't the file already existing; I closed the table, if it was open and then deleted it.
>>
>>Today, the user grabbed a screenshot of the relevant folder after the error occurred and both the DBF and the FPT were there, so it's as if it's creating the table and then having some kind of access problem.
>>
>>There's some code to set this up, but the actual code that's giving the error is pretty simple:
>>
>>
>>SELECT 0
>>CREATE TABLE (m.cTableName) FREE &cColumnSpec
>>
>>
>>And, of course, it's working 99% (actually a lot more) of the time.
>>
>>Any ideas?
>>
>>Tamar
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform