Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ewade
Starting Member
36 Posts |
 Posted - 2002-02-25 : 16:54:50
|
| This one has me totally at a loss... I created tables on SQL server, created logins and assigned permissions. I then created a front-end in Access, which worked fine until one day. Now, it seems that no matter who the login is set to from Access (even "sa"), only SELECT permissions are applied. I've verified through the Enterprise Manager that permissions are set to include SELECT, INSERT, UPDATE and DELETE on these tables, and I can add and manipulate data from the Enterprise Manager.Does anyone know why I can't use my Access front-end anymore? I'm sure this is a SQL server issue, since I've tried creating a new Access DB with linked tables to the same data source AND tried creating some simple Active Server Pages as a test, yet I still bump into this problem.Never stop learning! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-25 : 17:02:21
|
| Did you change anything else about the SQL Server database, like add replication? Did you upgrade any software on the SQL Server (service packs, MDAC, etc.)? Do all of the tables have primary keys? Access is finicky about this (ODBC actually), it won't allow UPDATEs unless the tables have a primary key.Have you tried creating a brand-new DSN and use that to link tables? Have you updated your MDAC components on your client computers? If you're not sure, go to this site:http://www.microsoft.com/data/download.htmDownload and install MDAC 2.6 SP1 (if you have WinXP, then download MDAC 2.7). Reboot your computer after you install it (even if it doesn't force you to), then try creating a new DSN and link the tables using it. You should also apply the new MDAC components to the SQL Server machine. |
 |
|
|
ewade
Starting Member
36 Posts |
Posted - 2002-02-28 : 14:31:07
|
| Actually, no, there is no replication in place, all tables do have primary keys, and nothing has been added to the server. I still think that it's a permissions problem, since I can't update the table contents through any method other than using the Enterprise manager.I've already got the most recent MDAC components installed on my test machine, the SQL server, and the web server.Never stop learning! |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-28 : 16:19:49
|
| So you have used ASP and logged in as 'sa' and it still didn't allow you to update?That seems very odd. What error do you get?-Chad |
|
|
|
|
|
|
|
|
Odd permissions issue