Access Project (.adp) to SQL

Victoria

New member
Local time
Today, 03:07
Joined
Apr 20, 2003
Messages
5
I've been asked to create a database in MS Project and put the tables and queries on a SQL server. Currently a have a number of tables, some with referential integrity inforced because I need to be able to update one field in on table and do a cascade update. Will these relationships remain the same once the table are on the SQl server? I'd really appreciate any help.
 
Victoria,

Broadly, SQL Server 2000 supports cascading updates and deletes; SQL Server 7.0 doesn't. If you're really going to do this, I recommend this book. Read it slowly, if you have the luxery, using the exercises to practice upsizing with a fake DB or two -- anxieties will fall quietly away.

Regards,
Tim
 
Tim,

A little late but I want to thank you for recommending the SQL/Access Book. I am reading it slowly and keep it on my desk at work. I would suggest this manual to anyone!
 

Users who are viewing this thread

Back
Top Bottom