Topics Search

Some files can contain viruses...

Some files can contain viruses...
Views: 57
Whenever clicking a URL to an exe, Access always pops up a "Microsoft Office" warning dialog window:
"Some files can contain viruses or otherwise be harmful to your computer." How to disable the annoying warning message?
Sponsored Links:

More topics

 

Suppress Office warning when running batch file from within access 2010

Preview
I have a batch file that runs when I click on a command button on a form. It makes a backup of all my files and resources for the database. When I click the button, Access gives me a warning saying:

Opening G:\PayrollDataCenter\Data\Resources\PDCbak.bat
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.

Would you like to open this file?

Yes/No

Is there a way to keep this window from popping up?

I've tried "DoCmd.SetWarnings False" but it didn't work
 

Virus Security Warning Opening PDF

Preview
I have a cmd button that opens pdf files saved on the server. This works fine on a number of PCs but on 1 machine the user keeps getting the warning:

Opening server\xxxx\xxxx

Some files can contain viruses or otherwise be harmful etc etc

Would you like to open this file - Yes / No

The file is opened using the following code to construct the file name so it does not use a hyperlink field on the form which I know is a problem.

stCompanyName = "Haulage"
stPricingFile = Me.PricingId & stCompanyName
stFileName = "S:\CRMQuotes\" & stCompanyName & "\PricingMatrix\" & stPricingFile & ".pdf"
Application.FollowHyperlink stFileName

Macro security is set to low
 

Comparing a table or query from two different files

Preview
I have a lot of Macess files, sometimes I want to compare two tables from two different files if they have same information or one file is missing information the other file has. For exp. I have a lot of addresses in all the files.

I want to update one of two files. How do I compare these two files. Both files should have same First and Last name . Id appreciate answers.
 

Updating all the references to external files in .accdb files

Preview
Does anyone knows a solution to change the path of the linked files in an Access database file? I'm thinking in a script, first we need to get the list from the accdb about the existingfile references, then modify them.

It is required because all the files will be moved from their current places to another file share so these accdb files will lose their connections to the linked files and they will become useless completely.

Somehow these paths need to be updated automatically. We are talking about hundreds of files, there's no solution to do it manually, it is impossible in a short term.
 

Access - Automatical retrieve files

Preview
Dear MS Access super users.

I have another question regarding the validation data project that I am currently working on.

I need to validate two CSV files everyday.
However I have a concern right now, since I receive 2 CSV files everyday and I will be using MS Access to compare the two files everyday.

Is it possible for MS Access to automatically retrieve these files and allow user to compare the files?
 

Importing multiple files at once

Preview
I really need some help. I am looking for an easy way to import multiple files (50+) Pipe Delimited txt files into a table (Append to all 1 table) so I can do some data manipulation. All the files have a different file name; however, have the same layout. I am not too familiar with VBA.
 

Importing multiple files at once

Preview
I am looking for an easy way to import multiple files (50 ) Pipe Delimited txt files into a table (Append to all 1 table) so I can do some data manipulation. All the files have a different file name; however, have the same layout. I am not too familiar with VBA.
 

Converting excel files to access files for an online nursery plant pricelist

Preview
I have some 2010 excel files with thousands of rows of information that I have used for years to produce our nursery online pricelist. Now we are re-organizing our nursery and pricelist and I want to convert to access files. But I have several questions.

(1) When I convert each file to access it seems impossible to get rid of the root excel files. I guess that could be a blessing because it would be easy to modify through the root excel files. But I wonder if in the long run it might some way be a problem.

(2) I would like the primary key fields to be the plants names rather than numerical code and I wonder if that will work ok.

I tried to attach sample excel files to this note but my 2010 excel files were not accepted
 

Where to added/install a database file in Windows 7

Preview
I have an A2007 file with a lot of helper files such as Office templates, and icons and other files used by Access to do its job e.g. an ini file for settings and multi language things.

in XP my installer program I made myself created a folder in the Program Files folder of the users computer and these files were saved there.

I then put a link on the users desktop to a small program that called the database.

Now we are going to big school now and I have to create a new installer for Windows 7.

So my question is where should I be saving my files.

I notice that if I now want to save files in Program Files the user is going to have to elevate my .exe or other program under UAC.

It seems that what I have to do now is save my files in two places. Static files that are only read can be in program files and then anything that is read and written to such as a userssettings saved in an .ini file would have to be in there own user folder.
 

Hyperlinks in access

Preview
If a field contains multiple files that need to be hyperlinked in a column, do I need to separate those files into different columns?

In other words, only one file per hyperlink per cell in Access?

now I have three files stored in one column, but they all have different hyperlinks. When a link is created, all three files go to that URL, but this is not wanted.