Replies

The T1 prefix was not needed, but adding it causes no problem either.
That error message seems to suggest that you have more than one referral for the same client done at the same date. What criteria should be used to untie such cases?

Thanks for translating the error, I was scratching my head. The case you mentioned only would happen if the referral was coded twice, by accident. I don’t have any way of determining which one is correct in such cases.
Is there a way for Access to just pick the first one it finds, in the case of such duplicates?

P.S. Did you see any of the tourists in town for World Youth Day? I know some people that traveled to Spain and Portugal for the event in Madrid.

Here you have a small database with a test table and the query as described above, working.

First I fixed the field name to T1.[Date XXX Recd Referral], and then it ran with this error: (note that my org name is X’ed out)

“At most one record can be returned by this subquery”.

28825-MaxofReferralQuery

Here is an example of what the final window looks like (not the embedded MaxofReferral query):
28828-MainList2

Note that the problem is that the “Ref. Status” (Referral Status) is not picking the most recent referral for all the people the list, which is why I am trying to sort the underlying query of this list with a query not based on the ReferralID by the “Date XXX Recd Referral”.

Thanks.

You can use Max for Date fields, and that is what I was going to suggest.

When you add that field to the Group By query need to remove the ReferralID , so that you only Group By the Client.

If you notice in the second image, the queries TBL_Referral and MaxofReferral are linked through the “ReferralID” field, so how can I remove it?

I love the “screenshot into a Word document” tip. That is going to save me a lot of time on my documentation at work!

Dear Becky,

Can you please explain the difference between the RADIUS authenticated wireless network and the segregated guest wireless network? This is from the section entitled “WPA-Enterprise setup with headaches”.

Wouldn’t making a guest wireless network be the exact security hole you were trying to prevent by making a RADIUS enabled wireless network? (Let’s assume the employees would be good and use their RADIUS accounts, and ONLY guests would use the guest wireless network.) Can you provide examples of resources that RADIUS users would have access to, that users on the guest network would not?

Thank you,
Peter

Ok, I’ll give it a try – I use Outlook rules all the time.

I prefer mail enabled public folders for external mail. Simple to manage via permissions and prevents spam clogging everyone’s email.

cheers, Paul

Teaching some users how to use public folders, or simply getting them to check there email everyday can be a tall order at some organizations. I have worked at some where users still haven’t adopted reading their work email daily and prefer to use email as little as possible. In my case, I don’t think adopting public folders is the option for me.

We allow external users to email some distribution lists but not all. The ones that we allow are generic enough (i.e. sales, support, etc.) that trying to figure out how to limit them is more trouble than it is worth.

How do you allow some distribution lists to be open to external users, but not all?

You could try creating a Hub Transport Rule where you have more flexibility.

Since I don’t know how to do this, and I didn’t get any feedback on this option, I won’t be able to do this.

So I have two choices. Just send the outside user a flat file with all the emails comma separated, or open up my Exchange distribution to outside users, and risk spam (per my original post). My main question is whether or not that is a bad practice.

Thanks,
Peter

They are very similar to Outlook rules in the way they are constructed. There is a wizard that walks you through the process.

For more information on creating transport rules, open the EMC, click Microsoft Exchange On-Premises -> Organization Configuration -> Hub Transport. Then click on the “Transport Rules” tab and then Help.

Joe

I found this on Technet:

An accepted domain is any SMTP namespace where this Exchange organization sends and receives e-mail on behalf of recipients. Authoritative domains are accepted domains where the recipients’ mailboxes are in this Exchange organization. Relay domains are accepted domains where the recipients’ mailboxes aren’t in this Exchange organization and the mail has to be relayed to an external e-mail server or Exchange organization for delivery to the recipient.

and this on technet:

[*]Authoritative Domain To specify that e-mail messages are delivered to a recipient that has a domain account in your Exchange organization, select this option.
[*]Internal Relay Domain To specify that e-mail messages are either delivered to recipients in your organization or relayed to a server outside your Exchange organization but still under the authority of your company or IT department, select this option.
[*]External Relay Domain To relay e-mail messages to an e-mail server outside the Exchange organization, select this option.

But I don’t see anything about accepting messages from other domains, mostly about sending messages to other domains.

Any help is appreciated.
-Peter

You could try creating a Hub Transport Rule where you have more flexibility.
Joe

Can you point me to any online tutorials on hub transport rules? I have not worked with them.

Thank you,
Peter

Yes. The assumtion is that the employer has clearly written and legally binding policy that allows employees to supply thier own phones with the understanding that the company owns its data and has the option to protect itself by remotely wiping the phone. Many companies already make users sign agreements when it comes to data usage, exclusivity, etc. I’ve worked for several companies that dealt with this very issue regarding other personal devices (laptops) and when terminations occurred the ex-employee was legally obligated to destroy the data. I know of at least 2 cases where charges were later filed against those ex-employees who used the data for their own purposes (sales data in their new sales job). As jscher2000 says, best to consult an attorney when making the policies.

Thank you Doc. That is just the information I needed to proceed.
Cheers,
Peter

First, I’m assuming a person has access to the email client software on the device (i.e., they know or break pin/swipe security).

Such a person could read the messages on the small screen, and they might be able to forward the messages out on a second account. I have an Exchange ActiveSync account and an IMAP account set up on an Android device. If I open a message in my Exchange inbox and tap forward, I then can tap the “From” button and set it to send the forward out on the IMAP account. This is pretty arduous for a large volume of messages, so a professional likely would have better techniques.

Ok, that is helpful, thanks.
One more clarifying question though: In my scenario, I had changed the Exchange email password for the user. Does that mean on some smartphones like your Andriod, changing the password just stops new email from flowing into the device, but doesn’t prevent you from reading already sync’ed email?

