Access 2007 against SQL 2008 writeback approach

[Mr. Smith]

Hi.
I'm in a project where my application, currently built in Access 2003 and
integrated with SQL2000 with "plain" ODBC linking, should be migrated to
Access 2007 and SQL 2008.

What would be the "state of the art" integration when I'm doing writeback to
the SQL2008 environment. The rest of the project team talks about cubes and
stuff. I'm "blank" and would probably try the same approach as I allredy
have (plain linking and hardcore SQL directly in VBA......)

Please give me a hint on what I want to look into.... (I'm really feeling
like a "old-timer")


Kind regards
Mr. Smith

 

[Mary Chipman [MSFT]]

You'll be relieved to know that, archictecturally speaking, things are
still the same, and your Access 2003 application should run just fine
in Access 2007 without your having to do anything. Migrating your data
from SQLS 2000 to 2008 should also be fairly painless -- see
http://msdn.microsoft.com/en-us/library/bb677622.aspx for guidance. If
you want to take advantage of new features/functionality, then you'll
need to dig in and research what makes sense in terms of your
application's functionality. Here's a list of other resources you
might find interesting.

TechEd Online Panel (video):
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"

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

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspf...ifferences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446

Migration Considerations for Access 2007
http://technet.microsoft.com/en-us/library/cc178973.aspx

--Mary

 

[Mr. Smith]

Great, thanks a lot Mary!

Kind regards
Mr.Smith

You'll be relieved to know that, archictecturally speaking, things are
still the same, and your Access 2003 application should run just fine
in Access 2007 without your having to do anything. Migrating your data
from SQLS 2000 to 2008 should also be fairly painless -- see
http://msdn.microsoft.com/en-us/library/bb677622.aspx for guidance. If
you want to take advantage of new features/functionality, then you'll
need to dig in and research what makes sense in terms of your
application's functionality. Here's a list of other resources you
might find interesting.

TechEd Online Panel (video):
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"

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

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspf...ifferences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446

Migration Considerations for Access 2007
http://technet.microsoft.com/en-us/library/cc178973.aspx

--Mary