Automation of Path of linked tables

S

S Patel

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.
 
M

Micah Chaney

Well the parent folder isn't the folders' path. I would suggest creating a
folder on C:\Desktop\MyDatabase or something like that. But that's just me.
You might want to think of a more efficient method of sharing data between
your 3 computers. Perhaps exporting an update file or such and storing a
copy of the database on each machine. Good Luck.
 
D

Dirk Goldgar

S Patel said:
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.
Click to expand...

Try this:

http://www.mvps.org/access/tables/tbl0009.htm
Relink Access tables from code
 
Top