Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting records in a 'with view metadata' view

Status
Not open for further replies.
giovi2002

giovi2002

Programmer
Aug 22, 2005
47
0
0
NL
I'm programming a microsoft access project, to provide full security I use views as datasources with the 'with view metadata' clause.

Within one data-entry form I want the records to be sorted different from the primary key. Normally I would use the 'order by' clause but when using this my recordset isn't updatable anymore. Anybody a clue about this?





 
Sort by date Sort by votes
Are you sure that this is the right forum to ask?
Here is SQL Server not MS Access forum :)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
119
Mike Lewis
Mike Lewis
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
137
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
105
Chris Miller
Chris Miller
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
261
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
168
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top