creating form results in "access denied" error 1

[kennmurrah]

Greetings ...

I apologize for the elementary nature of this question, but I'm trying to create a form to access a pre-existing Visual Foxpro database which is currently in use by 50 or so users ... I get an "access denied" message which, I assume from my other experimentation, I would NOT get if the database were not in use ...

Since I only need to create a form with "read only" access, is there any way to do so without forcing all users offline?

Feel free to respond with an RTFM answer, but please point me in the right direction in the documentation.

Thanks in advance.

kennM

 

[rgbean]

Unless another application has this database / table open EXCLUSIVE, it would appear you are trying to open it EXCLUSIVE.

In the LOAD() method try:
USE mytable in 0 SHARED
or
USE mytable in 0 NOUPDATE

SELECT mytable

Rick

 

[kennmurrah]

i guess my problem is that i'm trying to create a form using the wizards, and therefore have no way(?) of doing what you suggest ... is there a way to specify NOUPDATE while defining the form in a wizard?

if not, is there a "getting started" tutorial that would help me?

once again, i thank you for your help and beg your forgiveness for these elementary questions ....

kennM

 

[Eguy]

Hi kennmurrah;

For a VFP tutorial go to:

http://msdn.microsoft.com/vfoxpro/technical/training.asp

BTW, there is no such thing as an elementary question, and I have never seen a RTFM answer in Tek-Tips and don't ever expect to see one.

Ed

Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.

 

[Mike Gagnon]

kenmurrah

Can you open the database in the command window (in shared mode) and then can you open table in the command window in shared mode?

OPEN DATABASE myDatabase.dbc shared
USE myTable.dbf shared again in 0

If so, do that before creating your form.

 

[kennmurrah]

well, i THOUGHT it was going to work that way ... but when i saved the form, i got a "file in use ... could not create index" message ...

what do you experts think?

and thanks to all of you for your help this afternoon.

kennM

 

[Mike Gagnon]

keenmurrah

You are most likely creating a new index on a field that didn't originally had one. You need exclusive rights to do that. You may want to try using an existing index at step #3 of the wizard. Or ship that step.

 

[Mike Gagnon]

keenmurrah

You are most likely creating a new index on a field that didn't originally had one. You need exclusive rights to do that. You may want to try using an existing index at step #3 of the wizard. Or skip that step.

 

[kennmurrah]

that did the trick!

thanks to all of you ...

kennM