Search results

what i am trying to ask is ... 1. Database is already on the network drive. I will split the database and put the backend file on the same location. 2. Then copying the mdb file to each users local machine keeping in mind that they are allready mapped with network drive. so my question is do i...

Thats what we do all the time. I request all the users to come out of database and then deleting the ldb file. After that they are able to enter successfully. BUt its happeneing like every second week now. So user want the permanent solution for this problem. Please suggest Thanks for all...

But i have multiple users for that. How do i map all those copies form their machine to the backend. or the database do it itslf once its splitted all i need to do is just copy the database to different locations. Thanks Danny

Hi There one another database have started showing a new error "the database has been placed in state by user 'Admin' on machine 'XXXXXX' that prevents it from being opened." I read some of the articles on google and find out tht database splitting is solution for this. Now my question is...

I have checked all the permissions for all the users . They all have same permissions . Only one user is having problem. i have checked the permissions on all the folders also. Thanks Danny

Both of them have same permissions. but some can enter all the time only one user is having problems. Thanks Danny

Hi there.. We have an access databas here. 2 users can can enter the db without any issue but one user is having error error 3050 - could not lock the file. Please Advice. Thanks Danny

Hi there Can i set permission on a single button in a access database form for specific number of users. And rest of the database is available for everybody ? Thanks Danny

Thanks alot!!!:) Best Danny

Hi there.. I have an access 2003 database. Properties are set as whenever open it a default form appears. I want this to be changed to some other form. Please Advice. Thanks Danny

Yes...it is in the shared folder. Thanks Danny

Hi there I have a MS Access 2003 DB. I need to make some changes in that but it shows me that Database is in Read Only and none of the changes can be saved. I have tried to changed the Read ONly attr. from right click and properties but that option is allready unchecked. Please help. Thanks...

Hi we are importing data in excel sheets from ms access using DoCmd.TransferSpreadSheet command its giving message "Can not expand the named range" plz help one more thing if i press "ok" below this message will it miss some values or not? thanks Danny

Hi Thanks for the response. Will it work as i said i wanna copy from one server to second server. like dont we have to specify server name somewhere. Best Danny

Hi I wanna schedule a windows job which copy a file from one server to another every week. Can somebody give me any idea about this. Best Danny

thanks it worked. Best Neeraj

i opened it but it shows the details: openForm runCode and in arg. action formName-xxx view-Form windows mode-normal how come i knw tht the specific query have been executed or not thanx for reply danny

Hi There i am really new to access world we have a access application in which one macro is defined on the main form which runs the whole application in turn. how can i know tht in which seq the macro is executing the queries. i have specifed the prob queries which are not getting executed in...

Hi There we have a ms access application which pools data from AS400. we have scheduled it for every week but there is a situation when its missing the data to feed the tables. but when we run the queries manually it gives the desired results. all kind of response are welcome Best danny

Hi There we have a ms access application which pools data from AS400. we have scheduled it for every week but there is a situation when its missing the data to feed the tables. but when we run the queries manually it gives the desired results. all kind of response are welcome Best danny