Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why is my database read only?
Message
 
 
To
21/06/1999 18:08:40
Criss Jensen
Injury Prevention Research Center
Iowa City, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00232212
Message ID:
00232255
Views:
20
Well, first of all, you are the only one accessing the tables aren't you? If there is someone else using the tables, you will not get exclusive use. Another thing to try is on the VFP menu, select tools, options, and then click the data tab. Make sure the open exclusive box is checked. However, if you type the commands I gave you below in the command window, those should give you exclusive access. The only other thing I can think of is if your tables are sitting on a network drive that you have read only access to.
Kevin

>Thanks, Kevin but that didn't work. I have been trying to modify using the Modify button in the project manager. Shouldn't that take care of opening the table or database exclusively? I've tried closing the project and re-opening it and immediately trying to modify the database but it still shows that it is read only. Very frustrating! Any other ideas?
>
>
>>Criss,
>>You have to have exclusive use of the tables in order to modify their structure.
>>
>>USE tablename EXCLUSIVE
>>
>>And,in order to modify the dbc
>>
>>OPEN DATABASE dbcname EXCLUSIVE
>>
>>HTH
>>Kevin
>>
>>>I was trying to modify a table in my database but couldn't because it was read only. Then I found that all the tables and the dbc itself were also read only. What is going on and how do I fix this?
>>>
>>>TIA for help,
>>>Criss
Previous
Reply
Map
View

Click here to load this message in the networking platform