Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / January 2008

Tip: Looking for answers? Try searching our database.

MS Access on LAN

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ersinist@gmail.com - 26 Jan 2008 10:42 GMT
Hi mates,

sorry for taking your time, I would like to ask the following
question:

I have created an Access database for keeping trucks of the items in
our inventory and I want to use this database on the LAN of our
company. I have created three user accounts to access the database.
Each user account has its own permissions. Not more than one user is
going to update data on the database at the same time.

The problem is that when I try to open/run the database on another
computer on LAN, the database starts running without asking for a user
name and password. All Computers have MS Access, NTFS file system and
XP. I want to use a PC as a server so that other clients can access
the database on this server and can update the records or can enter
new records in accordance with their permissions. There will be only
three or four users running this database on the network

How can I do that?

All answers related to the topic are welcome, thanks in advance!

Ersin
Douglas J. Steele - 26 Jan 2008 12:19 GMT
It sounds as though you missed one or more steps when securing the database.

Read carefully through the Security FAQ several times, work with a copy of
your application (just in case...) and make sure you don't leave out any
steps.

Since you're not being prompted, I've have to guess that you haven't removed
the Admin user id from the Admins group.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi mates,
>
[quoted text clipped - 20 lines]
>
> Ersin
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.