Search results for query: *

Ok, everyone said don't try to alter a view from an SP. The problem was getting a SP to be the RecordSource for a report in the Access front end. I put the proc in as the RecordSource and hard coded a parameter and the report ran. Then I make a form where the user entered the parameter in a text...

True randomness is hard to come by. In C and VB both the random numbers are seeded by the clock if you use the randomize function with random. You would have to have a hellish lot of transactions to hit two at once in the same millisecond About all you ever accomplish is the appearance of...

The problem is there are 40 users most of whom are not allowed to see records assigned to others. Theses users need reports. The reports are generated from an Access front end. The reports are altered when the underlying view is altered. When the record number is changed in the view the report...

The thing is that I have something on the order of 40 users right now. No user can see the other useres data with the exception of the headquarters persons (2). The database front end is Access and the reports that the users need are based on the views that they can see. In reality none of the...

Can you alter a view from a stored procedure? I need to send criteria to the view from the parameter of the procedure. I tried putting the ALTER VIEW code right after the AS in the CREATE VIEW statement. The error returned was “Error near key word VIEW”.

I just tried LEFT JOIN and LEFT OUTER JOIN on a query involving two tables that have a common field upon which I made the join. The LEFT table had two records that had no match in the other table. When I ran LEFT OUTER JOIN and when I ran LEFT JOIN I got 1243 records both ways. If I want just...