Recent content by chrisdd

Hi all, I've got a couple of Access front ends connected to SQL server - 1 of which is working fine in terms of connecting to the server, the other one which has always worked with no issues has this morning suddenly started displaying Connection failed: SQL state 'S1000' and can't generate...

Hi all, I've got an access form where the scroll bars are set to Both in the format properties but they don't appear, the forms are all set to open in Dialog view - that wouldn't make a difference would it? Thanks in advance

Oh my word - can't believe how long I've been looking at this when the solution may have been staring me in the face! You're a star - thankyou!

Thanks - I'm working on this method also!

Hi, Thanks for this but it returns Run time error 3146 ODBC call failed when I use Dim db As DAO.Database Set db = CurrentDb With db.CreateQueryDef("") .Connect = db.TableDefs("WasteReturnQryData").Connect .SQL = "exec schema.database.appendtrial3 @datefrom = '" & Format(Me.DateFrom...

Great thank you, much appreciated. Only issue I've now got is connecting to the stored procedure in VBA! I've tried various bits of code but none seem to work, can you point me in the right direction please?

Hi, I'm sure there is a very simple solution to this, I just can't see it! I've got a sql procedure that appends records between 2 dates from 1 table to another - there are 2 parameters @datefrom and @dateto, both have the date datatype I'm using an access front end and have 2 text boxes...

Hi, I'm using the standard link to tables VBA script found here All of my tables are stored in a local table - only issue is, is that when I add the names of the new tables into the local table to be linked -they don't appear as linked tables? All of my existing tables that I've been using...

Can I also add a further weird detail and that is, if I go into the front end and manually save a form, the next time I open the database I don't see the SSPI error, but if I then close the front end without saving the form and open it again I get the SSPI error??? I'm very confused!

Hi, Going to show my ignorance now but presumably Kerberos tool needs to run on the server? Thanks

Hi, thanks! Sorry should have been a bit clearer - we want to access the SQL server without the VPN which is rather unreliable - I get a couple of the SSPI context messages that I can close and eventually it will access the SQL server and stay connected without the VPN, its all very strange...

I'm using SQL server express 2019 which recently could only be accessed via a VPN. I'm using a standard ODBC connection string: ODBC;Driver={SQL Server};SERVER=#######DATABASE=#######;UID=####### ;PWD=#######; When I first changed the name of the server to connect without the VPN it worked...