<mchip@online.microsoft.com> wrote:

>Well, yes, there is hope. Have you searched msdn for KB articles?
>There's quite a bit on problems with Access/SQLS. If the error is in
>the upsizing wizard, start here:
>http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237980
>
>Posting on the access-related newsgroups is also a good strategy.
>You'll need to have the version of Access, adp or mdb, the version of
>SQL Server,which wizard, the error message, etc.
>
>--Mary
>
>On Mon, 26 Jul 2004 21:46:20 GMT, Lou_Arnold@nospam.com (Lou Arnold)
>wrote:
>
>>Ok. You reply is what I expected . There is really no hope of finding
>>out why this wizard fails.
>>
>>We are running MS Access SP4. Is this version new enough to be able
>>to create a database in SQL Server?
>>
>>Lou.
>>
>>On Mon, 26 Jul 2004 14:41:18 -0400, Mary Chipman
>><mchip@online.microsoft.com> wrote:
>>
>>>Generally speaking, Access uses ODBC when connecting from an .mdb, ADO
>>>(OLEDB) when connecting from an .adp. What internal Access code does
>>>when it executes is anyone's guess since it is compiled in the
>>>executable and not available for viewing. And no, you don't need to do
>>>any additional configuration other than have the latest service packs,
>>>patches, etc for the version you are running. Bear in mind that
>>>earlier versions of Access have problems with SQL Server 2000 that can
>>>only be solved by upgrading to a newer version of Access.
>>>
>>>--Mary
>>>
>>>On Mon, 26 Jul 2004 04:52:07 GMT, Lou_Arnold@nospam.com (Lou Arnold)
>>>wrote:
>>>
>>>>The MS Access SQL Server Database Wizard attempts to create a database
>>>>in the SQL server. The question is: does it use ODBC or OLE DB or
>>>>both?
>>>>
>>>>If it uses OLE DB, is there a need to confure OLE DB?
>>>>
>>>>Lou.
>>>>
>>>>
>>>>On Sun, 25 Jul 2004 18:23:40 -0400, Mary Chipman
>>>><mchip@online.microsoft.com> wrote:
>>>>
>>>>>I'm not sure what you mean by this question. Access doesn't create SQL
>>>>>Server databases in the normal course of events. That being said, both
>>>>>ODBC and ADO support sending T-SQL commands to SQL Server to perform
>>>>>all manner of DDL operations. See "CREATE DATABASE" in SQL Books
>>>>>Online for the complete syntax.
>>>>>
>>>>>--Mary
>>>>>
>>>>>On Sun, 25 Jul 2004 01:58:21 GMT, Lou_Arnold@nospam.com (Lou Arnold)
>>>>>wrote:
>>>>>
>>>>>>Does MS Access use ODBC or OLE Db to create a database on SQL Server?
>>>>>>
>>>>>>If OLE DB...is there anything to configure/inspect about OLE DB?
>>>>>>
>>>>>>Lou Arnold.
>>>>>
>>>
>