Re: Can't create ADP database on MSDE using MS Access

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 07/24/04 

Date: Sat, 24 Jul 2004 10:11:24 +1000

See comments in-line. 

-- 
HTH
Van T. Dinh
MVP (Access)
"Lou Arnold" <Lou_Arnold@nospam.com> wrote in message
news:4101626c.8569061@nntp.flfrd.phub.net.cable.rogers.com...
> I'm not sure what it is under permissions that you wanted me to look
> at. I did grant login permission to the master db for  the local
> Windows Admin user (computer-name\Administrator). Should I grant that
> for all dbs  - master, model, msdb, and temp?
>
With the T-SQL PERMISSIONS() function, you can check out which permission
the user (local Windows\Administrator) has.  In particular, you look for the
dbCreator permission (Server Role)
> Notes
>
> 1) Under the Windows Admin account, I can log onto the SQL server with
> osql  -E (trusted connection i.e. Windows Authentication), but not
> thru the SA account.  With osql I was also able to create a database
> (Use Master, CREATE DATABASE mytest).
>
It does sound like the local Windows/Administrator has dbCreator permission.
> 2) With another GUI admin tool named MSDE Plus, under the Windows
> Admin account, I was also able to create a database.
>
I haven't heard of MSDE Plus since I use the EM that does most thing I want.
I does confirm that local Windows\Administrator has dbCreator permission.
> 3) I can connect to these two databases via MS Access and create
> tables, again under the Windows Admin account.
>
ADP or MDB?  It is an improvement, regardless.
> 4) Can't figure out why MS Access still won't allow creation under the
> Win Admin account.
>
Not sure now. My Access installation works every I tried for both  new SQL
Server databases and existing SQL databases.
OTOH, most of my developments are MDBs with JET or SQL Server Back-End.  So
far, I created 1 tiny ADP for actual use and about 10 ADPs for testing only.
Suggest you try the Microsoft Knowledge Base and see whether there is any
bug or needed settings that oare often missed.  The SQL / Access I use are
"default" installation and I don't remember doing any "strange" settings.
> Lou.
>
> BTW: The sample dbs are a separate download for
>

Relevant Pages

  • RE: How can I remove Public access to SQL Express dbs?
    ... To remove the public of a database, we just need to revoke the permission ... By default the SQL Server Management Studio is not available in the ... In the left panel, please click permission. ... it will remove the public access of the database in question. ...
    (microsoft.public.sqlserver.security)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.security)
  • Re: Windows Power User SQL
    ... The guest user must have connect permission in master and tempdb. ... When I run from the master database for example testing against user bill ...
    (microsoft.public.sqlserver.security)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)