>>>Dear all,
>>>
>>>Could you please advise how I would be able to know if a file is being used on the network. I have try to open a dbc file but it gives me an error of 'denied...', I would assumed that the file is being used on the network.
>>>
>>>Thanks in advance for your help.
>>
>>You will get better performance and save yourself from this problem by having your DBC be with the exe on the client, not on the server.
>>
>>http://fox.wikis.com/wc.dll?Wiki~CreatingDBCforViews
>
>On a separate note, you should probably be using CursorAdapters for ALL of your queries into remote data. Our systems have passwords to log into our systems, then our systems use an internal system userid and password to connect to the Oracle database. This password can easily be seen in the DCT file.
>
>Step 1: Open the DCT file with the connection as simple text.
>Step 2: Do a search for the UserID that you would use to connect to the database.
>Step 3: Look 8 characters to the right and ignore the first character ('H' ???)
>
>I don't know how this works with SQL Server data, but I am sure if you go through a user id and password type of connection, these steps will tell you exactly where to look for the password. And that password is probably read, write, delete... hmmm might have to try DROP TABLE.
>
>Distribution of the connections off of the network could lead to a security risk.

Good point!