Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index problem
Message
From
09/07/2001 11:41:14
 
 
To
09/07/2001 10:44:55
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00528103
Message ID:
00528145
Views:
15
>I have a program that creates a view on a table.
>
> This is a remote view that is based on an SQL server query def. There are two tables involved.
>
> Once the views are created I index one and set a relationship on it.
>
> This is a multiuser environment and the problem is, I create an executable and run it on my machine, everything works fine.
>
> I leave the executable open and fire up another instance of the exe on anothere machine. The views get created, but the index will not work, I get the messsage that this file is in use and that if I try later I may be able to get the file.
>
> The views are created on the local machine, so why is the program not able do the index on another machine?
>
>Can someone help me with this.

Is the database the remote view is created in on the LAN or does a copy exist on each local workstation? If it's on the LAN you are can be getting collisions from more than one user trying to create the view in the database.

Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform