Microsoft Office Tutorials and References
In Depth Information
Finding Alternatives to Access Data Projects
the SQL Server database by using linked tables, and your application will
continue to operate.
For more information on using linked tables in an Access database, see
“Using ODBC,” earlier in this chapter.
✦ Create a hybrid application. If your application is large, and you don’t
want to convert everything at the same time, you can import your data
into an Access app and link to the SQL Server database from an .accdb
file. This method allows you to migrate gradually, adding forms and
functionality to your Access app over time while maintaining your client
application as an .accdb file with tables linked to the SQL Server
database behind the Access app.
✦ Upgrade to the .NET Framework. Your application may be complex
enough for you to consider moving to a more robust development
platform, such as the .NET Framework. SQL Server is designed to make it
easy for you to use the database infrastructure you’ve already created
and extend the functionality of your application without having to
significantly rewrite your code.
When you’re working with data from SQL Server (or another data source), the
data is coming from somewhere other than Access. After you establish the
connection to the server and the database, you can build the rest of your
Access objects — forms, reports, macros, and modules — to create a robust
front end to a SQL Server database.