Newbie question... 1

[Phailak]

Hail,

I just installed MS SQL server 6.5 on my NT server (I have to use 6.5 because of one of the apps that runs here). Anyway, I created a database and a table and everything seems fine. My colums are ok and everything but I can't populate the table. If I use MS query, I can check allow editing and add records from there but if I link it through access, I don't have the Add new record enabled. I tried fooling around with the permissions but I just can't figure it out.
Oh yes, I also wanted to know if there was a way for me to transfer my MS access mdb databases to SQL directly. I have seen this option on 7.0, but as I mentionned before, I cannot use this here.
Any help would be appreciated

Phailak

 

[tlbroadbent]

Does the table have a primary key, unique index or timestamp column. In order to update from Access, the table shouls have one of those attributes. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[Phailak]

Hail,
Thanx, that should get me started

Phailak