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.

Right, now for the next problem It works fine on my machine, but when i use it on another machine the text box comes back saying Name# instead of the month. Any idea why?

Thanks for that, it does the trick :)

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

We are talking about general users who have discovered the basics of Access and started designing there own Db's. So in a word no Backup, but i guess its there own fault

Exactly, as i said i dont think there is a solution and i have no idea what they did to get it into this state

Have no idea what data is in it or how it has been set up. I did not create it. It has been created by an access novice and ive been landed with the problem but here goes. Pasword is central

Just the one table as im aware. As with the data i dont know but its size is 402k

I thank you all for your help but none of these are working. I think its time to conceed that whatever has been done to this db, has well and truly screwed it up and nothing much can be done without paying for some kind of Database recovery.

Tried everything and that message keeps popping up

Again, tried that. I have no idea what they have done with it but its a complete mess.

Appreciate the help but i still get the same message. Dont know if it makes a difference but the db has got a general password on it. It accepts the password and then shows the message.

Sorry if this is getting annoying but have tried all that and i cant get past the error message.

There is no one in it and ive taken a copy onto my local drive, but still the same problem. It wont let me open the database. Its a shame we have no Database recovery software.

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