I want to connect to an Access database located on a server on the Internet.
I have created a DSN on my machine, and used the following code to establsih the connection.

STORE SQLSTRINGCONNECT'DSN=MyDsn') to gnConnHandle
IF gnConnHandle <= 0
= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
return
ELSE
= MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
ENDIF

Is there away that you can specify a timeout on the connection string to the database? At the moment if no connection can be made due to slow access to the internet, the program just hangs.

Is this the best way to do. I want to be able to add,delete and modify data on the database?

Will more than 2 people be able to access the database simultaneously from different machines?

I would really appreciate some help with this

Regards,

Stuart