Queries

[Albano]

I'm trying to desable table delete confirmation for the make table query,but the confirmation holways apears.

I did go to the tools menu and on the Edit/Find tab and desabled the options Document deletions and Action querys from the group Confirm, but nothing works.

Someane have an idea.

Thanks Albano

 

[scking]

In code:
Turn off = DoCmd.SetWarnings = False
Turn on = DoCmd.SetWarnings = True

Steve King

 

[Albano]

Thanks Steve King.

Albano

 

[books]

Trying to copy an Access file to 3 1/2 floppy. File has 193,000+ bytes. Message says it's too big for the disk. If I delete half the file, I still get the message that it's too big. What can I do?

 

[PaulF]

use a compression utility such as PkZip or WinZip to compress it to a .Zip file, and then copy it to the disk, then use the utility to uncompress it when you load it onto a different Pc.

PaulF

 

[PaulF]

another thing to try prior to the compression utility, is to Compact the database using the installed compacter. Access doesn't remove deleted data until you run Compact, so databases grow and grow. Click on Tools - Database Utilities - Compact Database
for Access 97, and Tools - Database Utilities - Compact And Repair Database for Access 2K. This might reduce the size to less than 1.44 Mb

PaulF