How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Engineer
Category: Microsoft
Satisfied Customers: 44824
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Question Here...
Richard is online now

We run a very small home business with our database on MS Access.

This answer was rated:

We run a very small home business with our database on MS Access. It all worked perfectly until my mother upgraded the laptop to Windows 10
We have reverted back to Windows 7 but it still won't work
The database won't run and we get "the record source specified on this form or report does not exist"
She forgot to do a back up before the upgrade so we have nothing to revert to. Can you help, I'm sure it's something simple but we did not create the database and are not able to contact the person who created it for us (15yrs ago)
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, a rating is only needed when we are finished.
Can you provide me the database please and I can check it for you.
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
And tell me how to replicate the error
Thank you
Customer: replied 2 years ago.
Hi Richard,
I have tried 3 times to upload the file but each time I get this message
We are sorry, but the requested page has been removed.
ok, may be an issue with the site, go to
And upload it there and give me the download link which is at the top please
Customer: replied 2 years ago.
Thanks. It's
ok, you did not let it upload yet.
Upload it again and wait for it to finish and complete, then get the download link please.
Customer: replied 2 years ago.
I think it should be uploaded under same link. I never used before
Customer: replied 2 years ago.
Did you get the file ok?
Sorry I was not online when you replied
I have the file and see it is made up of two databases, the one you gave me and another with tables in it (linked)
Its likely this is your issue, that this is missing.
Do you have this other database?
Customer: replied 2 years ago.
Yes sorry I was not aware it worked on 2 databases
I have uploaded another to
ok, its still not uploaded yet, let me know when it is please
Customer: replied 2 years ago.
please try It has uploaded
ok, its now all working fine for me so suspecting this is your problem (its not linked)
What do you do exactly to get the error?
I can see you are a first time user to the site. What we do here is either a question and answer type of conversation or remote support where I would actually connect to the computer and have a look and attempt to fix the problem for you.
Remote support can save a lot of time if you are not comfortable performing repairs yourself. Sometimes even with instructions you can make a mistake and make things worse.
I will send an offer through for remote support and should you accept I will connect and see what is going on and fix the issue. Otherwise we can continue to talk like this but I will need to ask a number of other questions and try and walk you through some steps.
Both options are 100% guaranteed by the way. Remote is just quicker and avoids the risk of you making a mistake and doing something wrong.
If you want remote click get extra help. If not simply reply to me.
Richard and other Microsoft Specialists are ready to help you
Thank you
Can you go to on the computer with the problem
Click on Download for Free
Download and install the program and give me the ID and Password ***** please so I can connect
Do not close the program but leave it open else I will not be able to connect
Thank you
Customer: replied 2 years ago.
ID: 837 888 551
Password: 968dhp
thanks, ***** *****
Customer: replied 2 years ago.
Hi Richard
Thanks for your help the other day, however we still have a problem. Looking this evening at the database we notice the content only goes up to 2011 and everything since then is missing. I know when you were looking remotely you mentioned something about an old database - I guess that must be an old back up. In fact it may be when we changed from Vista to Windows 7 - I remember there was an issue then. Could you get back to me tomorrow please ? Thanks Tracey
Hi Tracey
you have a computer where the database is correct?
Customer: replied 2 years ago.
Sorry for not getting back to you yesterday it was such a busy day. No we do not have this database on any other computer. I have tried looking for the extra data file but haven't found it yet.
It must be there somewhere because it was working fine until the update. I will look again today when I get a chance.
Do you have any suggestions on how to find it?
No problem
Check on the computer c:\Timeforyou
I saw in the code it uses that directly so you might have a copy there
Customer: replied 2 years ago.
I found a possible file but I cannot open it as I get the error record source query
hold SHIFT and then open the file please.
Then check for your data.
Customer: replied 2 years ago.
Sorry there's no data, it just opened up and said it couldn't find the tables. So I now realise all the files showing are around 1460kb and are the actual database design except 1 file (that is 13124kb) which is the actual data - but it only goes up to 2011. How can we have lost a file containing the last 4 years data?
someone deleted it. First thing that comes to mind
Did you do a search on the computer for it?
Customer: replied 2 years ago.
I don't see how it could be deleted. I've looked in the recycle bin but don't see an Access file there
okk. well unless you have a backup, one way or another it was removed from the computer, and the only way that can occurring is being deleted, or an older copy overwritten.
Customer: replied 2 years ago.
If it was deleted wouldn't it get moved to the recycle bin?
Not if you held shift when deleting
But I am not sure what more to say sorry, the files not on the computer anymore, how this exactly happened I cannot say, only that it was deleted if you searched the computer and cannot find it.
Customer: replied 2 years ago.
Ok, I don't believe it could have been deleted as I did not know about the SHIFT key thing
There are a load of files on the pc named some version of 'time for you' that I cannot open as they say the table is missing or something along those lines.
How do I open these?
These are not the files you want, you want the file that opens as this is the one that stores the data.
Once stores the data, which you need to find and one links to the data which is the one that gives this error.
Customer: replied 2 years ago.
Hi Richard we have found a back up from 2013 on a memory stick, can you tell me how I make this open as the working database as it opens as the data tables only thanks
No problem, best if I can connect to your computer and do this for you.
Make sure the memory stick is in the computer and then run teamviewer again and give me the ID and Password ***** connect please.
Customer: replied 2 years ago.
I had already copied the file to the TimeForYou folder on the laptop. I will run team viewer now
Customer: replied 2 years ago.
ID 837 888 551 password *****
connecting now