Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem linking with SQL Server
Let me just apologise, I didn't notice that this was in
fact the Excel group and totally unrelated to my question :) -----Original Message----- I have an MS Access based front end to an SQL Server database. If I create records using the Access client all works fine, however, I have an old MS Access DB that I'm trying to take records from. I've tried doing it numerous ways, but the only way that seems to work is by using an INSERT..SELECT statement within the old Access DB that adds the records. However, if I then use Access to edit a record it then pops up an error box saying that the record may have been changed and my changes cannot be saved. I assume this is something to do with the way records are timestamped to warn against consistency problems. Anyway, I can't figure out how to sort this. I need to add old records, but every method I've tried means I can't edit them afterwards. I'm using SQL Server 2000 and Microsoft Access 2000 with MDAC 2.7 SP1. Any suggestions would be appreciated. Regards, Paul . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to Protected Source File on Shared Server | Setting up and Configuration of Excel | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
disk full problem on a server | Excel Discussion (Misc queries) | |||
query problem after changing to SQL server | Excel Discussion (Misc queries) | |||
Problem linking with SQL Server | Excel Programming |