DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Apr 7 12:14:57 CDT 2004
Not too mention Remote Administrators 'routing' capability. (ie, I have it on my server at home, but then I can hit any machine on my home network by 'routing' through my server). Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Brett Barabash Sent: Tuesday, April 06, 2004 8:33 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] A2K: Help with Error accessing file We tried GoToMyPC here. Had a number of problems, especially when working in a "2-way" teleconference where both parties were driving the machine. The machine would hang while waiting for the other party to move their mouse, click a key, etc. I followed Drew's suggestion a while back, and picked up a copy of Remote Administrator (www.radmin.com). $35 covers the license for 2 machines. No monthly charges. No headaches. Works for us! -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Monday, April 05, 2004 5:35 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] A2K: Help with Error accessing file --------------Please open with care!------------ This message has bypassed some of our spam filtering rules. This message was scanned for viruses and executable code has been stripped. --------------------------------------------------------------- Steve, I don't have an answer to your specific problem, but since your client is distant this might help: Have your client download a trial version of GoToMyPC. He can set up an account for himself. GoToMyPC has a feature called 'Guest Invite'. He can use this to let you see what's happening on his screen, and you can control his PC from yours so you can do some troubleshooting. I guess this is similar to WebEx or PCAnywhere. If he decides to keep the GoToMyPC account, he only needs to pay $15/mo. I use it to work with my clients so they can see 'drafts' of what I'm doing without making a trip. Best of Luck! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steven W. Erbach Sent: Monday, April 05, 2004 10:33 AM To: Access Developers discussion and problem solving Subject: [AccessD] A2K: Help with Error accessing file Dear Group, I have an Access 2000 FE/BE application loaded on a client's system in another city 90 miles away. I've been working with their network guy over the phone and he's sent me screen shots of error messages along the way. Here's the situation. The "master" MDB FE database is loaded on the server. I have the local people there create an MDE and place it in another folder so that's it's available for the users who download it to their workstations when a new version is ready. While working with my client's network guy, Bob, the MDE file SEEMS to be created all right; but once the compacting is finished and the FE starts up, the first form opens and he gets this message (it's an "i" message): The expression On Load you entered as the event property setting produced the following error: Error accessing file. Network connection may have been lost. * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an error evaluating the function, event, or macro. When he clicks OK the startup form (which is supposed to be hidden) is there on the screen and the application has halted. INVESTIGATION: 1) They don't have the Documentor installed so I can't see what the path is to the BE. 2) However, I do have a form (that I cobbed from Steve Nyberg) that shows all the links with their paths. When we attempt to open this form we get the message you see above. Click OK on the message and Nyberg's SeeLinks form opens but with nothing showing up regarding linked tables. 3) I can open the linked tables from the "master" front end. But when I open the table that contains the latest version number (part of the version upgrade system) I see something odd. This Versions table has one row. The table has a Default value of the Now() function in the VersionDate column. On my system when I look at the table I see the first row all right and in the 2nd (empty) row I see (AutoNumber) in the key field and today's date and time in the VersionDate column. On my client's system he sees #Name? in the VersionDate column in an empty row. He cannot add information in a new row because Access doesn't like the default value. So I had Bob remove the default value. I still get the main problem. 4) The users can still run the application from their workstations using the old version of the FE. There hasn't been any problem there. 5) The Startup form of the FE calls Carl Tribble's Auto-Linker to check the link status of the first table before the main switchboard menu appears. This is all working properly on the users' workstations. 6) I tried Compact and Repair on both the BE and the FE. No change in basic error. 7) I checked the references. They're all there. 8) Only thing I haven't done (at least that I know how to do) is a /decompile on the "master" FE on the server. I'm sorry about the length of this message. I somehow doubt that I would find the problem even if I were sitting at the workstation. Bob is very capable, so I'm sure he's relaying to me everything that he sees. At least my clients can still work with the older version of the app. I am just stumped why this error message appears in the "master" front end database. Any thoughts, other than "Well, why the heck do you let the user make an MDE in the first place, ya numbskull?!" Regards, Steve Erbach Scientific Marketing Neenah, WI 920-969-0504 "Congress is as trustworthy with money as a crack addict who is experimenting with heroin." - Dave Barry "Giving money and power to the government is like giving whiskey and car keys to teenage boys." - P. J. O'Rourke "Be thankful we're not getting all the government we're paying for." - Will Rogers "It could probably be shown by facts and figures that there is no distinctly American criminal class except Congress." - Mark Twain ---------------------------------------------------------------------------- ---------------------------------------- The information in this email may contain confidential information that is legally privileged. The information is only for the use of the intended recipient(s) named above. If you are not the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or the taking of any action in regard to the content of this email is strictly prohibited. If transmission is incorrect, unclear, or incomplete, please notify the sender immediately. The authorized recipient(s) of this information is/are prohibited from disclosing this information to any other party and is/are required to destroy the information after its stated need has been fulfilled. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Tappe Construction Co. This footer also confirms that this email message has been scanned for the presence of computer viruses.Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com