Hi Again People,



I'm having problems loging into the VB discuss forum

therefore I thought I will do it through mail.



I have these issues that I need to find out about the

Access DB. 



1. Normally how many records does an Access DB hold 

   (let?s say its maximum capacity as an average). 



2. How do I insert a password to the Access DB as a  

   whole (& when I do open it through VB is there a  

   special syntax that needs to be used). 



3. Is there a way to give a warning message maybe 

   through some Windows function if an user is trying 

   to delete an Access DB from his hard drive (maybe 

   by mistake) 

 

Please try to help me out.



Thanks.



Sudharshan.



__________________________________________________

Do You Yahoo!?

Yahoo! Mobile - Jazz up your mobile phone!  Get funky ringtones and logos!

http://mobile.yahoo.com.sg/

Sudharshan,



> 1. Normally how many records does an Access DB hold 

>    (let?s say its maximum capacity as an average). 



I don't the answer to this one.  I assume it's a lot!   :)



> 2. How do I insert a password to the Access DB as a  

>    whole (& when I do open it through VB is there a  

>    special syntax that needs to be used).



1) Open Access XP then click FILE | OPEN.



2) Find the file you want to open but DON'T double-click on it.  Instead, 

click on it ONCE, then on the bottom right of that dialog box, choose OPEN 

EXCLUSIVE.



3) When it opens, click on TOOLS | SECURITY | SET DATABASE PASSWORD.  Step 

3 will NOT work if you don't do Step 2 first.



This will set password that people need to open the database.  If somene 

opens another database and tries to import from or link to your database, 

he or she STILL will need the password.



> 3. Is there a way to give a warning message maybe 

>    through some Windows function if an user is trying 

>    to delete an Access DB from his hard drive (maybe 

>    by mistake)



You can set file permissions in Windows 2000.  I don't know about 

Windows '95, '98, CE, NT, or XP.



1) Open Windows Explorer and right-click once on your file.



2) Choose "Properties".



3) Choose the "Security" tab.



4) Under "Advanced" set the properties for that file to "Deny" for 

whatever action you desire.



5) After you're done, THEN copy the file to the shared database.  If 

someone else tries to delete it and you set the "Deny" box, for example, 

it shouldn't work.



I've never done this so I don't know how reliable it is.  Try it on a test 

file first and see.



Good luck!



Greg

I'm not certain about exact records...but, I think 2gigs is what most people

will tell you is the maximum size of an .mdb file.



Darin



----- Original Message -----

From: "Gregory Serrano" <serranog@m...>

To: "Access" <access@p...>

Sent: Wednesday, February 27, 2002 10:11 PM

Subject: [access] Re: Access Issues................





> Sudharshan,

>

> > 1. Normally how many records does an Access DB hold

> >    (let's say its maximum capacity as an average).

>

> I don't the answer to this one.  I assume it's a lot!   :)

>

> > 2. How do I insert a password to the Access DB as a

> >    whole (& when I do open it through VB is there a

> >    special syntax that needs to be used).

>

> 1) Open Access XP then click FILE | OPEN.

>

> 2) Find the file you want to open but DON'T double-click on it.  Instead,

> click on it ONCE, then on the bottom right of that dialog box, choose OPEN

> EXCLUSIVE.

>

> 3) When it opens, click on TOOLS | SECURITY | SET DATABASE PASSWORD.  Step

> 3 will NOT work if you don't do Step 2 first.

>

> This will set password that people need to open the database.  If somene

> opens another database and tries to import from or link to your database,

> he or she STILL will need the password.

>

> > 3. Is there a way to give a warning message maybe

> >    through some Windows function if an user is trying

> >    to delete an Access DB from his hard drive (maybe

> >    by mistake)

>

> You can set file permissions in Windows 2000.  I don't know about

> Windows '95, '98, CE, NT, or XP.

>

> 1) Open Windows Explorer and right-click once on your file.

>

> 2) Choose "Properties".

>

> 3) Choose the "Security" tab.

>

> 4) Under "Advanced" set the properties for that file to "Deny" for

> whatever action you desire.

>

> 5) After you're done, THEN copy the file to the shared database.  If

> someone else tries to delete it and you set the "Deny" box, for example,

> it shouldn't work.

>

> I've never done this so I don't know how reliable it is.  Try it on a test

> file first and see.

>

> Good luck!

>

> Greg

>




>