I've been designing a database in access for monthes now.
Being close to finished, I began rolling out to multiple workstations when I encountered a new problem I have never seen before.
I will describe, and if possible can someone tell me if it is a problem with Access or Network issues.
Invoicing Program to print cheques:
Workstation 1: The application is asked to print the cheques from the user. Despite having the default printer selected, it says that the printer is unavailable. You have to manually setup the printer. Once this is done it works. If you continue printing cheques the problem doesn't arise untill:
Then you go over to work station 2
Same issue arises, you constantly need to reset the printer to the correct printer. What I find strange is that it says the cheque printer is unavailable yet, if you select it from the list it works fine.
The problem is everytime you use a new workstation to print out cheques it tells you over and over that the printer isn't available forcing you reset the printer options. This is not a viable solution for the common user.
I am hoping that installing the latest service packs will help, if not, i was wondering if there is a piece of code I can insert so that after printing, Access will release the resources?
Please let me know, be a shame if i have to scrap monthes of work for this issue.
Thanks
Jordan
Same issue.
Being close to finished, I began rolling out to multiple workstations when I encountered a new problem I have never seen before.
I will describe, and if possible can someone tell me if it is a problem with Access or Network issues.
Invoicing Program to print cheques:
Workstation 1: The application is asked to print the cheques from the user. Despite having the default printer selected, it says that the printer is unavailable. You have to manually setup the printer. Once this is done it works. If you continue printing cheques the problem doesn't arise untill:
Then you go over to work station 2
Same issue arises, you constantly need to reset the printer to the correct printer. What I find strange is that it says the cheque printer is unavailable yet, if you select it from the list it works fine.
The problem is everytime you use a new workstation to print out cheques it tells you over and over that the printer isn't available forcing you reset the printer options. This is not a viable solution for the common user.
I am hoping that installing the latest service packs will help, if not, i was wondering if there is a piece of code I can insert so that after printing, Access will release the resources?
Please let me know, be a shame if i have to scrap monthes of work for this issue.
Thanks
Jordan
Same issue.