Data Entry Microsoft Access Project

[Guest]

I have a Microsoft Access Project (MS Access 2003) with an existing SQL
Server DB (SQL Server 2000) with a variety of different tables. I can enter
data directly into all tables in Enterprise Manager, I can enter data into
all tables with SQL in Query Analyzer or as a stored procedure in the
Microsoft Access Project. However, I can only enter data into one table in
Microsoft Access and none of the others. I have tried entering the data in
the datasheet view or by means of a form, but the data entry option is not
available in any of the tables except for one. What would cause this? I have
a need for users to update data in tables by means of a form within the
Microsoft Access Project, but the add record option is not available for any
of the tables except one.

Thank you for your help,

Tommy Watrous

 

[Guest]

Hi Tommy,

Just a guess, but do you have a primary key set in each table? If not, this
could be the cause of your problems.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Tom,
On the table that I could enter data directly into the table it had a
primary key. The others did not. I set up a primary key in one of those that
did not allow data entry directly into the table and it suddenly allowed me
to enter data directly into the table. I never had to do this in an ordinary
access DB but I guess being a MS Access Project with a SQL Server DB as my
source it makes a difference. Thank you so much for the help - I was totally
baffled.

Tommy

 

[Guest]

Hi Tommy,

I'm glad to hear that you got it working. My personal belief is that *every*
table should have a primary key defined, even if it is not used (just goes
along for the ride). You might want to adopt this habit.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________