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 |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2002-04-10 : 04:28:51
|
| Dear Folks,I have got a database that was developed in access,with an access front end. Was later moved to SQl Server, so that more people can use it at the same time. In short the problem i am having now after moving this database to sql is that it would not allow me add values to the database using the access front end. But i am able to add values or data on the back end in sql server. Question is what are the possible reasons why iam not able to enter data via the access front end.Thanks in Advance,V David. |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-10 : 04:54:09
|
| you can work with Sql server tables in Access by using Link Table Options-------------------------------------------------------------- |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-10 : 14:40:02
|
| Are you using the EXACT SAME user credentials in Access that you are when directly in SQL Server? Perhaps it's a permissions problem. Have these been somehow marked as Read-Only? (Don't know how you'd do that, just a guess). You might try deleting the link in Access and re-creating it to see if the problem goes away.------------------------GENERAL-ly speaking... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Data Entry