-Peter

Unless you wipe the data on the device, everything that was on there prior to the password change would still be on there.

Even if you wipe, there have been reports that it is difficult to truly erase flash memory the way you can usually overwrite magnetic media. However, someone might have to have considerable expertise to salvage the data.

How hard would it be to retrieve those emails off the mobile device if the corporate password to access them was changed, but the device was not wiped?

If you take the decision to wipe data from a device that doesn’t belong to you and, deliberately or otherwise, delete data that doesn’t belong to you but to the owner of the device, how do you then stand with your Data Protection laws?

I’ve not yet tried to recovery data from a flash memory device but setting the smart phone to save data to the SD card or whatever is trivial – it’s also quite trivial to recover the data from these cards.

Satrow –
Are you saying that I am, or am I not allowed to wipe the personal phone of an employee, I didn’t follow your response, thanks.

About saving data to SD cards in mobile phone – the remote wipe also erases all data on those. If a user didn’t want to lose data on their SD card, they could take it out before the wipe. I read that on the Exchange 2010 remote wipe documentation on Microsoft Technet.

-Peter

Peter I used to love Pinnacle, but back in 2000, or so I found it to be clunky and an absolute resource hog. So bad in fact I ended up removing it. Of course that was on an XP machine with only 1G or ram. Has it gotten better or is it still bloated and slow in its renderings?

Hi t8ntlikly,

Since purchasing Pinnacle this spring, I have been able to render a 10 minute video clip for viewing on YouTube in about 15-20 minutes.
With the adoption of 64-bit computing, and more RAM in PC’s, the rendering times have become bearable.
I can’t compare render times to earlier versions of the software, since this is the first time I have owned a Pinnacle product.

-Peter
(Peter the thread creater, not Peter Johnson2191)

Hi Wendall,

It looks like you were right, the re-linking of the one missing link in References did fix it. The steps I posted in the first attachments do show how to fix the link error.

What had happened was that my user was confused and told me “it wasn’t working” after I gave them the new re-linked (and recompiled) .mde. But they were reporting a different problem. A toolbar was dissapearing for them. And it order to make it come back I just had to tell them to change the view from “Form view” to “Datasheet View” and back. They said it has been fine since then.

Thanks for your pointers along the way. I am now going to try to figure out how to relink the copy of my front end .mdb file with the copy of my backend database file. Having a test copy of the db will come in handy so I can start testing modifications to the forms and developing new forms and such.

Peter

Then I should assume that there are no missing references when you look at Tools/References in the VBA editor? If so, how did it show up again the next day? Once an issue like that shows up and you fix it, it should stay fixed. Did you recompile the VBA after that? Normally it isn’t necessary, but I have seen cases where it does not stick unless you do a recompile and then save the VBA project before closing the VBA editor.

I think you do need to look at Allison’s book to understand how the database container window works – that’s what you first see when you create a new database in Access 2003. Skim through the first few chapters where she deals with how to get started creating a database. You obviously have selected the Queries category on the right side, so it gives you a wizard to create a new query. But you don’t want to create a new one, you want to make a copy{/b] (using Windows explorer) of the front-end and the back-end mdb and relink the linked tables to the copy of the back-end as you suggested. Then you want to start deleting things – the delete key will delete the object that is currently selected. You may have to do that process several times before you are comfortable, but using a copy of the file (both front-end and back-end) is much less work than trying to import only the right objects.

I should also add that there are have been a few bizzare problems reported with forms that link to graphic images using code when running Access on 64-bit Win7 systems. Does this application display graphic images on the forms or reports?

Hi Wendall,
Thanks for your help so far.
To answer your questions of missing references, please review my first post, as it explains how I re-linked a missing reference:

I was able to identify part of the problem based on the “Datediff” function error that is shown in attached word doc with screenshots. A library file for the MS Access was not linked correctly. I had to browse into the database and to the References, and point the references to the correct place. Please see the attachment entitled “Fixing a missing library file” for details.
However, after I did this fix, the problem came back again the next day.
…
Please see the attached MS Word files for clarity. One file displays the error. The second file shows the fix I implemented. I added a lot of screen shots for clarity.

Can you help me with the below question?

However, I can’t find were to access and view the original design screen for new database. The screen with the Objects (Tables, Queries, Forms, Reports, Pages, Macros, Modules) listed on the left, and a white box on the right with “Create Query in Design View”.Once at the screen I will go to the table view, and delete all the links to the backend .mdb.
Then I will right click Tables and select import, and then import the data in directly to the front-end .mdb.

Thanks for your advice, I’m glad I have a good reference book.
-Peter

Did you try the step of checking references in the Visual Basic for Applications? If you have one that says “Missing” then that is probably the source of your problems. If not then you are going to need to either enlist the assistance of an experienced Access developer, or try to shrink it to the point where it can be uploaded. I doubt reading Allison’s book – one of the best in my view – will help you get this done in a timely manner. Access is something that takes most mortals several months to get up to speed – at least where you are dealing with complex applications.

If you do try to shrink it, I would first make a copy of the front-end DB, and make sure you are using the copy. Then look to see if you have any local tables and determine if they are necessary to demo the application. If not, and they are simply temporary tables, they can be deleted. The next step would be to delete any forms and reports not necessary to demo the problem. At that point do a compact and repair on the front-end. Next, take the back-end with the tables, make a copy of it and make sure you are using the copy, and remove all but a few sample records. Unfortunately that may be difficult, as there are probably relationships which prevent you from deleting records in one table until all the records in another table that link to that record have been deleted – for example a person record cannot be deleted until all the address, phone number, and contribution records have been deleted. Hopefully that should eventulaly get you under the 2MB size for the backend. I should add that neither task is a trivial one – it will take several hours on each in all probability.