AYS with multiple users updating a single DB simutaneously

[Guest]

I found a free application on the Web called AT YOUR SURVEY (AYS). It was
designed to run on a single PC. I need to use it in a network environment
with multiple users (front end, FE) answering survery questions at the same
time and storing their answers on a shared server (back end, BE). Anytime
there is more than one user answering questions, all other users are locked
out i.e. FILE IN USE message. Can anyone give me step by step instructions
on how to setup an application like this?

 

[Guest]

Hi Billy,

Are you talking about Duane Hookum's "At Your Survey" (ATS)?
http://www.rogersaccesslibrary.com/OtherLibraries.asp

Have you split the database into a front-end (FE) and a back-end (BE) yet?
If so, have you installed a copy of the FE on each user's local hard drive?

It sounds like the database is being opened in exclusive mode. Do all users
have RWCD privleges for the shared folder that has the BE database? See the
following article for more information:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

Note that for a split database, you should also establish a permanent
connection to the BE database. This is not the cause of your current problem,
but it will help performance significantly.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I found a free application on the Web called AT YOUR SURVEY (AYS). It was
designed to run on a single PC. I need to use it in a network environment
with multiple users (front end, FE) answering survery questions at the same
time and storing their answers on a shared server (back end, BE). Anytime
there is more than one user answering questions, all other users are locked
out i.e. FILE IN USE message. Can anyone give me step by step instructions
on how to setup an application like this?

 

[Guest]

Tom,

Thanks for your help.
Yes, this is Duane Hookum's application.
I will study the article and try it.

Best regards,