MS Access Project Problem -- sql server connect

andy18
9/19/2003 12:48:10 PM

Hi,

I have connected to the SQL server database using the Access Project but
I am not able to add in rows to exisiting tables when I open up the
tables for editing.No empty rows shows up at the end of the table to
allow me to do so.

It works fine for new table setup.I am able to add in data for
new tables.

Is this a permission issue or ...?

Please guide...

Thanks,

Andy

--

Sue Hoegemeier
9/22/2003 5:10:43 PM

It could be but it's very hard to say without more
information. Do you get any errors, any messages in the
status bar when you do this? What are the permissions for
the user account that you are using to connect to the
database? Do the existing tables have primary keys (or a
unique index) ?
You could also run SQL Server Profiler to see what errors
are being generated.

-Sue

On Fri, 19 Sep 2003 12:48:10 -0400, andy18
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : MS Access Project Problem