If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

[RESOLVED] how to Log In to server as Administrator

I have developed a monitoring system which has VB6 as its front and MS Access as its database

i have saved the Database (.mdb) file into the server's Disks and am using the "\\server\folder\database.mdb" as my connectionstring data source and it works, i can now add, edit, and delete the files in the said Access file using the package i have installed in another computer in the network.

but before i could access the database from the remote computer, i have to log off from the default user of the Computer and log in as an Administrator with the administrator account that i have.

i have noticed in one system that we are using here in our workplace that whenever the other computers are going to use their online file management system, they are prompted to log in as an administrator for that particular program on that session

Re: how to Log In to server as Administrator

i have another user in our LAN which is also an administrator account,

i tried logging in using that user but still, it prompted me that i do not have sufficient permissions to access even though i have activated Full Control in the permission in the Sharing tab for the folder

Database vb error:
"must be an updateable query" etc.

the only user which allowed me to update the database entries was the Administrator account, the main admin acct for all computers in our network

Last edited by vaingelo; May 13th, 2009 at 01:18 AM.
Reason: additional

Re: how to Log In to server as Administrator

Originally Posted by vaingelo

i have another user in our LAN which is also an administrator account,

i tried logging in using that user but still, it prompted me that i do not have sufficient permissions to access even though i have activated Full Control in the permission in the Sharing tab for the folder

Have you tried accessing folder \\server\folder in explorer?
If get the same error or asks for user name and password. There is no proper permission
given the user to access the folder.
I think the mdb file created by administrator.
If are able to access the folder then check permissions granted for mdb file.
You should be able to locate the problem.
Make sure that the common user created in all the systems are of same domain, user name, Password and category.