Data entry Problem 1

[jpl458]

Using ACCESS 2010 created a data entry form that connects to a linked table in SQL Server.

The problem is that the form now only displays the test data, and won't let me enter new data. The controls at the bottom of the form will only let me go thruogh the data, but the button that lets me enter data is turned off. Is there a way of turning it on? And what did I do to turn it off?

I have added if this bit of code that works on other aps that relinks the odbc tables, its added in OnLoad.

Dim tdf As DAO.TableDef
For Each tdf In CurrentDb.TableDefs
' check if table is a linked table
If Len(tdf.Connect) > 0 Then
tdf.Connect = "ODBC;DSN=dsnname Server;APP=Microsoft Office 2010;DATABASE=Mydatabase;Uid=hello;Pwd=mystuff;Network=nnnnnnn"
tdf.RefreshLink
End If
Next

Any help would be greatly appreciated

Thanks in advance

jpl

 

[dhookom]

Does the table have a primary key that Access knows about?
What are the form's Data property values?
Can you edit the records directly in the table?

Duane
Hook'D on Access
MS Access MVP

 

[jpl458]

I took at look at what you suggestion and decides to start from scatch againn since I was not that fir into it. Anf for reason I don't know, it worked.

Thanks for the quick response

jpl