Techware Labs Header

Forums have moved

See this announcement for more details, or just go directly there.

  #1  
Old 12-20-2001, 07:26 AM
Hulaboy
 
Posts: n/a
Default 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.
Reply With Quote
  #2  
Old 12-23-2001, 07:41 PM
Omega Omega is offline
Administrator
 
Join Date: Nov 2001
Location: Minneapolis, MN, USA
Posts: 957
Send a message via ICQ to Omega Send a message via AIM to Omega Send a message via MSN to Omega Send a message via Yahoo to Omega
Default Re: Win NT and MS Access

I'm not sure exactly what you mean, and I'm pretty sure that this isn't your entire question, but I think you can enable the "Guest" account in NT (well, 2k at least).  I'm not 100% sure if by enabling the guest account it will let anyone log on with whatever their username is, but as a guest.  The other thing that I wish 2k and XP had was custom user levels.  I haven't been able to find any way to do that, or make a custom group.

Overall, it sounds like a really complicated question, that I almost assuredly don't have the answer to.  I did read the whole thing though, if that's worth anything .
Reply With Quote
  #3  
Old 12-28-2001, 05:32 PM
Hulaboy
 
Posts: n/a
Default Re: Win NT and MS Access

Thanks for the input Omega!  I also appreciate you reading through all of my gibberish.  Yeah, I do wish NT and 2K did come with some form of a custom type of user setting.  Well, we did activate the Guest account on the server.  We actually thought that might solve our problems during the first round of troubleshooting we did.  No such luck there.    I'm still trying to figure this out and hopefully we'll have a solution before next quarter starts.  Thanks again for the input!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 11:13 PM. Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Forum style by ForumMonkeys.