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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-13 : 08:31:59
|
Jason Woolf writes "SQL Server 7 - Access 97 - NT
Hi - this seems like a really naff question to ask but it has me stumped.
We have developed a data warehouse for use over our intranet for 100's of users, however it has a number of look up tables, and we wanted a quick and simple way to update these tables for half a dozen administrator/users.
Simple we thought just link the lookup tables to an access front end and set up the required fields in a simple form. Each of our tables has 3 fields - ID, Key and Description. We have hidden the ID field allowing only the Key and Description to be updated.
The ID fields on the underlying SQL-Server tables all have their ID fields set up as identities. The access forms to show the data are set as continueous forms so the user should be able to scroll down and edit any row they wish - we have used contiueous from instead of data sheet for presentation purposes.
Okay now the problem:-
Some of the tables allow us to add records no problem - and some allow us to add records and when you move to add another you get a #deleted in the field - if you exit the form and go back again the values you entered are there - so really it seems to be a cosmetic issue - refreshing the form does not work - so you can replace the recordsource but the the focus shifts back to the first record - yes I could movelast but surely this is wrong???
I have checked all of the tables and they all appear to be set up the same - are you aware of any difficulties with Access to SQL Server - should I move to Access 2000????
Best regards
Jason Woolf" |
|
|
|
|
|
Using linked tables to access front end