Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Vista Forums > Microsoft Office

Vista - MS Access 2003 & VISTA

Reply
 
Old 11-10-2008   #1 (permalink)


XP
 
 

MS Access 2003 & VISTA

I have a MS Access database which I've developed using MS Access 2003 on an XP Machine. It has a Front-End which I give to each user and a single Back End database (Jet Database, not SQL Server). I have some users on XP with Access 2003 and others on VISTA with Access 2007. I have one user on VISTA with Access 2003.

This problem occurs ONLY on the one user system running on VISTA and Access 2003. And it ONLY occurs in my production database.

I have a zip code field in my database which is 9 characters long. For reports, I check if the 6th character is numeric using an IIF stmt. If numeric, then I print the left 5 characters, a dash, then the 6-10th characters. Otherwise, I just print the zip with no additional editing or formatting.

Everywhere I print the zip code, or city/state/zip, or street address/city/state/zip, my user gets an error (only this one user - everyone else can view the information on the report just fine).

I was including the concatention of the city, state, and Zip - along with the IsNumeric check on the 6th zip character all in one field. The error she received then was #Name? . I changed the examination of the zip code to be a separate field (txtZip) and now just concatenate the city, state, and pick up the txtZip. The error she now receives is #Error. Again, she is the only person out of 15 who get this error.

I did some testing to try to narrow down the problem. Bottom line - I imported the one production report with the problem into a small, temporary database using a link to the production table, and she can view the report just fine. But in my production database, she can not view the city/state/zip (she gets the error).

This user is able to see the city/state/zip on the report in my small, temporary database with every test that I've tried, but still can't see it in the production version. I tried to duplicate on this small, temporary database everything that I do during my installs (create MDE, password protect, encode, setup permissions) and everything WORKED in the small, temporary database but NOT in the production database.

Please HELP!!

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Access 2003 and Vista networking Vista networking & sharing
Access 2003 is always crashin gon Vista Vista performance & maintenance
Not able to access SBS 2003 PC from Vista 64-bit Vista networking & sharing
Office 2003 (Access) and Vista Vista General
Microsoft Office 2003 compatibility - Specifically - Access 2003! Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46