Hi,
I have a DB which is an Access 2002 FE and SQL BE. The DB consists of Door schedules for different buildings so doors can repeat for each floor so I need a repeat function that copies a main Schedule to a new record and all the underlying records of that particular record to the new record just created.
So my question is. Can I do this http://support.microsoft.com/?kbid=208824
with an SQL BE. It works fine and dandy if I was just using an MDB DB but I cannot find a way to get it to work with an the combination of Access and SQL.
If there is another way then It would be great to know.
Any thoughts much appreciated.
Paul
I have a DB which is an Access 2002 FE and SQL BE. The DB consists of Door schedules for different buildings so doors can repeat for each floor so I need a repeat function that copies a main Schedule to a new record and all the underlying records of that particular record to the new record just created.
So my question is. Can I do this http://support.microsoft.com/?kbid=208824
with an SQL BE. It works fine and dandy if I was just using an MDB DB but I cannot find a way to get it to work with an the combination of Access and SQL.
If there is another way then It would be great to know.
Any thoughts much appreciated.
Paul
