-
WSMelanieB
AskWoody LoungerBut we DO have rights to delete and write to the folder on the network where the db is located. In fact, while logged in on Citrix, I can go to the database and copy it, move it, or delete it just fine. So if compact and repair creates a new database and renames it and deletes the old one, and it is working in the same folder as the original db, and I can manually do those same things, why can’t Access complete the process?
Hans, I would understand if it copies something to the local drive because we don’t have rights there. But I do have full rights on the network drive and the folder where the db lives.
Hans is correct – unless you can get Delete privileges on the network drive where your database is located, doing a Compact and Repair will always create the new database, but is unable to rename it since that involves deleting the original database.
-
WSMelanieB
AskWoody LoungerWe don’t have rights to copy to the local disk when using Citrix. We can copy to another network drive. I’ve done that without any issues. I’ve even tried doing the compact/repair from a copy on another network drive. It seems to be just when I’m logged into a thin client on Citrix that the problem happens – no matter which network drive I am using and no matter which database.
And, I can open the db on my other computer (not on citrix) and compact/repair there fine.
-
WSMelanieB
AskWoody LoungerMarch 5, 2009 at 9:32 am in reply to: Mail Merge to make picture badges for employees (2003) #1150337Thank you, Hans. I am still struggling. Now I am getting the outline where the picture should be, but there’s a red x in the upper left corner. Any ideas about why?
-
WSMelanieB
AskWoody LoungerMarch 3, 2009 at 3:37 pm in reply to: Mail Merge to make picture badges for employees (2003) #1149963No error. It looks like it’s posting, but then I check and it’s not there. I’m going to try it again now.
No, what exactly is the problem? Do you get an error message? If so, what does it say?
-
WSMelanieB
AskWoody LoungerMarch 2, 2009 at 5:11 pm in reply to: Mail Merge to make picture badges for employees (2003) #1149801Hans,
I’ve tried posting the reply with the attached file twice so far today. But, it’s not showing up. Did we hit a thread limit or something?
-
WSMelanieB
AskWoody LoungerMarch 2, 2009 at 9:09 am in reply to: Mail Merge to make picture badges for employees (2003) #1149724oops. Sorry. You’re right. Here is the correct one. Thank you.
Macropod asked for the mailmerge main document, i.e. the document with the merge fields.
You have attached the result of the mail merge instead. -
WSMelanieB
AskWoody LoungerFebruary 27, 2009 at 4:48 pm in reply to: Mail Merge to make picture badges for employees (2003) #1149475Sure.
Hi Melanie,
Can you post a copy of the current version of your mailmerge main document, minus any confidential material?
-
WSMelanieB
AskWoody LoungerFebruary 27, 2009 at 3:11 pm in reply to: Mail Merge to make picture badges for employees (2003) #1149465Yes, I followed your instructions, which worked to get the pictures to display. But, not the right pictures. The datasource is a Excel spreadsheet, and each record has its own picture (see attached data source above please). How would I tell the INCLUDEPICTURE field to point to the pictures other than the way I have done it? (I have attached the merge document too above).
Thank you for trying to help me.
Hi Melanie,
Did you follow the steps I suggested for updating the pics after running the mailmerge? If so, and the pictures don’t update correctly, that suggests the INCLUDEPICTURE fields are pointing to the same set of pictures, not to a separate picture for each record. In which case, are you sure the records point to the correct pictures?
-
WSMelanieB
AskWoody LoungerFebruary 26, 2009 at 5:44 pm in reply to: Mail Merge to make picture badges for employees (2003) #1149190Well that sorta worked. I do get pictures, but it’s the same 3 pictures for all the records – they rotate the same 3 pics over and over again for all the records. I can look at the individual pictures and see that each record is numbered to match the data source records.
-
WSMelanieB
AskWoody LoungerFebruary 25, 2009 at 5:50 pm in reply to: Mail Merge to make picture badges for employees (2003) #1148898Well, both the datasource and document are stored in the same folder. The pictures are stored 2 subfolders below the source data and document. Are you saying I need the datasource and document stored in the same folder as all the images?
I don’t do merges, but I took a look at your document. I noticed the file names are generally “relative” to the current folder. However, in the case of a new merge document, that folder may be undefined. You probably need to save the file in the correct location before they can be resolved. Does that help?
-
WSMelanieB
AskWoody LoungerFebruary 25, 2009 at 5:18 pm in reply to: Mail Merge to make picture badges for employees (2003) #1148891omg.. I cannot believe how dense I feel. I fixed the mistakes you pointed out. Now, it has automatically changed my field and it shows the path and file name, and when I preview the merge it still says, Error not a valid file name.
Thank you for your patience. I am sure this is not hard, but somehow I am making this hard.
There are three mistakes:
– The name of the field is INCLUDEPICTURE, not INCLUDE PICTURE
– There shouldn’t be a space before the merge field
– There should be a double quote after the merge field (this error doesn’t occur in your document, only in the post)So instead of
{INCLUDE PICTURE ” {MERGEFIELD PHOTOGRAPH_FILENAME}’}
it should be
{INCLUDEPICTURE “{MERGEFIELD “PHOTOGRAPH_FILENAME”}”}
I tested it with a picture on my disk.
-
WSMelanieB
AskWoody LoungerFebruary 24, 2009 at 4:23 pm in reply to: Mail Merge to make picture badges for employees (2003) #1148691The data source looks like this:
N:\Test\Jeff Reams\Badging\Photos\00000\574.jpgMy merge code looks like this:
{INCLUDE PICTURE ” {MERGEFIELD PHOTOGRAPH_FILENAME}’}
But when I run the merge, I get “Error! Not a valid filename.”
I’m attaching (hopefully) a sample of the datasource and labels so hopefully you can see what I’m doing wrong.
Thank you.
What does thePHOTOGRAPH_FILENAME field in the data source contain?
– If it only contains the filename without the path, you should specify the path in the INCLUDEPICTURE field. Since you use an absolute path you should *not* use forward slashes but double backslashes:
{ INCLUDEPICTURE “N:TESTJEFF REAMSBADGINGPHOTOS00000{ MERGEFIELD “PHOTOGRAPH_FILENAME” }” }
Note that there is no space between and the { of the merge field!
– If it contains the full path to the picture, you should *not* specify the path in the INCLUDEPICURE field, but you should use double backslashes in path in the data source.
-
WSMelanieB
AskWoody LoungerFebruary 19, 2009 at 8:42 pm in reply to: Mail Merge to make picture badges for employees (2003) #1148060Thank you, but I’m still a bit confused. Do I write out the path for the picture and put the MERGEFIELD PHOTOGRAPH_FILENAME also? I did a screen shot of it both ways and I’m not sure which is right. I went into the datasource and made sure the slashes were forward /.
-
WSMelanieB
AskWoody LoungerFebruary 19, 2009 at 5:16 pm in reply to: Mail Merge to make picture badges for employees (2003) #1148012Well, I did, but I also clicked the button to update all fields and apparently when I saved the file, it lost the fields I hand entered. So, here it is again.
-
WSMelanieB
AskWoody LoungerThat works beautifully!!! Your instructions were perfect, Hans. Thank youuuuuu!
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Microsoft : Resolving Blue Screen errors in Windows
by
Alex5723
20 minutes ago -
Where’s the cache today?
by
Up2you2
15 hours, 40 minutes ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
8 hours, 26 minutes ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
10 hours, 11 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
16 hours, 21 minutes ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
1 day, 8 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
1 day, 9 hours ago -
regarding april update and may update
by
heybengbeng
1 day, 10 hours ago -
MS Passkey
by
pmruzicka
12 hours, 26 minutes ago -
Can’t make Opera my default browser
by
bmeacham
1 day, 18 hours ago -
*Some settings are managed by your organization
by
rlowe44
1 day, 4 hours ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
1 day, 17 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
2 days, 12 hours ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
2 days, 21 hours ago -
AI slop
by
Susan Bradley
15 hours, 42 minutes ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
2 days, 23 hours ago -
Two blank icons
by
CR2
7 hours, 14 minutes ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
9 hours, 12 minutes ago -
End of 10
by
Alex5723
3 days, 10 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
2 days, 8 hours ago -
test post
by
gtd12345
3 days, 16 hours ago -
Privacy and the Real ID
by
Susan Bradley
3 days, 6 hours ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
1 day, 9 hours ago -
Cant log on to oldergeeks.Com
by
WSJonharnew
3 days, 21 hours ago -
Upgrading from Win 10
by
WSjcgc50
2 days, 8 hours ago -
USB webcam / microphone missing after KB5050009 update
by
WSlloydkuhnle
2 days, 12 hours ago -
TeleMessage, a modified Signal clone used by US government has been hacked
by
Alex5723
4 days, 12 hours ago -
The story of Windows Longhorn
by
Cybertooth
4 days ago -
Red x next to folder on OneDrive iPadOS
by
dmt_3904
4 days, 14 hours ago -
Are manuals extinct?
by
Susan Bradley
1 day, 14 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.