I have a program that will have multiple users accessing a database on a server. I'm new to this and have a question about access.

If the database is already in use and another users tries to access it, will it crash my program the same way it does if i try to access a local database that is already in use, or will the server automatically place it in a Q until the database is available.

If the server doesn't handle this issue is there a script i can put in my program to retry access every 10 seconds until its available and not error out.