• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Linking Access Front-Ends to... > Adding User Logins with the OSQL Uti...

Adding User Logins with the OSQL Utility

Users who aren’t members of the local Administrators group of the machine hosting SQL Server don’t have access to the linked databases you created in the preceding sections. When you log on to the front-end .mdb with a non-administrative Windows account you receive an SQL Server “Connection failed” error message (see Figure 19.29, top). Clicking OK opens an inoperative SQL Server Login dialog (see Figure 19.29, bottom). At this point, your only option is to click Cancel to display the original error message, click OK to open the dialog, and then click Cancel again.

Figure 19.29. A user without an SQL Server login receives the following two messages when attempting to open an upsized table or front-end objects, such as queries, that are bound to upsized tables.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint