new project, existing data, opens read only

  • Thread starter Thread starter Dan H
  • Start date Start date
D

Dan H

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.
 
-----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-----
 
Back
Top