98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · High Priority · Version 2003
Thu 5 Feb 2009, 16:38Delegate Lita said...
Lita has attended:
Access Introduction course
Word Intermediate course
Word Advanced course
Access
I am trying to set up various forms and queries for the forthcoming tax year. I am using the same procedure as I did for last year, however before I can set up my forms, queries etc I need to amend our database table to include values for the current year. I have tried doing this in exactly the same was as I did previously but it is telling me that the table is linked and cannot be modified. I have not linked the table, as far as I am aware there are no other tables or sources for it to be linked to (and I am the only one that uses Access). Any ideas?
Fri 6 Feb 2009, 00:52Trainer Rajeev said...
RE: Access
Dear Lita
Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.
Before I can provide you any suggestion I would like to know if you see any blue arrow in front of the table that you are opening for amending?
Did you originally create that table from scratch yourself or did you inherit this database from someone else?
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Fri 6 Feb 2009, 08:27Delegate Lita said...
RE: Access
Yes it does have a little blue arrow in front of it. The table has been set up for years, before I even started working here. I had no problem last year with updating this information.
We had problems with our computers a few months back and I had trouble getting into Access and looking at any of the data. Our computer guy at the time fixed this for me but used the words "i'm not sure if thats the right way to do it but it works". Could it be that he has done something to it?
Sat 7 Feb 2009, 11:22Trainer Rajeev said...
RE: Access
Dear Lita
Thank you for your response.
What I suspect has happened to your Database is that it is split. Databases are normally split when you want to let multiple users enter data simultaneously.
Normally we do cover splitting of databases in our Advanced level so I am not sure how much of what I am about to explain you will be able to understand.
Normally when you split databases you end up with two separate databases known as Back End and Front End.
Front end database is installed on the end users' computers (known as workstation) and the Back end is saved on the server which the end users have no access to. The Back end ONLY contains the original Tables and NO OTHER OBJECTS.
The Front end has all the other objects such as Queries, Forms and Reports, etc... Front end databases also have linked tables that come from the Back end databases and that is why you see the Blue arrows in front of the table/s.
I suspect that in your case it is possible that when things went wrong with your computers either the Back end database was corrupted or has been put some other place.
You need to locate that Back end database to re-establish the link to the linked tables in your database.
If you choose Tools > Database Utilities > Linked Table manager you should be able to find out what the name of the Back end database and the location of the database was. I am hoping your technical person should be able to help you out with this.
It is a possibility that you may have to locate your original database and split it again for things to work properly.
What you need to do is try to find either the Back end database (normally back end databases have _be at the end of their names). In the meantime I'll try to research if I can help you re-establish the link again to the linked table.
It is also a possibility that the database wasn't split and your table has been linked to another database. The Linked Table Manager should be able to help you locate the name of the database for you.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
