all groups > sql server msde > june 2005 >
You're in the

sql server msde

group:

Client tools



Re: Client tools Andrea Montanari
6/24/2005 12:00:00 AM
sql server msde: hi,
[quoted text, click to view]

unfortunately I'm not an Access guy...
perhaps you have to ask in Acces/Office public NG
but you can define that via Transact-SQL Code like
CREATE TABLE dbo.someTable (
ID int NOT NULL IDENTITY(1,1) ,
other columns ...
)
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Client tools archer
6/24/2005 10:12:04 AM
Hi I am new to MSDE. I see that you can use Access Data Projects to setup
MSDE but don't see some of the tools I have seen in SQL Server enterprise
manager. (Forgive me if I ask some really elementary questions for a while).

I want to set up tables with unique PK's that auto-generate values. I
learned today that the IDENTITY column is the way to do this, but how do I
set up one of these columns from Access?

Thanks
Re: Client tools Norman Yuan
6/24/2005 3:40:49 PM
In Access project, which is connected to the said database, open the said
table in design view, at bottom of table design view is table column
properties view, make "Identity" to "Yes".

[quoted text, click to view]

AddThis Social Bookmark Button