[MS_AccessPros] Changing links to multiple back ends

 

I've been reading through the code in John's code in Inside Out and at http://tech.groups.yahoo.com/group/MS_Access_Professionals/message/99444, as well as Bill's at http://tech.groups.yahoo.com/group/MS_Access_Professionals/message/99443

I have 3 separate back ends with different data (can explain that and you can try to get me to change that later). When the sales manager travels, he takes a local copy of the database with him. He first copies the back ends to a local drive, then I update the links. I'd like to automate this.

First, how would I automate copying, for example, g:\datafile1.mdb, g:\datafile2.mdb, etc., to c:\localfolder?

Second, using either of your codes above, I'd need to get the file name of each table to use when I reconnect to the same table in a local file. What's the code for doing that? It's not, but something like
stFileName = tdf.dbAttachedTable.FileName

Adam
Denver, CO

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___