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 |
|
nhaas
Yak Posting Veteran
90 Posts |
 Posted - 2007-06-01 : 11:08:01
|
| I have a Access 2003 database that we want to convert the backend to SQL. See if it works then create a new front end via .net. Problem is I am getting a read only once we convert to the SQL backend.Access 2003 restricts the tables as read-only and he thinks it’s not an SQL problem. I have links to three tables in the same table list that come from DSN=IFW5, that I can delete from and perform all sorts of operations on, yet the ones that sit on DSN=Tesis are read-only. I’m thinking… why one and not the other?Database has been in use for nearly 10 years and has been converted up to the latest greates once in a while.Any Suggestions,thank you. |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-06-01 : 12:01:33
|
| Access may not be able to edit the SQL Server table if there it has no primary key. Check that first.e4 d5 xd5 Nf6 |
 |
|
|
nhaas
Yak Posting Veteran
90 Posts |
Posted - 2007-06-05 : 12:04:21
|
| Yep worked greate thanks |
|
|
|
|
|
|
Access to SQL