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
Stuart Reid
True nobility lies not in being superior to another man, but in being superior to one’s previous self