July 19, 2007 at 5:38 pm
Can someone explain to me when setting up an adp access project and linking all of the tables to sql server 2k, I notice the tables do not allow a user to insert records on the access side. Down at the record bar, when trying to click on the insert a new record into a table, instead of getting a new line to insert another record, I get the window of how many records do you want to display? Is it possible to insert records into tables on the access side and if so how?
I notice the insert icon turns to a red x when clicking on this icon. Not sure what that means. Also, when I open up the table, under the Insert menu their is an option to insert a record with Ctrl++, but that is greyed out.
July 20, 2007 at 4:08 pm
You should have a primary key which has the Identity set to yes in each table.
July 20, 2007 at 4:40 pm
Where do these settings get changed or turned on?
July 22, 2007 at 9:46 pm
You need to index the table at the database side of things - ie set a primary key.
July 23, 2007 at 6:49 am
Whether or not the user can insert records depends on the SQL security. If the user can insert records using Enterprise Manager or SSIS, then they can insert records in the ADP. The ADP is tightly linked to the SQL server and depends on the SQL security scheme to determine table (and any other object) access.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply