Re: Rights for Access2000 Upsizing-Wizard

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/09/05

  • Next message: Kevin Stough: "Re: Cant create/edit stored procs in VS.Net" 
    Date: Tue, 08 Mar 2005 18:44:19 -0700

    Go into master and execute:
    grant create database to YourUser
    Then go into the database that will be used for upsizing and
    make the user the owner of the database by executing:
    sp_changedbowner 'YourUser'

    -Sue

    On Tue, 8 Mar 2005 06:41:02 -0800, Bernhard Lauber
    <BernhardLauber@discussions.microsoft.com> wrote:

    >Hi Sue
    >
    >Thanks first for your help.
    >
    >The database exists. I droped the user for recreation in master, added the
    >role db_owner and granted create database in master and new db.
    >Still don't work. Any idea? I import just tables, index and relations with
    >DRI.
    >

  • Next message: Kevin Stough: "Re: Cant create/edit stored procs in VS.Net"

    Relevant Pages

    • Re: Replication problems
      ... An error occurred while accessing the DHCP database. ... DHCP server event log for more information on this error. ... browser for the domain on transport NetBT_Tcpip_{99B638B5-2C0B. ... master browser is stopping or an election is being forced. ...
      (microsoft.public.windows.server.active_directory)
    • RE: SQL Server failing to start (directly effecting sales!!!) Error: 823, Severity:
      ... You should consider calling Microsoft Technical Support as your master ... They will want your SQL Server Errorlogs ... that the machine with the database has hardware that is failing. ... Even if you are planning to reinstall you should make a backup copy ...
      (microsoft.public.sqlserver.msde)
    • Re: Table Normalization
      ... To master it requires a great deal more work. ... There are so many categories to work in (database design, queries, forms, ... that they'd flub a number of the answers, ... make the same mistake twice, and they don't let others make the same ...
      (microsoft.public.access.tablesdbdesign)
    • Copy FE of DB when it is already open on the server
      ... I just recently changed my database that I'm running from a monolithic ... They click a shortcut, which used to lead to the old ... network (the master copy that Tony's program copies out to each user) ... by itself (as apposed to putting it in the same folder with the ...
      (comp.databases.ms-access)
    • RE: Multi user database
      ... manner and push updates to the backend. ... the other user updates table c then run the append query. ... Right now I can determine when the master table is updated, ... the database they should 'share' the data not update to/from local copies. ...
      (microsoft.public.access.modulesdaovba)