I have just played around with using ODBC and the cursor adapter to connect to a backend server (right now i'm using mysql). as mentioned earlier, my main concern is security of the information stored in the database.

my question is: why is a backend server more secure than the foxpro tables if, when accessing using odbc, you have to input the userid and password to gain access and this information is either stored in a configured dsn or in a foxpro program which is easy to read? now, i did try to access using a dsn under a different operating system account, and i didn't have access to it, so i'm assuming that once you log into your client system, you automatically can have access to the server simply by using a previously configured dsn?

hope this makes sense. still learning the terminology here.

thanks.

paul