Relationships not linked when linking tables

  • Thread starter Thread starter JED
  • Start date Start date
J

JED

I have a Access 2000 database split into a frontend and backend (not in
Project mode). I have VBA code to automatically link tables using
"TranferDatabase". The Linkup worked fine until I put a password on the
backend database. The VBA procedure was modified to include password handling
(CreateWorkspace & OpenDatabase with connect string "MS Access;pwd=......").
The linkup works except that the table relationships are not transferred.
Prior to the password implementation, they were transferred automatically.
What am I missing? Is there a way around this? Why doesn't it automatically
transfer the relationships like it did before?
 
JED said:
I have a Access 2000 database split into a frontend and backend (not
in Project mode). I have VBA code to automatically link tables using
"TranferDatabase". The Linkup worked fine until I put a password on
the backend database. The VBA procedure was modified to include
password handling (CreateWorkspace & OpenDatabase with connect string
"MS Access;pwd=......"). The linkup works except that the table
relationships are not transferred. Prior to the password
implementation, they were transferred automatically. What am I
missing? Is there a way around this? Why doesn't it automatically
transfer the relationships like it did before?
Click to expand...

The relationships only DO anything in the back end. In the front end they
are just lines on the screen anyway. I wouldn't worry about it.
 
Back
Top