Web Development

Ask something
Discussion Locked

Linking Table from Secured Access Database

0 helpful
4 replies

by javedgill

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to link table from a database which is secured with user level security in Access 2003, I have a shortcut to access this database, (where workgroup info file information is there) Now , I dont know know can I import from this database, as this is only accessible through this shortcut

PLZ help, thanks in Advance

4 replies

by bfilmfan

Put the database on a network server instead of a workstation and have the user security group rights set correctly for read and list on the secure file in question.

by sheryl v

Try creating a make table query in design view and in the properties of the query use the SourceDatabase and the SourceConnectStr for the workgroup, pswd etc. just like in the target of your shortcut. Good Luck.

by javedgill

I am trying to link tables in secured databses or I would say from a secured database , i was trying to use this procedure but I wonder if a make table query can link a table in the current database from a secured database(for which I have that shortcut), thanks for your help

This discussion is closed to new replies.