Compatability with office,sql, and vista

[d9pierce]

Hi everyone,
I would like someone to answer a question!
Are office pro 2007, sql server 2005, and windows vista ultimate all
compatable. I dont really like office 2007 but 2003 is not compatable
with sql server 2005 and sql server 2000 is not compatable with vista.
Before I go and spend more money on software, I would just like to
know these three things are compatable
Thanks to everyone!
Dave

 

[bcap]

Yes they are.

In what way is Access 2003 not compatible with SQL Server 2005? Seems to
work fine for me.

 

[d9pierce]

Yes they are.

In what way is Access 2003 not compatible with SQL Server 2005?  Seems to
work fine for me.






- Show quoted text -

Hi and thanks
I get an error and cannot save tables in sql server. It specifies that
access2003 is basically not compatable with sqlserver2005.... and so
on. I did some searches and found a lot of people having the same
issues with no solution other than to create tables in a different
program which is not an acceptable solution to me. I forget what the
exact error was but would not let me save any tbls nor qrys. Any
suggestions would be very helpful

 

[d9pierce]

Yes they are.

In what way is Access 2003 not compatible with SQL Server 2005?  Seems to
work fine for me.






- Show quoted text -

This is the actual issue or error!
With this version of MS Office Access you are not able to make any
drafts because this version of SQL server you are connected to does
not support this. Check the MS Office update website for the newest
downloads.

You habe connected to a version of SQL server which is newer than SQL
server 2000.

These are some solutions I found!
Are you connecting using an Access ADP or MDB file? I suspect you are
working with an ADP - so you might try creating an ODBC connection
using the SQL Native Client and see if that lets you make design
changes and additions. The other option is to use the SQL Server
Management Studio Express to do table design work.

have the same problem. I have been using the server management studio
express to do table design, however there are some things that are
very difficult to do this way. For example, creating a combo box in a
table. This is very simple in access yet next to impossible with the
limited server management studio express. When can we expect a patch
for access 03 to be able to do the table modifications to sql server
2005????

Thanks
Dave

 

[bcap]

So you're trying to use an Access ADP to design a SQL Server database. You
are quite right, you can't do that from Access 2003 for a SQL Server 2005
database.

Why would you want to? The tools that are designed for the job are more
than adequate: SQL Server Enterprise Manager for SQL Server 2000, and SQL
Server Management Studio Express for SQL Server 2005.

You say that you can't create a combo box in a table using SQL Server
Management Studio Express, and indeed you can't. This isn't because there's
anything missing from SQL Server Management Studio Express, it's because
this unfortunate frippery isn't part of SQL Server, it only exists in
Access. Most serious developers consider that the conflation of user
interface and data storage in this way is poor practice and best avoided.
See:

http://www.mvps.org/access/lookupfields.htm

If this is your only reason for not wanting to use (the free and very good)
Management Studio Express, then I must say it's a very weak reason and you
are making a rod for your own back.



This is the actual issue or error!
With this version of MS Office Access you are not able to make any
drafts because this version of SQL server you are connected to does
not support this. Check the MS Office update website for the newest
downloads.

You habe connected to a version of SQL server which is newer than SQL
server 2000.

These are some solutions I found!
Are you connecting using an Access ADP or MDB file? I suspect you are
working with an ADP - so you might try creating an ODBC connection
using the SQL Native Client and see if that lets you make design
changes and additions. The other option is to use the SQL Server
Management Studio Express to do table design work.

have the same problem. I have been using the server management studio
express to do table design, however there are some things that are
very difficult to do this way. For example, creating a combo box in a
table. This is very simple in access yet next to impossible with the
limited server management studio express. When can we expect a patch
for access 03 to be able to do the table modifications to sql server
2005????

Thanks
Dave

 

[d9pierce]

So you're trying to use an Access ADP to design a SQL Server database.  You
are quite right, you can't do that from Access 2003 for a SQL Server 2005
database.

Why would you want to?  The tools that are designed for the job are more
than adequate: SQL Server Enterprise Manager for SQL Server 2000, and SQL
Server Management Studio Express for SQL Server 2005.

You say that you can't create a combo box in a table using SQL Server
Management Studio Express, and indeed you can't.  This isn't because there's
anything missing from SQL Server Management Studio Express, it's because
this unfortunate frippery isn't part of SQL Server, it only exists in
Access.  Most serious developers consider that the conflation of user
interface and data storage in this way is poor practice and best avoided.
See:

http://www.mvps.org/access/lookupfields.htm

If this is your only reason for not wanting to use (the free and very good)
Management Studio Express, then I must say it's a very weak reason and you
are making a rod for your own back.


On Aug 4, 4:18 am, "bcap" <[email protected]> wrote:

Thanks for the input! I will do some more research into this and see
what happens. I am somewhat new to this (not brand new) but new and
have read many of books, listened to many of peoples suggestions, and
tried to develope what works from that. Some say bound forms only,
some say unbound, and the list goes on... The real disapointing thing
is that MS is getting to be like the pharmacy companies! Who on earth
wants to take a pill that the side effects are worse than the problem
itself? This is also happening with technology as its growing faster
than one can keep up and thats where the compatability issues arrise.
I am sure MS could relate the vista system with the war in Iraq (a
total disaster) and hopefully with windows 8 comming out, the lesson
will be learned but most likely not. When someone on that magnatude
sell the world something, they should be responsible to create it to
be fully combatable, not just to get a program out to make $$$$.

Thanks again, and I will definately read up on your suggestions, maybe
I need to further my interests and change my stlye some to adapt!
Thanks
Dave