I have an MS Access db which has tables linked to a SQL Server db. There is no code involved only linked tables. This was working fine eg tables opened without problem. However when I try to pen a table now I am getting the following error
SQL State: 08004
SQL server error: 4060
Server rejected connection. Access to selected database has been denied.
If I try to link a table to the db I get the following error
SQL State: 37000
SQL server error: 4064
Cannot open user default database. Login Failed.
I have tested the system dsn upon which the link is based and this is working. The Access db itself is stored on a server and when opened on another PC works fine.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…