Search results

Hi guys, i am currently running a live database at the moment, but there is something weird happening. Every few hours or so, it locks people out of the shared database saying that the file is not a database file and/or its corruopted. The database is a FE/BE situation shared amongst 12...

Hi all, I am trying to share a database with other people on the network. This is successful so far. However there has been a couple of odd outcomes and i was wondering if i could get any reasoning behind why what has happened, happened. First, when all people sign out and stop using it, and i...

Ok, i must have a broken version of Access or im just crap, but ive been having a problem with the data in forms. basically when im adding names of people with either the same first name or last name, the database just links this to another person so for example id :1 John Smith id :2 John...

Hi, Im trying to share a database with 12-16 other people and would like to know how can I set up this sharing database and what problems/issues i have to deal with. What happens when 2 people try to save or create something new at the same time? I did a test run and it kept saying "Another...

Hi all, Im a little confused with the Query to form business. I am trying to let users search through my main database (in a form) but when i start up a query the results are produced in a table format or in a new form completely. (through the wizard) I cannot get it to link to the original...

Has anyone ever made a One -> Many relationship but cant get it to function properly. Well i have...maybe im just a master at messing things up. I have set up the relationships as normal, assigned a promary key in table A (say called ID1) and then set up field in Table 2 called ID2 and then...

Hi there, just to start off by saying this is a great site!! (no brownie points wanted!) Im a bit of a novice really but your help would be greatly appreciated. I am trying to create a REPORT from 2 tables, there is a one to many set up here. So picture the Artist -> Songs scenario. (One...