Search results

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...

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...

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...

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...

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, 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...

Hi, I would like to derive the name of my data from a code on the form by just typing in the code in one field and let the text come up on another field. I have created a list of the code with their description in the Tables, but I don't know how can I bring up both information at once when I...

Hi, It might be fairly obvious, but I can't get my head around this. I have just created a Contact History for our contacts (phone call, letter etc.) with members. We had contacts with them in the past and I would like to record those, but in the meantime we have contacts with them day by day...

Hi, I have a bit of knowledge on Access, although I still use the 2003 version of the software. I have just built up a database and I have a question about validation rules on Forms. I have four dates on my form: Proposed Date Scheduled Date Approval Date Rejection Date. I would like to...