Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
S Patel
 
Posts: n/a
Default Automation of Path of linked tables

I have two access files one is My Tables and Second is My Forms.
I have all the tables in My Table database and All forms,quries and reports
in My Forms. Both of this databases and kept in one folder called My Folder.
I keep moving this My folder form my Laptop to my home computer to My work
computer. Each time I move this folder I have to re link the two databases.
Is there a procedure that I can right that will execute on opening the access
athat will check if my tables are connected or not and if not gives me a
message and asks me to connect them before I start to work. or just figures
out it self as boths the database in in the same folder called My folder.
If any one can help I will really appreciate. Earlier someone helped but It
exactly did not make clear and I am not able to get it working.
Thanks in advance.
  #2   Report Post  
S Patel
 
Posts: n/a
Default

Sorry I have Posted the question in wrong disscusion Group. Please Ignor this
question

"S Patel" wrote:

I have two access files one is My Tables and Second is My Forms.
I have all the tables in My Table database and All forms,quries and reports
in My Forms. Both of this databases and kept in one folder called My Folder.
I keep moving this My folder form my Laptop to my home computer to My work
computer. Each time I move this folder I have to re link the two databases.
Is there a procedure that I can right that will execute on opening the access
athat will check if my tables are connected or not and if not gives me a
message and asks me to connect them before I start to work. or just figures
out it self as boths the database in in the same folder called My folder.
If any one can help I will really appreciate. Earlier someone helped but It
exactly did not make clear and I am not able to get it working.
Thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and Paste Formula Without the linked file path KevinB Excel Worksheet Functions 2 January 20th 05 07:45 PM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 10:53 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 09:45 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 01:18 AM
Linked worksheets John Kelly Excel Discussion (Misc queries) 1 December 2nd 04 01:36 AM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"