Access to SQL

[Pietro]

Hi,
I want to link my fe database 2003 to SQL 2005,Is there a wizard for this ?
What about the wizard in Access 2007 ?

 

[a a r o n . k e m p f]

yah no shit you don't know anything about SQL Server
you're an MVP

MVP _MEANS_ that you're a JET crybaby

 

[a a r o n . k e m p f]

you don't want to LINK you want to UPSIZE

 

[pietlinden]

you don't want to LINK you want to UPSIZE

Yes, I AM hijacking this thread... given that you think the Access
native data engine sucks, what are some good resources to teach
hopeless souls like me how SQL Server is different than Access, and
how to write a proper SQL Server database and implement standard
features?

 

[Larry Linson]

you don't want to LINK you want to UPSIZE

Mr. Kempf, would you be so kind as to define what you mean by "UPSIZE"?

As there is no facility in SQL Server to create a user interface, what UI do
you suggest instead of Access?

Given that the Access team has stated that Access <-> ODBC <-> MS SQL Server
is the method of choice, and that method would use LINKing, why, then would
a user not want to LINK?

Larry Linson
Microsoft Office Access MVP

 

[Tom Wickerath]

Hi Pete,

Have you seen this document?

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn2.microsoft.com/en-us/library/bb188204.aspx


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[aaron.kempf is a robot]

CAUTION!
It has been determined that the message below was generated
programmatically, by a program robot ("bot") which also allows manual
intervention. This robot was created by a person or persons deliberately
trying to interfere with users of the Microsoft Access database software, and
uses the name of an actual person. As it is not possible to block posting by
this "bot", we post these cautions lest you be misled into taking the posts
as authentic and serious.

 

[Tony Toews [MVP]]

I want to link my fe database 2003 to SQL 2005,Is there a wizard for this ?
What about the wizard in Access 2007 ?

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

SSMA might do a better job than the included upsizing wizard.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[BillD]

Yes, The SSMA (Sql Server Migration Assistant) worked flawlessly for me.