Win NT and MS Access
Okay, as I try to wrestle with this bout of insomnia, I would like to pose a question to the database admins and NT gurus. I am working on a project right now. It is a database program that sits on a NT server. This database is implemented through MS Access (don't ask me why the developer decided to go this route). An application sits on the end user's computer and accesses this database...giving information regarding campus life and other interesting tidbits about the school and campus. Upon launching the application, it looks to the database on the server and makes the necessary updates to the local database on the comp. That's all fine and dandy...
My problem is that the program will be able to update the local database from the one located on the server. However, after a couple of moments it would give me some error about how the "Database or Object is read-only" and then the program crashes. I was able to make the program work and I have traced this to the fact that the user has to be in the same domain that the server sits. Also, the end user has to be authenticated on the server as having admin rights. So, basically, in order to make this thing work, I have to map the drive to the server and login as someone having admin rights when the server asks me. If I don't the program starts but gives me that error message and then crashes.
Is there a way of getting anonymous logins in NT with some kind of restricted admin rights? I'm guessing that the solution to this problem would be to install the database onto a Win 98 machine since the only permissions there are either all or nothing. However, I would like to check out if it is possible to do this on a NT system. I know this is the MAIN reason why NT is the way it is. There is no such thing as an anonymous user. You always have to tell NT who you are, right?
Well, I do appreciate if you've made it this far and would greatly appreciate any input anyone might have.
|