Thanks for this.  I couldn't do backup log at all, it just didn't like it.  I ended up restoring the latest backup, which took us back just enough to allow...

Ok, thanks.  Will do.

Hm, I've tried hovering over the link in Access but I get nothing.  I only have Access 2000 though.  Should I be able to do this when I hover over...

I'm sorry, I don't really understand what you are saying.  odc is open database connection is it?  How do I do that through Access?  I thought there was only one...

Hi, thanks for this.  I realised the mistake I made.  I had created the ODBC connection whilst actually on the server, but then I tried to open the tables when...

I cross posted because as the day wore on I realised that the solution probably lay in a SQL Server programming type task, rather than Access.  I was trying to get...

Yes you're exactly right.  I've recently arrived here as DBA and I am gradually discovering more and more poorly designed databases.  Awareness seems better now, so it's only older system...

Thanks very much.  We're talking of hundreds of rows so it's not too bad.  I've picked it out manually but still feel as though I've missed stuff.  And I'm also...

Thanks for this.  I can now get the data into the file.  Formatting is terrible but I can work on that!

Is it me or is the error message really deceptive?  It...

The datatype for RequestId is int, and it does not need isnull because it cannot be null, it is the key to the table.

Thanks,

Paula.

Sorry, I should have explained that the sql runs fine in Query Analyser, without the commas and speech marks, so the error must be something to do with the concatenation...

The error occurs during an optimization job which just rebuilds indexes.  It also happens when a report is run, when a view is opened, and in a couple of other...

Ha ha, I did not put those faces in, but hey it looks good!

Hello again.  I deleted the entire database from the subscribing server and put it all back on again, but no luck.  Same error again.

I'm getting desperate.  Can anyone recommend any...

Ok.  I checked the schema at the publisher and subscriber and they match perfectly.  And we definitely do not have any large values in int columns.  This is a small...