Adding records to a table used by asp page.

[inteleserve]

I have a table called usertable that is accessed by a webpage via asp and VFP ODBC driver. I need to have foxpro running in the backgroup putting new records into this table. I can't get it to do this without opening the database as exclusive. But when I do this ... the asp page comes up with a file access error. Is there a way foxpro can insert new data without preventing read/change access from my asp page.

Any sugestions on what to look into..

 

[Mike Gagnon]

I need to have foxpro running in the backgroup putting new records into this table. I can't get it to do this without opening the database as exclusive.

Can you explain why you need to open the database exclusive in order to insert records?


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[inteleserve]

Can you explain why you need to open the database exclusive in order to insert records?

Mike Gagnon


No... I can't, thats the problem ... opening it as exclusive is the only way I know how to insert records. Is there another way to open my dbc and table where I can insert/append etc.. without locking out access to other programs?

Thanks.

-aaron

 

[Mike Gagnon]

Try :

OPEN DATABASE mydatabase.dbc shared
use mytable.dbf shared again in 0
insert into into myTable (name) VALUES ("Mike")

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[JRudisill]

you can also issue:

Set exclusive off

I find that most multi user systems have very few tables that get used exclusively.