Search results

Here are the errors that i get: Connection failed SQLstate: '01s00' SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver] invalid connection string attribute Connection failed SQLstate: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server] login failed for user...

I have a ms access file whit form's raports, and moduls i linked the tables whit a ms access database that i not have at home. dit thit whit odbc, but when i open a table the database asks me a 1000 times for the sql server password. I had the same thing whem i had my ms access file on the same...

I have a form whit 2 Subform's in it when i insert a value in 1 of the 2 subforms i want it to insert a value in the other subform. sothat it creates a new record in the tabel. Because nou i keep getting Field cannot be updated. and i hope that this will go away when i save the record before...

I have a *.mdb file whit linked mssql tabels. When i try to insert a new row in a linked table whit a model, i get this error. "Run-time error '3155': ODBC --insert on linked table '.....' failed. This is a part of my code that i am using: nContractID = Forms!frmContracten!ContractID sql =...

I have in mssql a column where i want the date of the day that it has bin made. I am using this in a ms access forum where i create contracs. And when a contract is created, i want to have in the column the date that it was created. must i do it whit a Trigger or Stored Procedure ? Or can i do...

Yes it are integers. But still the function go's to the on error.

I have linked tables on my MS access, The tables are on a MS SQL server. I made a function to calculate a price. The function works whem i have the tables in ms access in de *.MDB file. I think that i am dowing something wrong whit the Set dbData = CurrentDb. Or that de recordset is not the same...