Search results for query: *

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

Just to let you know, I have just encountered the same error with a db that has been working just fine for quite awhile. The only thing that has changed is that I installed Office SP3 the other day to solve another problem. Now I can't link to the backend db file using the Linked Table...

Thanks for the reply. The reason I posted this as a security issue is that, after things were working for months as described, I received a "You don't have the necessary permissions....." message when trying to Link to the backend data files using the Link Table Manager from the dev machine...

I have a split database, which was working fine on the first two machines it was implemented on. Development is ongoing on one with a test database, which is just a copy of the live database (I guess you'd call it the back end database) on machine two. Occasionally, data operations were...

Edski Yes, they are identical databases. The Regional date formats are the same. But, no, it's not just with dates --there are other instances that do not involve dates. Thanks for your help. KenReay I'll check those settings when I get back to the two affected macines but on the machine...

I have 2 computers running Access 2000; both Win XP. The Access programs on the development computer work fine. On the other computer, there are at least several places where the #Name? errors come up. I'll explain the simplest reference. There is a control on a form, which is supposed to...