Re: Can't create ADP database on MSDE using MS Access
From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 07/22/04
- Next message: MCB: "Re: Scan to detect objects not in use?"
- Previous message: Chris Mills: "Re: "Help topics not available" error in Access 2000."
- In reply to: Lou Arnold: "Can't create ADP database on MSDE using MS Access"
- Next in thread: Lou Arnold: "Re: Can't create ADP database on MSDE using MS Access"
- Reply: Lou Arnold: "Re: Can't create ADP database on MSDE using MS Access"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 23:32:16 +1000
See comments in-line.
(note that I use Win2K Server as DC so this may not be correct for you.)
-- HTH Van T. Dinh MVP (Access) "Lou Arnold" <Lou_Arnold@nospam.com> wrote in message news:40ff516b.8816537@nntp.flfrd.phub.net.cable.rogers.com... > I can't seem to create an ADP Project database on MSDE using MS > Access. I get no error messages, but no database is created and I > can't create tables using MS Access. > > I've tried the SQL Server group but they can't solve it. > > Please don't suggest alternative tools for creating a database. The > objective is to use MS Access. > > Symptoms: > Using the MS Access SQL Server Database Wizard seems to work until the > progress bar appears showing progress in the database creation. > However, this progress bar appears only for a split second and we've > verified that the database has not been created in the sql server. > There is no error message from Access. > > Some details: > 1) This is all done on one Win2K machine. The server is MSDE2000A and > MS Access is at SP3. > 2) File and Printer Sharing and Client for MS networks are > enabled. > 3) The MSDE is set for Windows Authentication only, but there is > no domain controller. This is an objective of the test-bed we are > trying to create, although we're not sure we can do this without a > domain controller. TCP/IP and named pipes are enabled, because of a > potential requirement for named pipes if Windows Authentication is to > work. Not sure of the last statement. We use Windows Authentication WITHOUT Named Pipe. > 4) Only the Windows standard "Administrator" account has been > used and that account has the same password as the MSDE SA account. We > thought this would give MS Access all the required permissions under > the BuiltIn/Administrators account on the MSDE. I doubt that very much. "Administrator" and "SA" are still 2 different accounts whether the password is the same or not. Furthermore, "Adminisitrator" would be Windows-authenticated and "SA" SQLServer-authenticated. My feeling is that permission is the problem here because (Windows-local) Administrator may need to have Database Creators permission. The BuiltIn/Administrators generally refer to "Domain Administrators". I am not sure wether you "Administrator" would be considered as a member of Domain Administrators. I would suggest using the Enterprise Manager (note whether you have to sign in as "SA"), remove the Public permission of sample database (either Pubs or NorthWind). Close the EM. Using Administrator, try setting an ODBC Source to one of the sample database and see if it let you access the data (you can use the ODBC-linked Table in Access MDB for testing in the mean time). > 5) As this is a named instance of MSDE, the client and server > network components have been set up to use port 1433. > 6) There is no firewall on the computer. > 7) We are sure the server is running. > > Lou Arnold > Ottawa, Canada. >
- Next message: MCB: "Re: Scan to detect objects not in use?"
- Previous message: Chris Mills: "Re: "Help topics not available" error in Access 2000."
- In reply to: Lou Arnold: "Can't create ADP database on MSDE using MS Access"
- Next in thread: Lou Arnold: "Re: Can't create ADP database on MSDE using MS Access"
- Reply: Lou Arnold: "Re: Can't create ADP database on MSDE using MS Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
