Re: using access 2003 adp with sql server 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
unfortunately - you can't design sql server 2005 in access 2003, you have to use sql server management studio to do so

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message news:e6kTqb1rHHA.1208@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

I started using access 2003 adp with sql server 2005 because i can't use tables with bigint.

When i have sql server tables and I try to enter as design view i got error:
the version of microsoft access doesn't support design changes with vhe vertion of microsoft sql server your access project is connected to

what is the problem and how can i solve it


.

Relevant Pages

  • Re: How to handle concurrency issue with better performance?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Then for timestamp, it will be unique? ... Collisions occur because your design permits ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ORDER BY in VIEW not working
    ... As an object-oriented programmer, I expect to be able to encapsulate ... The relevant design principle is that of Orthogonal Design. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: Target number of database reads per user
    ... Yeah, just to echo what Andy is saying, if you want to have the question ... If you can post code/database design we could all take a look. ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)
  • Re: Access Form connected to SQL table in Access Data Project (.adp file)
    ... Under the previous design, he would just open the form and could ... navigate through the last few orders by clicking "next record" a few times. ... > the form what records it should load. ... we are NOT even using sql server yet. ...
    (microsoft.public.access.conversion)
  • Re: Database design question
    ... Pro SQL Server 2000 Database Design ... Please reply to the newsgroups only unless you are ...
    (microsoft.public.sqlserver.programming)