Search results

Thank you but having multiple tabs vs several forms made sense when I was building the db. If i knew about this possible issue at the beginning i would have done it differently.

Update: I sent a brand new FE file to 5 users and it worked fine for everyone but I wasnt able to re-send the file and test with the other 2 users who were having issues earlier - they had already left for the day. I will try again with them but i think the problem was that I probably...

I think I may have right clicked on the locked file and opened it as a text file to see who is logged in and 'i think' it was after I did that when users started to get this error message. I will try again with a fresh file. The folder permission is set to 'Full Control' for all users and they...

I checked both FE and BE and they are both set to open 'Shared' I just sent a new FE file to another coworker, I didnt map it and the BE was located in the same folder as before. It worked fine - but that was 1 user though. I will try sending a brand new file to multiple users again - already...

My FE path looks like this. I am very confused.

Yes, I mapped the links but it didnt work so I thought I had to refresh the links (map it out again) for it to work. Yes, the user can see the be file but when they click on the file and open they get a message similar to this...

I tried the split db over the network with 3 users and it was not too bad. But when I tried to have the 4th user open the FE db - everything was fine but when I asked her to map the tables queries, forms through link manger, she got access denied message to the BE file. I cant figure out why. 3...

In the next couple of hours I will gather a few colleagues and test this split db over the network for performance. I will follow the following steps: 1. Keep a copy of the ACCDB file and split the db 2. Put the BE db file (ACCDE) version on the network drive 3. Distribute FE db file to the...

Ok I think I dont HAVE to install runtime because all my end users have MS ACCESS installed on their machine. based on what I found on MS site below, you need runtime if the end users dont have MS ACCESS application installed. "Microsoft Access 2013 provides a rich platform for developing...

Ok I get what you are saying but can you please clarify? Is Runtime different than ACCDE file? Do I need to go with either runtime or accde or runtime is an additonal step? The MS link below suggesst that I have to download runtime for access 2013. i work for a big corporation and downloading...

oh that may be a problem if any of my users try to use it via VPN. I had no idea of this limitation.

Update: I split the DB and used it through VPN and it was really slow, I mean it took up to 15 sec to open a form. But perhaps, its VPN so I am not worried about it too much. There is a couple of good articles below: http://www.granite.ab.ca/access/performancefaq.htm...

OK I read directions here to split the db and tested with another user and things seem to be a bit slower- which is what was expected but its not that bad. Hopefully it is not going to get slower and slower as more and more users are using it. I mean there should be a limit on how much slower it...

Thx another question. If I split the database, does that reduce the efficiency - slow response time? Perhaps because the data will need to move on the network? thx

Yeah sorry, I meant to say that put it on a USB drive to deliver the FE db to their PCs. I wasn't aware of any auto update method. I thought if there is any changes, I would have to deliver the new version of the db via USB or put it on the network drive somewhere so they can download it to...

Hi, I am in the final stages of going live with the db that i have been working on and I need some advise on what is the best way to share the db in a multi user environment. There will be no more than 10 users using the db at any give point in time. Option 1: Use vb code to prevent table etc...

Hi - this is a report based on a query. Not sure what sub report means. What do you mean by 'and on its datasource limit only with data'? Are you referring to a property of a report that I may have to change? 10 lines/fields are not hard coded on the report. They are part of a record and i...

Its a big db file - not sure ow I can upload it but any help/tip is greatly appreciated. thx

Thanks but I dont think I explained my issue properly. I am building a db where there is 10 fields (lines) associated with one record (a project). Some of the records (projects) may have 3 fields entered by the user, some 5 and some up to 10. For the projects that will have say 5 fields, the...

Hi, I am working on a report where I have 10 lines. I dont want the blank lines to show up on my report which I was able to accomplish by setting the Can Shrink property for the lines/fields to 'Yes' but the problem I am having is that the blank lines dont show up on the report but the blank...