• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

Access 2007 Database

I have a database that was working fine until last Thursday and the database was not touch since then now when I open it I am getting this message " The record source 'Control Master' specified on this form or report does not exist" I am 100% nothing is missing or moved.  I was looking for how to repair the database but I can not find it.. I look online and the only thing I can find is convert.  thank you,
0
ThermoPort
Asked:
ThermoPort
  • 14
  • 11
  • 4
  • +1
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Have you tried a Compact & Repair on the db?

mx
0
 
ThermoPortAuthor Commented:
I tired the Compact (could not find the repair) but nothiing happen, told me to close the db and I did but still nothing happen.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Can you upload the db?

mx
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
danishaniCommented:
Did you by change renamed your Controlsource and the old name is still in your Form?

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
No I did not, the  only thing that was done to this database is I moved a copy on another server and my problem started. Uploading db right now.
0
 
danishaniCommented:
Is your database split into FE and BE?

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
Here is the db
contapp2000.mdb
0
 
danishaniCommented:
Hi again,

On first check you have indeed split your database. It gives me the message;
'L:\Rebate contracts\Contracttables97.mdb'

Which is problably your Back End database where your data has been stored.

When you move your backennd/rename your backend, re-link your tables with the Back End again.

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
This should be fun, I have never work in Access 2007 only 2003 and I have no idea how this db was created. The gentlemen that created it is no longer with the company.  The Contracttables97 is a large file.
0
 
danishaniCommented:
Yes, the file you posted is the Front End containing the Forms, Querys, Reports and Modules.

So relinking your table will do the trick, click on the Linked Table Manager;

Select all tables, then click Ok, then select the BackEnd database in which all the tables are stored and then Click Ok.

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
The Linked Table Manager is grayed out, I can not select any tables.
0
 
danishaniCommented:
Click on one of the Linked Tables in your database, then Right click on this table, you will see the Linked Table Manager. That should do the trick.

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
I did that and this is what I get, I have upload print screen for you
linked-table-manger.bmp
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The LTM is not grayed out for me ...

mx
0
 
danishaniCommented:
I think because you are in the BackEnd database, you need to Relink the tables in the Front End database ( the one you have posted on this thread).

You can not re-link to itself.

HTH,
Daniel
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Did you due a 100% FULL install of Access with ALL the options?
The LTM is not installed by default.  You have to select ALL options during the install.

If this is the case, you should be able to go to Add-Remove programs, select Office>>Access and add the optional components.

mx
0
 
ThermoPortAuthor Commented:
I miss-understood the posting, :) I have the db open how to I see the tables?
0
 
danishaniCommented:
You open the Front End database, then you see the table (with an arrow pointing to it), so you know these tables are linked. If there is no Arrow in front of it, (as you can see in your picture you have posted) you know that these are not linked, and thus assuming the Back End database.

So you click on the Linked Table and then you will see the Linked Table Manager available to you.

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
I think that is the problem, I am not seeing any tables it must be hidden or protected. I only get the main menu.

Thank you so much for spending a lot of time with me.
0
 
als315Commented:
Your picture is very strange. All tables in it are local, not linked, when in uploaded DB they are linked. When I've triedto open one macro, DB falling down and was auto "reconstructed". May be now it will work? Test it.
contapp2000.mdb
0
 
ThermoPortAuthor Commented:
I just find the Linked Table Manager in the menu along the top. I am going to select all and give it a try.
0
 
danishaniCommented:
Click on the F11 button, then your objects are there at the Left side of your screen.

Then proceed with the above procedure/ steps I provided.

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
I thnk THAT DID IT, Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
0
 
danishaniCommented:
You are very welcome, glad to help and assist, and please be so kind to give me some credits (helpful comment), so I am working my way to the Premium Services.

Many thanks, and glad you got it working! :)

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
Thank you, you have made my week even year!!!
0
 
ThermoPortAuthor Commented:
do you think you could help me with one problem, now that I have moved the db onto another server is there anywhere iin the db that I need to change to the new server.
0
 
ThermoPortAuthor Commented:
How can I find an IP address that someone put int this database. I have to change the IP to the new server and don't know where to find it to change it, any ideas?
0
 
danishaniCommented:
The path has been stored  in your FrontEnd database, the moment you have re-linked the tables to the Backend Database.

So why do you need the IP address for?

HTH,
Daniel
0
 
ThermoPortAuthor Commented:
I am not sure if I do need to the change the IP. I have a bat file (see below) this is put in start menu on the computers that need access to the database. I changed the ip to the new server and run it on my computer but when I open the db it is looking for it on the C:Databases\rebate contracts\cottables95.mdb. It is not seeing my links. The db works great on the server now thanks to you. :)
net use L: /delete
net use L: \\10.11.10.26\databases
0
 
danishaniCommented:
Appearently this is done to first disconnect the user from drive L: and then reconnect to the specified location.

When this is necessary to work, you wont have to know the IP adress, you can use the server name as well.

See below link on how to use the NET USE command;
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/net_use.mspx?mfr=true

If you want to check the IP adress, in MS-DOS screen, cmd;

ping ServerName

See also this article;
http://www.ehow.com/how_5157549_ping-server-name.html

HTH,
Daniel
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 14
  • 11
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now