Access 2003 Patch for SQL Server 2005?

[bubbles]

I am developing an Access 2003 frontend for SQL Server 2005.

Problem:
Access 2003 cannot update tables in SQL Server 2005 (but can update
SQL Server 2000 tables)

Is there a patch for Access 2003 to enable it to update tables in SQL
Server 2005?

Thanks,
Bubbles

[Rick Brandt]

bubbles wrote:

I am developing an Access 2003 frontend for SQL Server 2005.

Problem:
Access 2003 cannot update tables in SQL Server 2005 (but can update
SQL Server 2000 tables)

Is there a patch for Access 2003 to enable it to update tables in SQL
Server 2005?

Thanks,
Bubbles

It is true that an ADP project cannot update the DESIGN of tables in SQL Server
2005. You should be able to update the DATA though with no problem.

If you are talking about design changes, then no there is no fix that I am aware
of. ADPs are pretty much on their way out so I doubt that any sort of fix like
that would be coming.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Tom van Stiphout]

On Thu, 26 Apr 2007 11:44:31 GMT, "Rick Brandt"
<ri*********@hotmail.comwrote:

ADPs have never been great at updating SQL Server objects. Fortunately
SQL Server Management Studio is a free download.

-Tom.

>bubbles wrote:

>I am developing an Access 2003 frontend for SQL Server 2005.

Problem:
Access 2003 cannot update tables in SQL Server 2005 (but can update
SQL Server 2000 tables)

Is there a patch for Access 2003 to enable it to update tables in SQL
Server 2005?

Thanks,
Bubbles

It is true that an ADP project cannot update the DESIGN of tables in SQL Server
2005. You should be able to update the DATA though with no problem.

If you are talking about design changes, then no there is no fix that I am aware
of. ADPs are pretty much on their way out so I doubt that any sort of fix like
that would be coming.

[lyle fairfield]

bubbles <bu*********@hotmail.comwrote in news:1177553883.493220.140340
@r30g2000prh.googlegroups.com:

I am developing an Access 2003 frontend for SQL Server 2005.

Problem:
Access 2003 cannot update tables in SQL Server 2005 (but can update
SQL Server 2000 tables)

Is there a patch for Access 2003 to enable it to update tables in SQL
Server 2005?

Thanks,
Bubbles

You can Drop Tables, or do any other SQL maintenance required using
CurrentProject.Connection.Execute in a VBA module. This is likely to be
what Access does anyway.

If you do it then you will have control over what happens.

If Access does it, you have a fifty-fifty chance it will do it right.

[Bruce]

On Apr 26, 6:44 am, "Rick Brandt" <[e-mail]:

It is true that an ADP project cannot update the DESIGN of tables in SQL Server
2005. You should be able to update the DATA though with no problem.

If you are talking about design changes, then no there is no fix that I am aware
of. ADPs are pretty much on their way out so I doubt that any sort of fix like
that would be coming.

"ADPs are pretty much on their way out " is an interesting statement.
While I know that they're not exactly the favored means of
communicating with an SQL server I wasn't aware of their being "on
their way out". My first exposure to Access client/server development
with SQL server was via ADP's and while they were quirky they also did
a lot of neat stuff. I just figured Microsoft would eventually work
out the kinks (although they've had plenty of time to do so). Is
there any kind of public statement that Microsoft has made about ADP's
being phased out? Just curious.

Bruce

[lyle fairfield]

Bruce <de***************@gmail.comwrote in
news:11**********************@r30g2000prh.googlegr oups.com:

On Apr 26, 6:44 am, "Rick Brandt" <[e-mail]:

>It is true that an ADP project cannot update the DESIGN of tables in
SQL Server 2005. You should be able to update the DATA though with
no problem.

If you are talking about design changes, then no there is no fix that
I am aware of. ADPs are pretty much on their way out so I doubt that
any sort of fix like that would be coming.

"ADPs are pretty much on their way out " is an interesting statement.
While I know that they're not exactly the favored means of
communicating with an SQL server I wasn't aware of their being "on
their way out". My first exposure to Access client/server development
with SQL server was via ADP's and while they were quirky they also did
a lot of neat stuff. I just figured Microsoft would eventually work
out the kinks (although they've had plenty of time to do so). Is
there any kind of public statement that Microsoft has made about ADP's
being phased out? Just curious.

Bruce

Sometimes public statements are public non-statements.

Fire-up Access 2007 (is the trial version still available?) and explore its
accommodation of ADPs. Can it do ADPs? Absolutely! Does it make this
capability obvious, clear and simple? Not that I have found.