Forum Discussion
Build sql server backend and Microsoft Access as the frontend?
Where will you deploy the SQL Server instance you'll use? Do you already have one available?
You can download the FREE SQL Server Express and install it on your computer or a network server available to you.Download and install SQL Server Migration Assistant for Access.
It will allow you to migrate your data from the Access accdb to the SQL Server where your database will reside.
Be sure to take plenty of time to configure the datatypes for your new SQL Server tables to be sure they are compatible and appropriate for YOUR specific database.
Also, download and install the latest ODBC driver for SQL Server. You'll need this to establish the links from Access to the new SQL Server database.
Finally, invest plenty of time reviewing some basic information about designing your Access front end to work well with SQL Server. There is a great deal to say along those lines, so I'll just point to a good starting point.Good luck with your project.
Where will you deploy the SQL Server instance you'll use? Do you already have one available?
You can download the FREE SQL Server Express and install it on your computer or a network server available to you.
Download and install SQL Server Migration Assistant for Access.
It will allow you to migrate your data from the Access accdb to the SQL Server where your database will reside.
Be sure to take plenty of time to configure the datatypes for your new SQL Server tables to be sure they are compatible and appropriate for YOUR specific database.
Also, download and install the latest ODBC driver for SQL Server. You'll need this to establish the links from Access to the new SQL Server database.
Finally, invest plenty of time reviewing some basic information about designing your Access front end to work well with SQL Server. There is a great deal to say along those lines, so I'll just point to a good starting point.
Good luck with your project.
- Are these two tools SQL Server Migration Assistant for Access and latest ODBC driver for SQL Server complicated to install?
I have SQL Server and Microsoft Access on my computer.
Regards,
CloudsInTheSkyNot at all complicated. I've done it numerous times with no problems. The only thing that comes to mind is that you must match the bitness of the ODBC driver you select (32 or 64) to match the bitness of your MS Office applications. That means downloading that appropriate version.
