I am getting ready to do what I realize is probably not the smartest thing. But, I do not have much choice at this point. I have 2 PCs running Win 98 SE (Pentium III-500/256MB memory, with EIDE ULTRA 100 hard drives using EN 10/100 Base T cards). They are networked through a hub (there is a 3rd PC on the network but it doesn't really access the network any). I want to use one as a client and server with the other just being a client. The PC that will be both client and server is not used that much by the user of it, maybe 15% of the day. Will be running an accounting program written in MS Access 97 (the application is huge but the data file, right now, is about 2.5 MB). I realize the application will be on both PCs with the data file on the server. Each PC is in an office next to each other My questions:
1.) What problems could I encounter (besides the obvious of crashing the server easier)
2.) How can I best improve performance, or what is the best way to do this and still operate as if the data file acted like it was on the same PC as the application. I'm worried I'm going to take a big hit doing things this way?
Thanks for you help,