Kinger43
racecar driver
- Local time
- Today, 14:04
- Joined
- Aug 17, 2007
- Messages
- 226
I am attempting to create an Access 2007 front-end to an existing remote SQL Server 2008 database. I created a new Access Project (adp) and connected to an existing SQL database. I entered all information in the Data Link Properties dialog and clicked Test Connection. Access said it was successfull so I clicked OK on the Data Link Properties dialog expecting the database to connect. However, it does not. In the title bar at the top it says DATABASENAME (disconnected)roject (Access 2002-2003 file format). I checked permissions for the user (SQL Authentication) in Management Studio and I don't see any issues there as the user as db_owner permissions for the database. I can connect through Excel and link to all tables in the database using the same login. Is there something I'm missing?