Replies

That was exactly what I needed.

Thanks!!!

Vernon

That was exactly what I needed.

Thanks!!!

Vernon

Thanks for the quick response. Actually, we are using a DNS connection and TCP/IP. Is there a way I can tell by looking at the network settings on the control panel which port is being used? Also, does would that mean at least theoretically that each workstation where the app is installed could have a different port configuration to access the network? Or am I totally missing the boat on your response. As you can tell, when it comes to networks, I’m woefully uninformed.

Thanks,

Vernon

If the application is reinstalled the user who was logged in at the time of the installation can access the program. Someone who then logs in under a different user ID will receive the file not found message. All users would be using Access 2000 (9.0.3821 SR-1). The “Encrypt contents to secure data” box was unchecked. Two more pieces of information that may help. If you start Access first and then try to open the .mde file, you receive a slightly different error message: “The Microsoft Jet database engine cannot open the file ‘C:program filesproduce pricing systemproduce pricing system.mde.’ It is already opened exclusively by another user or you need permission to view it’s data. Also, I noticed that under security properties that nothing is checked under CREATOR/OWNER (see attached .jpg).

Vernon

I checked the file type command string and it does contain “%1”. It is the .mde file that is not found (see attached screen shot). There is no workgroup security file associated with the application, just the front end (Produce Pricing System.mde) and back end database (Produce_BE.mdb). A few more pieces of the puzzle: 1) I had no difficulty opening the .mdb file. 2) I attempted to rename the .mde file and received a message stating that the file was in use. This would also happen if I attempted to copy or delete it through Windows Explorer. 3) I could delete the file using the delete function of my remote access software (Timbuktu Pro). 4) If I upload the the .mde file to the remote computer from my PC the user that is currently logged in can open the application without difficulty (however, if another user subsequently logs in they receive the file not found error. 5) It truly is a sporadic problem, of approximately 150 locations where the PCs have been upgraded to Windows 2000, this problem has only occurred at 4-5.

Thanks,

Vernon

The Like Nz(([Forms]![frmReportPrinting]![txtTaskOrderNumber]),”*”) worked like a charm.

Thanks!!!

Vernon

I found a solution, using a criteria of >=nz([Forms]![frmSubnetsReportFilter]![txtSubnetStart],”000.000.000.000″) for the txtSubnetStart and = the value in the text box?

Thanks,

Vernon

Sorry, that doesn’t seem to work either. Basically, what I’m trying to do is filter a report listing network equipment by any combination of network, subnet start address, subnet end address or location. This is done on a form (frmSubnetsReportFilter). For network and location, I use a combo box to generate an exact match and the results work. For subnet start address, I want the use to be able to type in, for example 246.017.000.000 and the results show all subnets with a starting address >= 246.017.000.000. The complete SQL of what I’m trying to accomplish is:

SELECT [Networks Table].NetworkName, [Range Table].RangeStart, [Range Table].RangeEnd, “/” & Str(31-[RangeMask]) AS BitMask, [Location Data Table].LocationName, [Networks Table].NetworkID, [Location Data Table].LocationReference
FROM ([Networks Table] INNER JOIN [Range Table] ON [Networks Table].NetworkID = [Range Table].NetworkID) INNER JOIN [Location Data Table] ON [Networks Table].SiteID = [Location Data Table].LocationReference
WHERE ((([Range Table].RangeStart) Like IIf(IsNull([Forms]![frmSubnetsReportFilter]![txtSubnetStart]),”*”,([Range Table].[RangeStart])>=[Forms]![frmSubnetsReportFilter]![txtSubnetStart])) AND (([Range Table].RangeEnd) Like IIf(IsNull([Forms]![frmSubnetsReportFilter]![txtSubnetEnd]),”*”,[Forms]![frmSubnetsReportFilter]![txtSubnetEnd])) AND (([Networks Table].NetworkID) Like IIf(IsNull([Forms]![frmSubnetsReportFilter]![cboNetwork]),”*”,[Forms]![frmSubnetsReportFilter]![cboNetwork])) AND (([Location Data Table].LocationReference) Like IIf(IsNull([Forms]![frmSubnetsReportFilter]![cboSite]),”*”,[Forms]![frmSubnetsReportFilter]![cboSite])))
ORDER BY [Networks Table].NetworkName, [Range Table].RangeStart;

Thanks,

Actually, it turns out that I hadn’t set the OrderByOn property. It’s curious that it worked previously as an Access 97/Windows 95 & Access 2000/Windows 95 application.

Thanks for the help,

Vernon