Troubleshooting
How to Install MSDE
| Q1: | When I choose File, New and click the Project (New Database) icon, Access asks me to fill in details about my SQL Server connection, but I can't connect successfully. |
| A1: | You need to install the Microsoft SQL Server Desktop Engine. Find the Office XP CD1 and run the Setup program in the MSDE2000 folder. This option is not installed by default, and it will not install automatically like other Office features. If you're creating a new project from scratch, choose File, Connection; in the Data Link Properties dialog box, enter your computer name as the name of the SQL server, but don't include any backslashes in front of it. You must have administrative rights, or be an authorized user as defined by the SQL ... |
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
