Re: new project, existing data, opens read only
From: MGFoster (me_at_privacy.com)
Date: 07/16/04
- Next message: nafis: "hi"
- Previous message: Malcolm Cook: "Re: Can't Open Table Design View after Moving Database"
- In reply to: Dan H: "new project, existing data, opens read only"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 16 Jul 2004 00:55:40 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Make sure the SQL7 tables have a unique ID column (usually a TimeStamp
datatype column) so Access can "see" if the table was updated between
the time you read the data and someone else changes the same data.
-- MGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBQPcndYechKqOuFEgEQIdiACguPJdVoQcR2pj6hwZD2Q/4cc8u14AoO7K 6QUqDvQmbQ2vbT60488b/Mln =1GSu -----END PGP SIGNATURE----- Dan H wrote: > I have converted an Access DB to run on SQL7. I am > attempting to create an Access (2002 and 2003) Project to > manage this DB. No matter what login I put in the > connection properties, I can't Insert or Update records. > All options relating to those things are greyed out. > > I have connected using: > NT login, default settings > NT login, specific permissions to tables (insert, update, > etc) > new SQL login, default settings > new SQL login, specific permissions to tables > new SQL login, DataWriter role (also DataReader, Public, > and DBOwner) > I have even tried with the sa account with the same > results.
- Next message: nafis: "hi"
- Previous message: Malcolm Cook: "Re: Can't Open Table Design View after Moving Database"
- In reply to: Dan H: "new project, existing data, opens read only"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
