BigJimSlade
Registered User.
- Local time
- Today, 08:45
- Joined
- Oct 11, 2000
- Messages
- 173
Hi, Big Jim here:
I have created links from SQL Server 7.0 in my Access 97 database. I believe I have done everything right:
1) user has read\write privilidges on the table
2) I created a primary key on the table
3) I also refreshed the links after they were created
Yet still the linked table is not updateable in Access on certain computers. I noticed that computers with updated SQL Drivers and the newest MDAC (they go together I figure) work fine. However, I can't ask our IT department to run the latest MDAC on 5,000+ potential users' computers.
Any thoughts would be appreciated. Thanks in advance!
Big Jim
I have created links from SQL Server 7.0 in my Access 97 database. I believe I have done everything right:
1) user has read\write privilidges on the table
2) I created a primary key on the table
3) I also refreshed the links after they were created
Yet still the linked table is not updateable in Access on certain computers. I noticed that computers with updated SQL Drivers and the newest MDAC (they go together I figure) work fine. However, I can't ask our IT department to run the latest MDAC on 5,000+ potential users' computers.
Any thoughts would be appreciated. Thanks in advance!
Big Jim
