Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-06-2015, 08:47 AM   #1
tritenick
Newly Registered User
 
Join Date: Jul 2012
Posts: 10
Thanks: 6
Thanked 0 Times in 0 Posts
tritenick is on a distinguished road
Undefined error on back-up copy

I think this is a macro issue but not sure. I have a database on my local harddrive. I am the primary user. I save the database (copy) to the network drive once a month so my supervisor can view data and reports.

He is getting undefined referrence errors when opening forms that I don't get from my local copy nor if I open the network version from my computer. It does occur if I try to open the the forms from anyone elses computer. So instead of a copy I tried doing a back-up to the network but get the same errors.

Question is: How can I duplicate the database in entirety and all related files/macros/referrences? I don't have admin rights on my computer to change settings. Suggestions?

Thanks,

tritenick is offline   Reply With Quote
Old 03-06-2015, 09:20 AM   #2
richsql
Newly Registered User
 
Join Date: Feb 2015
Posts: 23
Thanks: 0
Thanked 5 Times in 5 Posts
richsql is on a distinguished road
Re: Undefined error on back-up copy

There could be anything lurking in your db that might be referencing paths that other users might not have access to... who wrote the macros?

An area I have come across that causes these type of problems are different letters mapped to the same drive paths, make sure all drive references use Universal Naming Convention (UNC) names i.e."\\server\share\path\file" for starters..
richsql is offline   Reply With Quote
Old 03-06-2015, 10:08 AM   #3
tritenick
Newly Registered User
 
Join Date: Jul 2012
Posts: 10
Thanks: 6
Thanked 0 Times in 0 Posts
tritenick is on a distinguished road
Re: Undefined error on back-up copy

Thanks for the reply. I mostly used the embedded macros in Access (for command buttons and such) and have some hodgepodge code that I put together.

I'm not sure where the drives would be referenced. How would I check that?

tritenick is offline   Reply With Quote
Reply

Tags
copy , macros , undefined error

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC Error 1 'Undefined Function' sametch General 7 06-08-2006 07:24 AM
ODBC Error 1 'Undefined Function' sametch General 0 06-08-2006 03:55 AM
Undefined Function Error DanG Modules & VBA 6 05-10-2005 07:04 AM
Error: Undefined 'Mid' Function PaulC999 Queries 1 04-22-2002 09:57 PM
[SOLVED] Undefined Function Error JBOUTIN Reports 1 12-03-2001 05:11 PM




All times are GMT -8. The time now is 02:49 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World