I have a very large client who I have written many applications for over the last 15 years. These applications are all FoxPro accessing FoxPro tables. Due to relatively new company policies, this client is being forced to move all data to a more secure environment, namely Oracle (I believe I will have 2 to 3 years to finish this task). I hate to ask what most of you may think is a stupid question... but can FoxPro access and use this data? Is it just an ODBC issue? And if so, does it happen in such a way that will meet their security requirements (I know you don't know what their requirements are, but in general does it keep the data secure)?

I apologize for my ignorance, but I have never needed to do anything other than "USE" to get to my data :) I feel like I am going to be learning a lot of new things in the very near future, so if you can point me in the right direction it will be greatly appreciated.

Thank You