Recent content by autosol

Sorry for the delay in responding AceMan1, but I just got back into the office. Your suggestion for eliminating the flicker seems to have worked perfectly. Thanks very much. I'm still trying to lock out others from the entire main order record if another user is working on it OR any of its...

I have a main form (called frmDR) for data records called delivery receipts with a subform (called sbffrmDRItems) containing the items associated with each delivery receipt # (similar to orders/order line items). I am using pessimistic (edited record) locking. I am trying to indicate to all...

IanAble Thanks for your reply. I won't be back in the office until next week but this looks promising. Autosol

The other day a FE/BE app that has been running without incident for 9 months on a small Win XP Pro peer-to-peer network began to a) not allow me, from my development/FE computer to link to the BE and b) not allow me to copy the BE mdb file from the computer where it resides to my computer...

I use Access 2K and Win XP Pro Svc Pack 1. For starters, I want to click a button from a form and have a report faxed. I have fashioned my VBA code after the MS RptSample mdb example that has been pointed out in other posts I have found on T-T. My code in the OnClick looks like: Let FaxNo...

To easyit Regarding "Open Exclusive", I have been the only user trying to use the be mdb on the production computer when trying to link to it from my development computer. In other words, the other user, who is in the Admins group, who works on the data, has never been using it when I've tried...

To MichaelRed Regarding the use of duplicate .MDW files, is your concern that they will not be administered properly over time (ie, kept exactly the same) or something else?

To MoLaker The live production be is located on one of the computers on our peer-to-peer workgroup. A copy of the fe is also located on that computer, while development continues on a second computer (I'll call it the development computer) utilizing its own copies of the fe and be mdb files...

Sorry for the long delay in responding to this topic but an emergency arose, which diverted me from this Access problem and I only spend 1-2 days in the office with the Access problem presented in this thread. I don't know if this thread can be resurrected but I will work on the suggestions...

To MichaelRed I believe the permissions were given to the Admins group and then the users were assigned to that group. I am in the Admins group and am the owner. When I look at my user permissions, they all appear as checked off. The other user was also assigned to the Admins group but for...

To MoLaker I can see where my description re frontend and backend was confusing. I have a split db. The frontend does contain the forms, reports, etc and, the backend, the live production data tables. The fe is linked to the be tables. The user opens the fe via a shortcut that points to the...

To MoLaker I have checked for undeleted ldb files in the directory in which the mdb's reside and there aren't any. As far as the Delete permissions you mention, I'm not aware of specific delete permissions in Win XP -- all I'm aware of for security and sharing is the "Allow network users to...

Thanks for the response. hickeyc. Interesting info but doesn't apply in this case.

Thanks for responding. I won't be back in the office until Wed afternoon, at which time I'll check this out.

Is it possible to undo the security on my Access 2000 database in order to start over? My problem is this. I have a frontend and a backend in use on only two computers for now, both using Win XP Pro. The fe is being used for development and testing. For months, it was possible to use the...