Search results

Hello, i am working with Access forms, and on the form i am adding record in the sql server. Problem: Sql query doesnt show all the values for the columns. My query has got 32 columns where as values it shows are up to 4-5 columns. Is there any limit on ho wmany columns you could use in Sql...

Thanks for ur reply. Error i was gettin not because of PK(i did set PK in the sql table and reconnected it to the Access), it was because i wasn't using 'dbseechanges' while i was pulling the data from Sql and was tring to do 'db.execute' rather than doing docmd.runsql. Anyways its working fine...

Here is something else, My identity key in the table wasn't a primary key.I changed it to Primary key,now its giving me the error '3622': You must use the dbSeeChangesoption with Openrecordset when accessing a sql server table that has an identity column.

I am using ODBC connection.I have set ODBC through system DSN.

I did,deleted the old link and created a new one.Error is still there.

Hello, I have changed the permission of the account to 'Read,write,dbowner.' But error is still there. What else should i check?

In datasheet view,it says recordset is not updatable.

You are right, i cant edit a table whne i open it in access. How can i do that?

My new query: "Update dbo_fin_ldg set ldg_Year = 2010, Month_Name = 'Feb',ldg_Month = 02,Product = '',Category = 'Gear',Customer = '',Actual_Volume = 12,Budget_Volume = 1245 Where ID = 2488;" Any ideas plz....

Thanks for your reply. Year and Month are the column fileds in the database(Sql). Do you want me to chnage these names in the sql table? Also removed the quotes from ID, same error. Error 3073, Operation must use an updatable query.

How can i make a query updatable? "Update dbo_fin_ldg set Year = 2010, Month_Name = 'Feb',Month = 02,Product = '',Category = 'Gear',Customer = '',Actual_Volume = 12,Budget_Volume = 1245 Where ID = '2488';"

figured it out, it was my database connection which was not reflecting the current database. Above code works just fine.

Here is another problem or apart of the previous one: Filed value i am trying to select is identity. It works fine if i say "Select * from table." But i want to select the last record in the table and for that i need Max(ID), if i get Max(ID) then i can pull the whole record. Can anybody...

This is what i am doing. When pointer reaches to the highlighted line, it comes up with the error: Run tim error:3061. Too few parameters, expected '1' Any ideas on how to resolve it. Dim db As Database Dim rs As Recordset Dim strSQL As String Set db = CurrentDb()...

Hello, I am working with access front end. I have got a form connected to Sql,it saves data in the database. Now i would like to pull data back from the database. There are a few buttons on the form,like previous,next,first and last. If form is empty and user click on previous button,then it...

Thanks for your reply, you are right that in the future,if i need to update any existing data, then i will need a primary key in the table.I understand that,but requirement was not to change it, just enter new data in the table.

I didnt add any ID in my table, and added the new record through code and its working fine.Thanks for help!!

I really need to get this working. I dont want to update any record at the moment, just want to enter new record. Can anyone guide me in the right direction.Thanks!!

If i want to update an existing record then only i need an ID/Primary key in the table,but if i want to just enter the records then it shouldn't need any ID/Primary key. At the moment i only need to enter new records in the data and for that i dont need any updatable query.

By adding ID filed to the table doesnt help either.It comes up with the error message 'Operations must use an updatable query'. Any ideas....