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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 21:29:11 GMT

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?

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).

2) With another GUI admin tool named MSDE Plus, under the Windows
Admin account, I was also able to create a database.

3) I can connect to these two databases via MS Access and create
tables, again under the Windows Admin account.

4) Can't figure out why MS Access still won't allow creation under the
Win Admin account.

Lou.

BTW: The sample dbs are a separate download for

On Sat, 24 Jul 2004 02:49:56 +1000, "Van T. Dinh"
<VanThien.Dinh@discussions.microsoft.com> wrote:

>If you have the SQL Server B.O.L. (Books-On-Line) which you can download
>from Microsoft Web site, check the T-SQL function PERMISSIONS().
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>
>
>"Lou Arnold" <Lou_Arnold@nospam.com> wrote in message
>news:41013656.1625767@nntp.flfrd.phub.net.cable.rogers.com...
>> OK, well, I can connect to the master DB and it will let me create
>> tables there, but I cannot create a new database.
>>
>> Lou.
>>
>>
>
>

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)
  • 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)
  • 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)