Sharing of single access file on the network

[gaju_3112]

I have created the time booking application in access. (Application will alow autherised user to enter daily work done) My Idea was to put this file on the server and ask each employee to log in and enter information. But whenever I try to run application from other than my pc(On which file is created) it flashes error and can't run some of the form. It works absolutely fine when run from my pc. Why this hapens? What is the solution for this? Can access application is sharebale over network?

 

[KenHigg]

What is the exact error message?

 

[gaju_3112]

Your Microsoft office access database or project contains a missing or brocken reference to the file sapwdctl.dll version 1.0

 

[KenHigg]

Looks like you have a 'references' error. Do a search on that and you should get answers...

 

[gaju_3112]

Means what I have to search?

 

[gaju_3112]

Anybudy have solution for this error? Please reply.

 

[boblarson]

Check this out as it appears to be a MISSING Reference error:

http://allenbrowne.com/ser-38.html

 

[gaju_3112]

Thanks, I found the refernce file. Whenever I copy that file to particular pc, my error get disappeared on that pc. But again new problem is arising. As I told, I am goning to keep application on server and all client pc's are going to use the file. So by this solution I have to copy this file to each and evrey client pc which is practically impossible. What other thing can I do, so that there will be no need to make change on each client PC?

 

[boblarson]

Just remember, if you had to install Office for a user to use it, you had to install it on every computer. Sometimes you have to do that in order to make things work. This may be one of those cases.

 

[gaju_3112]

So copying that file to all pc is the only solution, right? Can we write any error handling code which will automatically copy the file from some specific location to destination location? By doing this we can automize the process of copying the file as per requirement.

 

[boblarson]

So copying that file to all pc is the only solution, right? Can we write any error handling code which will automatically copy the file from some specific location to destination location? By doing this we can automize the process of copying the file as per requirement.

You might but I'm not sure how that would work. I would just make it a prerequisite of using the database and create a self-extracting zip file which someone has to run before being able to use the database for the first time.