Running SQL Server 2000 with Access 2000 as front end. Access connects to the SQL Server via ODBC. I have a number of forms, queries, reports and VBA in Access and about 20 linked tables into SQL Server.

I was having no problems and performance was great but the other day a strange thing happened. I amended a trigger to play a sound when a record was created which failed first but then worked.

Now I am stuck, the server will not return the records requested from 1 particular table in both Access and the query analyser. If however I shutdown the server and wait and reboot, eventually it all comes back up and works again.

Sorry I probably have missed out loads of required info so please ask. Any thoughts.

Regards

Ben

Take a look at Access Database Project (ADP)
is a feature that came out with Access 2000, is really a development environment dedicated to MS SQL Server and MSDB (Microsoft Database Engine). No other databases can be used in an Access Project. In an Access Project, you have design
privileges to SQL Server objects, such as Tables, Views and Stored Procedures. Of course, you also have the forms and reports and VBA code that exists in a normal MDB file. Also, there are no linked tables, and all data access to the SQL Server is done through OLEDB,
which is much faster than linked tables.