Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem modifying table structure
Message
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:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01361443
Message ID:
01361450
Vues:
16
Make sure the .dbc, .dbt, and .dbx files are not read-only.

>Hello,
>
>I'm having a problem with modifying a table's structure in VFP9 that I've never seen before in 12 years of working with VFP.
>
>I have a database named CCC, and a table in that database called FISCAL. After getting everyone out of that application that uses the database and table AND verifying with the Windows Server tools that nobody has access to the table's files, I issue the following commands in the command window:
>
>OPEN DATABASE CCC EXCL
>USE FISCAL EXCL
>MODIFY STRUCTURE
>
>All three commands execute successfully, and I see the table name, record count and "Exclusive" use status in the bottom of the VFP screen. However, when the table structure window opens, the Insert, Delete and OK buttons are all greyed out, and I can't modify anything in the table structure. In other words, it's behaving as if I don't have the table opened exclusively.
>
>How can VFP allow me to seemingly open the database and table exclusively, but NOT let me modify anything in the table structure? I've never seen this behavior before, so if anyone has any idea how to rectify it, I'm all ears. By the way, I did try rebooting the server that the database and table reside on, and it didn't make any difference.
>
>Thanks,
>
>Ben
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform