March 10, 2008 at 11:50 am
Recently migrated an ACCESS database to SQL SERVER 2005 Express. Need to maintain front end ACCESS forms and reports. I have one main form with a 5 tabbed subform built and on one of the tabs another nested subform. It is on this nested subform that the original functionality of being able to modify exisitng records or navigate to add a new record through the navition bar in ACCESS that has been lost. I understand that I may have to write SQL code like a stored procedure but wanted to find out if there is anyway of avoiding this. Yes, I am new to SQL Server.
Thanks for any input!
~Annette Curtis
March 10, 2008 at 12:04 pm
The linked tables need to be set up with a set of fields that can uniquely identify each row in order to be updateable. If you haven't done so already - you will want to make sure that your tables in SQL server all have a unique clustered index defined, and a Primary key (if appropriate, they can both be the SAME index).
Once you have that set up, drop all of the linked tables and reattach them. If you get prompted for "what fields uniquely ID this table" - pick the right set, and tell Access which ones really are the unique identifier.
In some cases - I've also seen where it's necessary to add a timestamp column to the tables in SQL in order for it to be updatable over a linked table scenario.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 10, 2008 at 12:09 pm
Matt,
Thank you for the feedback I will try this and get back to you.
~Annette
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply