[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

there is a window that pops up which looks a little bit like this image in this link,
http://techsalsa.com/wp-content/uplo...gin-screen.gif

, and so they call me to log in the Administrator's account using the same Administrator account that i have.

how do i apply this in my system so that i could access the database from our server?
any help would be much appreciated, thx

Create a common user with same password in all the system which uses your application and server also. Give permission to that user to access your database folder.

Hope this will solve your problem.

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

Quote:

---

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.

thnks,

i have made the right permissions and now, i can access the file

another thing, is there a way for me to make a landscape datareport?

or should i make another thread for this one?

Quote:

---

Originally Posted by vaingelo

thnks,

i have made the right permissions and now, i can access the file

another thing, is there a way for me to make a landscape datareport?

or should i make another thread for this one?

---

1) If your problem solved, mark this thread as resolved.

2) Yes, Post your question in new thread.