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 - 2000-09-20 : 18:21:45
|
Joel writes "Hi all,
We have a programme in Visual Basic who is based on record level access. Our database is AS/400 db2 and Access 2000, they have both record level access. In access we can utilise the 'seek' methode and indexe properties of ado.
Now we want to go in Sql server 7.0 in place of Access 2000 but
Sql server is not or does not seems to be a record level access database the ado seek methode is not supported.
What we wont is find a metode(Stored proc, vb code, function t -SQL etc...) that will mimic the seek methode that will permit us to read or Fetch next from a specified key value.
Software: - WinNT 4 (SP6)
- Vb 6 (SP3)
- Sql server 7 (MSDE)
Thank !!" |
|
|
|
|
|
Record level access !!