Relationships not linked when linking tables

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?
 
R

Rick Brandt

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top