how to limit vb DataReport to show only the first 200 records to secure my mdb ?

Perhaps a better idea would be to bind your DataReport to a query that has SELECT TOP 200 in it.

As for securing it, you can check out the links that myself and Computron posted here

https://www.experts-exchange.com/questions/21784678/Change-Jet-DB-Password-from-within-VB.html

regarding setting the database password / userpassword on the fly.

Dear Jimhorn and Dear Leclairm,
First of all I hope that you accept my apology for being that late to reply to appreciated answers since i was away
and busy somewhere abroad...

regarding my question...about making a query I thought this may take a big file size on the user HD each time to create
a query...Besides I really do not know how to do this if it is a practicle thing...

I want to avoid securing my mdb by a password... Iam doing this program without having learnt any course in programming it is as a hobbey so do not bother by stupid answer if I tell you I could not follow the link you gave...

folk I do not want to be rude but if I do not hear from you the next 2 hours I will split the points
and again I do apologise for the whole issue... thanx in advance.

Also, if you want the easiest way to password protect your mdb,

open the database in exclusive mode (file/open, then choose open exclusive on the "open" combo box)

go to tools/security/set database password.

This will prompt you to type and retype a password that will be required each time you open it.

Cheers,

Mike

Thank you Both for your patience that was helpfull and I'll try this out...
:-)

Thanks for the split.  Good luck with your project.  -Jim

You're welcome and thanks for the split.