Search results

The field names haven't got any spaces. Only one of the tables has but the database has been working fine so far. I am just a bit worried that something might happen in the future and just before I train people to use it I had a look and found this mistake.

Parameter value issue is sorted, but not 'changed table name' issue.

I think I have the answer for re-linking tables, but I don't know whether I need to delete all at first or just update them rather. (Exernal Data > Import & Link > LInked Table Manager). I tried to update it at first, but my renamed tables don't want to be linked. 1. An error message comes up...

Thank you, Chris. So I have changed the name of 2 tables and added some fields to others in the back end. What is the next step? How can I re-link the modified back end table links to the front end? The database has a password. One for the front end and one for the back end. Will these be...

Thank you, Paul. These tables are mainly 'drop down' lists of fields. Would it be a problem if I don't change them at all? The main tables are without space. The database has got a hundred queries and reports, do I need to go through them individually? Many thanks, Susanna

Hi there, I have created some tables but I used names with space. I split the database to back end and front end and I am a bit worried that adding space to the table's name will cause problem for me in the future. Can I just simply change the name or will I loose the data from the table if I...

Yes, they are lookups via Combo box. I will look into how I can change them, before I split the database. I would like to avoid that someone else adding an extra word to the list in the combo box while they are adding new records, as it is very likely that they do a spelling mistake. Many...

Hi, I would like to split my database but as it has been suggested I need to make the tables almost perfectly finalized before I do that. I have a lot of 'drop-down' tables and the content of those needs to be extended sometimes. Would I be able to make these changes if the tables are in the...

By the way we back up the server where the database is every day. Could I just get the backup and sort out all of the imports to a new database built in 2010?

Hi, I have built a database in Access2003 and sorted all security by the workgroup administrator. Roughly a month ago I have converted to 2010. Now it is crashed. I haven't split the database yet as I was using it solely so far and I haven't set up a password either for the 2010 version. I...

Hi, I am facing to a problem again and again, when I try to open my database, which I have previously set up a password for. Occasionally it happens that Access doesn't request the password when I open the database. (The password was set up by creating a system file on the server and making...

Hi, I really hope that someone can help me with this. I try to set up passwords for a few people. I have put the database on the server and I used the Wizard, but something went wrong. I think I haven't deleted the default Admin and User group. The database can be opened on other computers, but...

Thanks for you both. I don't really want to split the database. I found the whole thing far too complicated. What is the danger of putting the database onto the server and just make it accessible for other either as a read-only or as an editable version. I tried to look into this in the Database...

Hi, I would like to share the database that I have just finished building up. We have a LAN system, but I have never done anything like this before. Do I just simply put it in a folder on the server and set in the Option menu in Advance that the default is Shared? Do I need to involve the main...

Hi, I have a problem on my Main form. The main form has 8 pages, but there are three pages where the subform navigation buttons are appearing for no reason, as fields on two of the pages are coming from the main table. I can go to the second record (there is no third for some reason) and...

Thank you for all these. Luckily, I need to keep all my 'customers' for future reference and I want to avoid that people who access the database, including volunteers, be able to delete any 'customers' and their data. So referencial integrity actually should be ticked in this case, shouldn't it...

I would like to add a table to an existing database. I have already put 300 records in the main table and I would like to add the new table connected to this main one with a one-to-one relationship. Is there anything that I have to be aware of if I tick the Enforce Referencial Integrity? Can I...

Hi, I have recently added a couple of new tables (e.g. Habitats from criteria) to the database. I have created one-to-one relationship between each table and the main table. However, I haven't ticked the 'Enforce referential integrity' option. When I wanted to add new sites this error came up...

Hi Rookie, Thank you for this. I have changed the join type in the queries. Is it important to also change it in the tables relationship? Or can I leave those as they are and just simply apply it when I build a query? Many thanks, Susanna

Hi, I have built up a database based on geographical sites. I would like to create a report of each sites with data from related tables. I have created a query, as the base of the report but unfortunately only one site of the recorded 400 turned up in my query. There are a few tables that...