VB4 with Access: How do I lock the file to compact it via Dbengine. 
Author Message
 VB4 with Access: How do I lock the file to compact it via Dbengine.

I have a large access .mdb as a back-end to a VB4.0 application under Novell. I
want to be able to compact the database via the DbEngine compact method. Is
there some way I can lock the .mdb so no one can get to it while the maint. is
being performed?

If you can e-mail me a note (and post) I'd appreciate it as it takes a while for
my ISP to update the VB groups.

Thanks,

Paul Raymond



Wed, 27 Oct 1999 03:00:00 GMT
 VB4 with Access: How do I lock the file to compact it via Dbengine.

Open the datbase as exclusive.

Set Db.opendatabase("xxx.mdb",1)

that should do it.  You might want to see some of the other options that
are available to you as well.

PS:> When compacting a database, other users won't be able to access it any
way.  

Quote:
>I have a large access .mdb as a back-end to a VB4.0 application under
Novell. I
>want to be able to compact the database via the DbEngine compact method.
Is
>there some way I can lock the .mdb so no one can get to it while the
maint. is
>being performed?

>If you can e-mail me a note (and post) I'd appreciate it as it takes a
while for
>my ISP to update the VB groups.

>Thanks,

>Paul Raymond



Thu, 28 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Compacting MS Access file via SQL

2. Accessing Paradox files via VB4

3. DBEngine - Lock files

4. Custom Locking code for Database Locked in VB4 with Access 2.0 - HELPPPPPP

5. For can't get focus while using DBEngine to compact

6. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file

7. Compacting Microsoft Access Database via ADO problem

8. compacting access databse via visual basic code

9. compacting access via vb

10. Compact an Access database via ASP

11. Sending Files via Modem in VB4

12. Parsing ASCII data into an Access Table via VB4.0


 
Powered by phpBB® Forum Software