in what order are records , whch have no unique key retrieved in ms access, assuming i do not have an order by in my 'select clause' . In oracle, there is no guarantee of the retrieval order if there is no 'order by' in the query.
thanks,
chandran
Hi, I am using ms access 2003 - i get a maxlocksperfile error when i am performing alarge update..i have performed similar updates before succesfully..worked around this problem by using the dbengine.setoptions setting in my vba script..is there any other work around..when working with large...
We have an existing MS application /database which creates reports when i am logged in as admin.. however, i want to login as a different user with minimal privileges on the forms /underlying tables..dont want user to see the tables/forms..and run all the underlying vba code as admin.. Is that...