troubleshooting Question

Why Access 2010? - Seems MDB has less crashes with Remote Desktop

Avatar of GNOVAK
GNOVAKFlag for United States of America asked on
Microsoft Access
9 Comments1 Solution795 ViewsLast Modified:
I had programed in VBA utilizing Access 97, 2000, etc. We use ODBC connections & linked tables to Oracle. We're using Access on a Remote Desktop.
Occassionally when opening a .accb file, I cant get at the Modules.
In order to get there, I sometimes have to relink tables.  This morning even that didnt work. I copied the .accb to my desktop using VPN, and Voila! it worked.
If I save it as a .MDB and copy it back, it works. If I copy it back as a .accb, no luck.
That would be fine except I made the error of trusting Microsoft and utilized a navigation form. I now can not convert the .accb to an mdb for another app that I developed.

SO it seems like MDB is the right way to go.
What does the .accb buy me except more headaches?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros