Problem with ADOX in Access 2000

[Jon Jeffery]

I have an Access 2000 database (which started as Access
97), which up to now has used DAO to access SQL Server 7
tables via ODBC.

I am trying to update it into an Access Porject ,
connected to SQL Server 7 using ADO. I can connect quite
happily, and use the existing tables (so far at least)
but I have hit a snag when I try and set up a new table
using ADOX. I can set up the table, and its column (it
is a single column table) OK, but when I try and append
it to cat.tables, I get an error message:
Run-time Error: 3251
Object or provider is not capable of performing requested
operation.

My SQL Server is the Desktop version, running on the same
Windows 2000 Professional machine.

I have an additional problem in that when I try
the 'Help' button, it brings up a blank help screen. If
I try Help from the VBA window, I can find an entry for
ADOX Append Tables, but when I click on it, nothing
happens.

Also, I haven't found anything in the Knowledge base.

Help!

 

[DL]

might be better addressed to one of the Access ng's
on, msnews.microsoft.com
microsoft.public.access.***
David

 

[Jon Jeffery]

Thanks, David, I'll try that too.

I posted it here because, as a member of Technet Plus. I
am guaranteed a response (I believe).

Jon

 

[Tommy Campbell - [MSFT]*]

Hi Jon,

I am walking the queues today and I am seeing that you have an issue that
has not been addressed. I think I can provide some assistance for you. You
are correct in stating that you will get a response within 24 hours as a
TechNet plus subscriber provided the issue is placed in the correct queue.
I did a great deal of research on this issue with members from other queues
and specifically the SQL group and we all agree that this query should be
placed in any of the following queues:
microsoft.public.access.adp.sqlserver
microsoft.public.access.developers.toolkitode
microsoft.public.office.access.toolkitode
microsoft.public.office.access.formscoding
microsoft.public.office.access.forms
microsoft.public.office.access.devtoolkits
microsoft.public.office.access.activexcontrol
microsoft.public.data.ado
microsoft.Public.ADO

As a Technet Plus subscriber you will still receive the guaranteed response
times that you have mentioned before and will get a much better response as
the pool of respondents are specific to SQL technology and not
miscellaneous Office queries.

Please let me know if you have any additional questions or concerns about
this.

Thanks for posting!

Best Regards,

Tommy Campbell, 2000 MCSA, MCSE
Microsoft Online Support Engineer
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jon jeffery]

Hi Tommy,

Thanks for that - I have been trying to find the
newgroups you mention - can you let me know how I get to
them??

Regards

Jon

 

[Bob Buckland ?:-\)]

Hi Jon,

The newsgroups (what Tommy referred to as 'queues'?)are carried on the MS Public News Server,
news://msnews.microsoft.com and also shown, in a 'filtered' sublist from the newsserver's master list via a browser 'community'
interface through
http://microsoft.com/communities and other MS subgroups.

The links below will take you to the MS Office community list.

========
Hi Tommy,

Thanks for that - I have been trying to find the
newgroups you mention - can you let me know how I get to
them??

Regards

Jon >>
--
Let us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

MS Office Community selected newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx

Complete MS Office products newsgroup access via Outlook Express or other Newsreader
news://msnews.microsoft.com

Accessing Specific newsgroup mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access.adp.sqlserver

 

[Jon Jeffery]

Thanks very much.

Jon Jeffery

-----Original Message-----
Hi Jon,

The newsgroups (what Tommy referred to as 'queues'?)are

carried on the MS Public News Server,

news://msnews.microsoft.com and also shown, in

a 'filtered' sublist from the newsserver's master list
via a browser 'community'

interface through
http://microsoft.com/communities and other MS subgroups.

The links below will take you to the MS Office community list.

========
<<"Jon jeffery" <[email protected]>

wrote in message [email protected]...