Access to SQL

  • Thread starter Thread starter Pietro
  • Start date Start date
P

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 ?
 
yah no shit you don't know anything about SQL Server
you're an MVP

MVP _MEANS_ that you're a JET crybaby
 
you don't want to LINK you want to UPSIZE
Click to expand...

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?
 
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
 
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.
 
Pietro said:
I want to link my fe database 2003 to SQL 2005,Is there a wizard for this ?
What about the wizard in Access 2007 ?
Click to expand...


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/
 
Back
Top