Access with SQL

DTE Table?

Yes the DTE table it consist of an ID, Startdte, and Enddte fields.

Is it a system table of some kind, or is that its name?  If any of the fields are calculated fields you will not be able to modify them.

That is the name of the table. We were able to change the values of  this table before. I don't know what changed in the table that is preventing us from updating the table.

Can you change the data in SQL?

Yes. I can go into the enterprise manager and return all rows in the dte table and modify the data from that menu.

delete the link to your dte table and relink.

Can you guide me through the deletion of the link to dte table and relinking. not very familiar with sql.

i meant delete the linked table in access. in the database window, under tables, there will be a sql table link for your DTE table (distinguished with a globe icon). select the table link, then hit the delete key. then add a new table, as a link, linking it to sql. if you need help with that part post back.

-a

note: if it is not a linked table, but a pass thru query that is being used as your source, that would be why you cannot make changes. PT queries are read only.

When I delete the dte table in access it is also deleted in the SQL server. The tables are not linked they seem to have a direct connection to the sql database. In Access I can click on file and then connection, it show me  the data link properties, name of the server, and database. It also show that it is set to use the windows nt integrated security.  

It was the primary key. Thanks!

you're welcome!