Some files can contain viruses...
"Some files can contain viruses or otherwise be harmful to your computer." How to disable the annoying warning message?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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.
(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
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.
I would like to make a parameter query to show files which were current at a particular time period - I.e. files that were received on or before a certain date (to be entered) AND files that were completed on or after a certain date (to be entered) OR files that are not completed (completed field is null).
The sheets I have looked at have headers and the data doesn't start till row 12 or so. Only one sheet per file.
Here is what I need to happen:
The excel files, all of them, would need to be opened and have a copy paste special to get rid of the formulas in the excel files, then saved.
Then all of the files in a specified directory would need to be imported into a specified table in access.
I don't know much about doing this in vb, but I am thinking that is where this needs to be done.
In the be I have the main db with fields required for the files and I have another database (table 2)with similar fields that I use to generate an email form that workers fill out to request files.
Access then automatically pulls that data from the email form and inserts in to table 2. I pull those requested files then enter the data in to table 1 so that I know the who/what/where of a files location.
I want to be able to automatically insert info from table 2 into table one after I have pulled the file and checked it out.