access 07 help

15 pts.
Tags:
Database
Microsoft Access
Microsoft Access 2007
i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help

Answer Wiki

Thanks. We'll let you know when a new response is added.

what ever you want other peoples to do either update or register just share that particular document and then person is through.
note: you must have a software that reguires login and log out okay ?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Joe260986
    i wont users of the database to be able to login and logout i have now made the login form but once they have logged in my switch board comes up so it doesnt really matter who loggs in ..i wont differnt switchboard options for differnt accounts
    15 pointsBadges:
    report
  • Randym
    You can do this a couple of ways. The easiest is to simply show only the buttons for what the user has permissions to. To do that, start out with ALL buttons as invisible. Next create a "SwitchBoard" table that has the "userid" and the "buttonID" that they have permission to. Then on open of the form, read the Switchboard table for the user who logged in and show the buttons he has permission to. To make it easier, the buttons should be named sequentially so that you can make a loop. Ex. Button1, button2, button3, etc. Then you can loop throug the switch board table for that user and make his buttons visible: SwitchBoard table: UserID ButtonID User1 1 User1 3 User2 5 User2 6 Create a recordset on the SwitchBoarad table where the user = the user logged in While not recordset.eof me("Button" & recordset.buttonid).visible = true recordset.movenext Wend
    1,740 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following