AVG Anti Virus And Lost Records
Nov 11, 2005
Hello all,
This is stricktly theory but I am wondering if any of you have had any problems with losing records while running antivirus software on a network type solution. i.e. AVG antivirus that uses one computer as the main server and all operations for antivirus software updates etc are run from this server. I am wondering if when the server does an automatic update on a computer if that is interupting the network connection for access (we all know how much access likes that)? I am having a horrible time with lost records. This week there have been three records lost.
Has anyone heard of any problems related to this or had similar experiences? After months of losing records this is just another theory. I don't want to start fooling around with my anti virus software but I just may just to see. Thanks for all your help.
Greg
View Replies
ADVERTISEMENT
Mar 11, 2005
i know this has nothing to do with access but i didnt know where to post my question, i got through msn the last day a link wich unfortunately i opened, i got a virus called W32.spybot.worm and till now i dont know what to do, my system is windows 2000
now i did the scan again and i found in addition a virus called trojan horse
im scanning and blocking the viruses successfully
but this is not enough
pleassseeeeeeeeeeeee if anyone has an idea
View 2 Replies
View Related
Jun 28, 2007
Yesterday, my Access MDB didnt work properly. On scanning, I found a virus infected Access EXE file. After cleaning, my MDB works fine and data was intact. This has prompted me to ask these questions.
1. Can a virus attack an MDB?
2. Is it possible for data to get corrupted if I work (unknowingly) with infected Access EXE?
Grateful if members could share their experiences.
View 13 Replies
View Related
Apr 11, 2007
Hi All,
We've just had a power cut and 2 of us were in the process of adding a record to the database. The primary field is an Autonumber and, on re-entering the information for the record, we have found that 2 numbers are missing.
Ie. instead of record numbers 1,2,3,4, we now only have 1 & 4. Is there any way of retrieving 2 & 3?
And is there something I can/should do in order to prevent this problem from reoccuring?
We have the Autonumber facility so that, when we add a new record, it automatically enters the next number. Is there a formula I can use so that the default value when adding the record is the number of the previous record + 1?
With thanks for any assistance.
Ronnie
View 4 Replies
View Related
Jun 2, 2006
OK,
I work for a political party. I work with voter history information. Normally, I am doing queries in order to bring up particular voters, and eliminate others.
Example - the basic table I work with contains the names, addresses, affilitations, and voting histories of everyone in my county. I normally query to bring up voters of a particular party, or people who voted in a particular election or number of elections or both. I more or less sort voters out, but in a positive manner, by creating tables with voters who did a particular thing.
For example: out of all the voters, I just want Democrats who voted in two of the past three primaries. I would then get a table that contained just those voters and no others.
Today, though, I was asked to create a table that would exclude voters based on their behavior, exluding voters who did a particular thing but showing everyone else.
Example, I have a request for all of the voters in the county, except those who voted in the 2004 and 2002 primaries. I know how to create a table with those voters and no others, but I don't know how to query for everyone but those voters. Can anyone help?
View 2 Replies
View Related
Oct 2, 2006
I need a query that shows the "not chosen" values.
That is:
I have table with MANY entry. If I choose FEW (query parameter) how can i write a query that show SOME=MANY-FEW
Thanks
View 3 Replies
View Related
Mar 18, 2008
Here's an odd one for you, but I bet it has a simple answer.
I have three tables: the first one is a list of orders, the second is a list of wages that should be paid out should a transaction fall into a certain range, and a table that has a list of the orders that should have those wages assigned. (any order not in the third table should be paid a static wage, no changes)
I made a query for any record that would need this list of wage ranges. The first and third tables (the orders and the list of orders that should be with the wage range)
SELECT completed.*, WageList.Wage
FROM WageList, [Pay for Performance List] INNER JOIN completed ON [Pay for Performance List].[Order Number] = completed.OrderNumber
WHERE (((completed.Eff)>=[WageList]![minPercentage] And (completed.Eff)<=[WageList]![maxPercentage]) AND (([Pay for Performance List].[Pay for Performance?])=Yes));
This query works just fine, thanks to the help of several people online here. Here's the problem: a second query would have to cover those records that are NOT part of the list. Since the two tables are linked in a one-to-many relationship, how do you ask for the records that are NOT part of the one side of the table?
View 2 Replies
View Related
Jan 30, 2006
Hi
I was wondering if any one could help me.
I have a database at work with 5500 records, how ever the first 1000 have been lost. There remains records for each customer but the first 1000 records showing what they ordered have disapeared.
I have back ups of the database going back with the first 1000 records complete.
How would i take the 1000 records and add this to the current database where the information is missing? so it wouldnt mess up recent records?
could some one provide me with a step by step account. Would be much appreciated!
Many thanks
View 4 Replies
View Related
Jun 3, 2013
I'm getting an import error that records are being 3 records being deleted and one lost due to violations. However when I go back to check the data that was imported I can't find anything missing. Any clues on what could cause the error but still import the data.
View 1 Replies
View Related
May 19, 2006
Hello,
I'm merging de-duping contact data from 2 tables with the same fields. One table is the master (lets call it X) and the other is new data (lets call it Y).
However, it's not a simple as adding the new recordset to the old recordset: there are many dupes - sometimes X data needs to be replaced with Y data, sometimes the X data is more comprehensive than the Y data so the Y data is discarded, but often Y and X records for matching email addresses needs to be merged.
I currently have a union query joining the two tables (X and Y), upon which a make table query is based. A de-duplication query has been based on the resulting table of all records (X + Y), and exact duplicate/fragment 'Y' records in the table have been removed.
I have in my mind a diagram of a right-outer-join query (where the left table is X + Y and the right table is the original table X) - and I want the data that would be excluded from this operation. I have come across un-join queries in discussions relating to Oracle, can I use this operator in Access or is it incompatible with the Jet engine?
Would I just be able to use "IS NOT" somewhere in the right-outer-join query instead?
Please help! Thank you!
View 4 Replies
View Related
Jun 21, 2007
i have just had a problem
if i try to edit an open form by clicking the design icon, i get a message
cant find the call back function or macro "fdesign". ican still close the form and open it from the dbs window
this is affecting accessXP and access20003, but not A97
ive tried repairing/reinstalling the XP installation (but not the 2003 yet), but this has not fixed it.
Any thoughts?
View 5 Replies
View Related
May 23, 2007
I have a table and it has:
namefield
surnamefield
state1
state2
state3
match(Y or No)
importDate
I would like to make a query+ report so that in the report it looks like this:
<<Name>> <<Surname>>
<<state1>> <match>
<<state2>> <match>
<<state3>> <match>
in one line, at the moment I made a query and the name shows 3 times...
can anyone here give me some hints how to show the name once + the match. Thanks in advance
Cheers...
View 2 Replies
View Related
Sep 26, 2007
I am new to using MS Access and am already frustrated that a simple task is getting the better of me.
My situation is that I work for a company that has a number of reps, which are allocated their own ticket books(block). Each book is 50 tickets in size i.e say from number 320500 to 320549. All tickets are entered through our internal system for whatever the ticket was used for.
Now here is my problem. Each block is registered to an individual rep which we need to keep record of as to which tickets are allocated to them, other then having to enter each ticket individually into our ticket block records system, I am trying to make a database entry that accepts the reps name, ticket block start number and then automatically adds the next 50 tickets to that rep, so when we use a search field on any ticket it displays the rep that the ticket was allocated too.
In my head i'm looking for the MS Access way of doing the following:
[tickblockstart]+1 until [ticketblockstart] = [ticketblockstart]+50
Can anyone help me with this probably very easy problem, that i can not seem to grasp at the present time.
Regards
2rsGarry
View 2 Replies
View Related
Nov 16, 2005
hiya, im trying to create a button my form that will move all 'finished' records from where they presently are, to another table.
the button does work, it moves the records into the 'new' table, however it does not DELETE them from the table i moved them from, so now the records are stored in two tables??
the code i have is as follows:
SELECT * INTO Table2
FROM Table1
WHERE Finished='Yes';
if there is something different that i should be doing, or a better way to do this move, please let me know.
(also if this is in the wrong section feel free to move it)
thanks!
View 5 Replies
View Related
Nov 2, 2006
:confused: Fingers crossed I'll get some direction to resolve an issue that I can't even begin to imagine how to search for.My database is used to record detailed work done with clients who are receiving regular support. I'm designing it around a Common Assessment Support Framework that I have no choice but to follow, except for some minor points. There is the potential for approximately 40 different assessments for each client and therefore a lot of duplication in personal details.So far this forum has been a great help and I have learned a lot from those who volunteer their time to those of us who need it from time to time.Following the numerous examples of normalisation posts I have attempted to ensure there is no duplication of information across tables. I've come to a point however where I am stuck:The end result of what I am trying to do is create an individual report called Needs Assessment Planning Tool - rptNAPT.The report will be populated from the fields in qryNAPT that is made up from tblIA1 and tblIA2tblIA1 consists of 17 x 'area of need' that is broken down in to 5 elements: 'Now - Y/N', 'Later - Y/N', 'User Level - Number', 'Worker Level - Number' and 'Disagreement - Memo'. These fields are entered by using frmIA1, and these fields are entered by using frmIA2.So, now I have to enter data in to another form; frmNAPT that includes both theseand thesefields. I only need to show the area of need where Now is True in the form and the subsequent report; rptNAPT.My thoughts about this are (please don't laugh) in the form frmNAPT the 'Area of Need' because in the table there are 17 different areas e.g. Accommodation (improvement), Homelessness, DomesticViolence etc will need to be unbound and in some way filtered to show only those area of need where fldNow is True? and fldUserLevel is NotNull or doesn't equal zero. I will need a minimum of five such fields to show the Areas of Need that the Client and Worker may elect to work on.Sorry for the long post but I'd really appreciate some direction on this, even if it is only to point me in the direction of a link that can be helpful.RegardsDoug
View 5 Replies
View Related
Jun 22, 2005
I created a DB in an old PC of mine for a customer. I set passwords for user accounts to prevent users from accessing the design etc. I bought a new PC lately and I want to open the DB to work in it but I get an error saying that I do not have the rights. I suppose I need to create the same accounts in my new PC as in the old one but I don't remember the username or password that I was using back then. Any Ideas???
View 4 Replies
View Related
Jul 13, 2005
We have lost an MDB file. Is there a log file where command calls to Access are stored so we can try and recreate the database?
View 1 Replies
View Related
Jan 19, 2006
My database queries, tables, and reports is growing. Is there a function/utility that will show me for a particular report what queries, and tables that are used to gather the data that populates the report?
Thanks!
Gunner...:confused:
View 2 Replies
View Related
Apr 24, 2006
Greetings,
I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs.
How do I restore it?
~rbinder
View 2 Replies
View Related
Jun 19, 2006
I'm completely lost on how to get started on security. After reading all these postings I'm more lost then ever. What is a backend and frontend security? How do you create password for each users? etc...
Please help!
FYI I'm using Access 2003
View 1 Replies
View Related
Mar 29, 2008
Good morning friends
My database, I don't know what happend to it.
I'm trying to open it but it gives me a message:
"The form name 'Welcome Screen' is misspelled or refers to a form that dosen't exist' If the the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name."
and then after I click ok it open the database but it doesn't show my forms, Reports, Macros or Modules that I have created before.
what does it mean, may I lost all my previous work and data ??? :(:(:(
Please I'm waiting you ... I'm about to lose my mind
View 10 Replies
View Related
Jun 19, 2005
I have been trying to figure out comboboxes and lookup tables on and off for two weeks now and am completly lost. I have read the tutorial on cascading combos. I have downloaded and studied the the autofill db example from Pat Hartman. I have searched and read the threads and am still having a problem. I have several lookup tables. I will use one as example. This a database for my lawfirm. We get a lot of referrals from other attorneys. I have a lookup table with the name, address and phone of all attorneys. I have a combobox on my clientinfo form that looks up the atty info . I put the attorneyid field in my clientinfo table as FK and linked my clientinfo table to the attorney table thru this field. All this did was generate an error message that I could not save my record because there was no corresponding Atty record. I know this should be so simple. Can someone please help me? What do I with data I have lokked yup from a lookup table and how do I link it to the tables that will need it later on? Thank you in advance.
View 2 Replies
View Related
Nov 9, 2005
Good afternoon all,
Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached)
Basically, I want a DB for keeping track of service / repair of electronic machines. Many of our customers also call us for tech support. There are a number of other items like purchases but once I have worked out one, I can then copy the methods.
Are my relationships even remotely correct?
I cannot get the calls log to work - loosly based on the sample a supplied with Access "contact managment".
:confused:
Any help / advise would be greatly received
View 3 Replies
View Related
Mar 24, 2006
I have 5 forms and 5 tables.
The database is blank, but the information entered into the forms are saved into the tables.
Now I want to make a query so I can see some statistics regarding the information entered into the forms and stored in the tables.
I have created a query, but Im not sure what to do next, do I connect it to the query and it should give me desired output or do I connect the form to the table
or how does it work ?
need some feedback Im a little bit lost in this :(
regards
Frodo
View 1 Replies
View Related
Sep 2, 2006
I recently moved by database from one hard drive to another - all is working ok after refreshing the links. However I have a few queries and reports that are date or date/time specific. (ie; I input a specific start / end date or start/end hour) Now when I run these queries it returns an error message stating 'Data type mismatch in criteria expression'
Please does anyone know why and how can I restore the queries ? Prior to the move all queries / reports worked OK.
Best Wishes
Richard
View 1 Replies
View Related
May 18, 2006
Hi there.
I have a form and on open it traps the user into a combo box where an option must be selected before they can move to another field. I did this by using the lost focus event of the combo to check if an option has been selected and then return the cursor to the combo if no selection has been made.
The problem is that there is an exit button on the form which the user must be able to use to exit the form without interacting with it, say if they opened the form by mistake and just wanted to exit immediately.
I cant find a way to trap users into selecting an option from the combo before filling the rest of the form while still allowing the exit button to work. At the minute you still have to select an option in the combo even if you just want to exit the form.
I have been a notes developer for years so I’m still not that familiar with access and the way its events work so this could easily be a gormless question. Feel free to point that out. Any comments would be much appreciated.
View 3 Replies
View Related
