Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 7 with Access Project (Can't export table as a user)

Status
Not open for further replies.
18181956

18181956

Programmer
Sep 26, 2003
2
DE
Hallo
I need some help. I have a Database on a SQL Server 7. I want to export a table with this script:
DoCmd.TransferDatabase acExport, "MicrosoftAccess", "A:\bemfrc.mdb",
acTable, "BasicDepInfo", "BasicDepInfo"
I am the dbo owner and I don't have any problem doing it but if I log on as a user it gives me a popup: can't find the object "BasicDepInfo"
Do I have to change any rights for the user that he can export the table or is there any other way? Any suggestions???
Thank you.
Sieglinde
 
Status
Not open for further replies.

Similar threads

scamquist58
  • Locked
  • Question
VB Change Default Printer - Access
Replies
1
Views
338
combo
combo
breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
378
breezett93
breezett93
dw134
  • Locked
  • Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
338
dw134
dw134
InspectorHound
  • Locked
  • Question
Creating an MS Access 2013 project with multiple forms
Replies
1
Views
375
lameid
lameid
techstudent01
  • Locked
  • Question
Convert MS Access SQL queries to AIX SQL queries
Replies
0
Views
337
techstudent01
techstudent01

Part and Inventory Search

Sponsor

Back
Top