|
-
April 1st, 2006, 04:14 AM
#1
Access and print servers
Hey, whats up. Long time no see... yeah been a few months. So anyway, heres the deal. Working on a project for a local company, and running in to a couple problems that are annoying me. The worst part is, I should know how to fix this, but its been so long that I actually had to do this crap that I don't remember.
Backgroud...
Small company.
1 server (running Win XP Media Center edition.... yeah, not sure about that either).
15 clients (running Win XP home).
A couple weeks ago, they were running a win NT server and Win 98/ME on all the clients, and everything worked fine. They made some updates on the recomendation of circut city, and it caused some serious problems. I ripped out the rest of the Win ME machines yesterday, but still getting a couple problems.
1> MS Access Database. This database is running on the server. It will NOT allow more then 9 clients to connect at once. As soon as a 10th trys to log on, it throws an error about the Jet ODB lock file being locked exlusively by a different machine. Is this a problem with Access or Media Center? I am thinking Media Center has a limit of 10 users logged in at one point (server + 9 clients), but have never touched Media Center before, so not sure. Supposedly they had 12 on it 2 weeks ago (after the new server was installed, but not all the other changes made) but I found a way that they theorically could have done it with 9 and not realized it). To run properly, they need to have 11 machines connect, and ideally 14, but they can run it with 9 and not even realize it unless things get busy. So basically, do I need to change this machine to XP Pro or some other windows server OS (they won't run linux), or is this something that needs to be fixed with access?
2> Okay, they have a bunch of reports in access and some are set to print to certain printers. Is it possible to change what printer they print to? I didn't set up the database, so no clue what reports are where, and the people who did are now someplace in california. Here is the deal. One of the things that gets printed is a check. This automaticaly goes to the check printer. When you try to print to the check printer, it says the default printer (ps3423rfglsf3or/hp1010) can't be found, would you like to use a different printer? (the ps whatever number is the linksys printserver, the hp is the printer) That printer is now at //checkprinter/p1. If you select the checkprinter, it works fine. Here is the thing. If I reconnect one of the ME machines that was set up properly, I don't get the error, but I do under XP. Is there a way to tell XP that //checkprinter/p1 and the pswhatever are the same thing? Or is there a way to tell access that the report should be formated for //checkprinter/p1 instead of the pswhatever thing?
I think I am going to run into another printer problem on a few machines, because I had to use incorrect drivers to get the printers to work, since they never made drivers for XP, but that shouldn't be to bad, I can just tell the people to use default printer for now, and then worry about it later. This other stuff needs to be working before Tuesday afternoon.
Thanks ahead of time
\"Ignorance is bliss....
but only for your enemy\"
-- souleman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|