B
Beth
Hello,
I have a database setup in Access 2002.
I need a button on a form in the database that will import a table from a
remote database. I have that right now using the Docmd.TransferDatabase
command. However, security settings are now causing me problems with the
setting.
I have the users signed into the database in a custom users security group
in a custom security workgroup file. There is also a developer's level
security group.
As long as I allow the user level security group to have design access on
the remote database with the table they need to import all works fine.
However, I need to remove all permissions for the user group in the remote
database to restrict it to the developers.
I found reference to doing this in the transferdatabase command with a
connection string and logon, but I can't make it work.
Can anyone tell me what I need to do to allow the user group to import that
table from a remote database using the connection string?
Specifics that I think may be important:
The remote database is a Microsoft Access database named Grades
The table I need to import is 2006Grades and I want it to keep the same name
after import
Earlier in the function I defined the path and filename for the remote
database with a variable named varFilePath.
Thanks in advance for help with this.
Beth
I have a database setup in Access 2002.
I need a button on a form in the database that will import a table from a
remote database. I have that right now using the Docmd.TransferDatabase
command. However, security settings are now causing me problems with the
setting.
I have the users signed into the database in a custom users security group
in a custom security workgroup file. There is also a developer's level
security group.
As long as I allow the user level security group to have design access on
the remote database with the table they need to import all works fine.
However, I need to remove all permissions for the user group in the remote
database to restrict it to the developers.
I found reference to doing this in the transferdatabase command with a
connection string and logon, but I can't make it work.
Can anyone tell me what I need to do to allow the user group to import that
table from a remote database using the connection string?
Specifics that I think may be important:
The remote database is a Microsoft Access database named Grades
The table I need to import is 2006Grades and I want it to keep the same name
after import
Earlier in the function I defined the path and filename for the remote
database with a variable named varFilePath.
Thanks in advance for help with this.
Beth