Re: Can't create ADP database on MSDE using MS Access
From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/24/04
- Next message: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Previous message: Van T. Dinh: "Re: Access XP-Creating a Switchboard"
- In reply to: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Next in thread: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Reply: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 24 Jul 2004 02:21:23 GMT
Thank you, Van. I'm sure its something simple.
>> 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.
This is an ADP project. I dont thonk you can create an MDB project
with SQL Server.
Best wishes in your work, Van.
I will repost in another group with the new information and let's hope
someone else can help.
Lou.
--------
On Sat, 24 Jul 2004 10:11:24 +1000, "Van T. Dinh"
<VanThien.Dinh@discussions.microsoft.com> wrote:
>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
>>
>
>
- Next message: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Previous message: Van T. Dinh: "Re: Access XP-Creating a Switchboard"
- In reply to: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Next in thread: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Reply: Van T. Dinh: "Re: Can't create ADP database on MSDE using MS Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
