Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 26th, 2004, 11:43 AM
Authorized User
 
Join Date: Oct 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to cuzintone Send a message via Yahoo to cuzintone
Default Cant enter data into Tables ADP

I created a database in SQL Server and I want to use MS Access to for simple data entry during the application debugging process. Basically, use Access as an easy way to enter data. When I connect to the database on the SQL Server (using sa), I can't enter any records into the tables. When I right-click on the tables, the Properties option is grayed out?

Can someone please help?

-T

__________________
---------------------------
\"I finally understand the true value of time, for it is the bonds between us that give time its meaning.\"
 
Old November 26th, 2004, 12:12 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you have primary keys defined on your SQL Server tables?

If not, Access will present them as read-only.


Brian Skelton
Braxis Computer Services Ltd.
 
Old November 29th, 2004, 10:29 AM
Authorized User
 
Join Date: Oct 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to cuzintone Send a message via Yahoo to cuzintone
Default

Thanks, that really helped...






Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoid enter data from keyboard into combobox mona_upm84 Excel VBA 1 September 5th, 2008 01:26 AM
how to enter data to pdf or word doc from ASP joseph007 Classic ASP Professional 3 July 10th, 2007 05:52 AM
Readonly ADP Data dhay1999 Access 2 May 4th, 2006 10:12 AM
Delete Query in Access Data Project (ADP) Pavesa Access 1 February 18th, 2005 08:38 AM
ow to enter data in to a pdf or word doc from ASP joseph007 Classic ASP Components 0 September 15th, 2004 08:43 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.