Search results

We have an access Database stored on a server that until now was only ever accessed by the one user. Now more users need to access it at the same time. However when a second user trys to open the database the error message "File Already in use appears". I did not create this database so have...

Just practicing at the moment, but i have a query that stores durations in hours\minutes\seconds Anyway i want the query to add these times up and give me a total. For example 01:00:00 and 01:00:00 would total up to 02:00:00. Hoever when i use the sum function within the query, i get...

Hopefully this is a simple question, but does anyone know how many fields a table is limited to.

I have a reports form where the user can enter enter a from date and to date for the report criteria. I have an unbound field on the report which i want to display the month and maybe the year in which this date criteria is in. This will be needed to display on the actual form. Say if the...

In a previous database i used the dlookup function as the conrol source for an unbound text box. it looked like this: =DLookUp("[Name]","tbl_GP_Details","[GPNumber] =" & [Forms]![frmPatient_Dets]![GPNumber]) This populated the text box with the name from the gp details where the gp number was...

I am trying to open a database that has been run on a network and now keep getting this error message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time" And wont open the Database. Any way round this or...