Hi
I'll be completely honest, this could either be a problem in SQL Server or Access, I'm posting it in SQL Server as that is where I 'think' the problem might be.
I'm running SQL Server 2012 Express with a MS Access 2010 FE.
The stored procedure I created to run backups runs perfectly fine from SSMS, but my FE is Access 2010 and the recordset it receives is closed. Now I know the backup is being completed as a new backup file is created each time I test it, but within Access
the recordset is closed, i.e. 'RS.State = adStateClosed'.
This is not right as my procedures always return a resultset with a field 'Result', this ensures that there is something Access can always look at. (I know there are other ways to do this, maybe better ones, but this is the method I chose to use.)
I don't believe the problem is in Access since this method of receiving data from the server works for all procedures except this one, and I am call ...
Go to the complete details ...