A
AlecJames
Hi
I have an Access 2003 project connected to a sql server express database.
I used the "Database Utilities->Transfer database" to replicate the database
on a sql server 2000. The “include data†check box was checked. The transfer
failed. It creates the tables and fields correctly but does not copy the
data across - it stops with an error message -
[Microsoft][ODBC SQL Server Driver][SQL Server] User does not have
permission to perform this action.
If I open a table, only the column names are shown - I cannot enter a new row.
I can open the newly created database in SQL Server Management studio
Express and enter data into one of the new tables that the Access 2003
transfer has created. I can see that data if I reopen the table in access.
In every case I use Windows Authentication to connect to the database. I
want the “transfer database†function to copy the data and I want to be able
to edit the data when I open a table in access.
I'm new to sql server and access projects so I don't know where to start.
Any suggestions appreciated.
Thanks
Alec
I have an Access 2003 project connected to a sql server express database.
I used the "Database Utilities->Transfer database" to replicate the database
on a sql server 2000. The “include data†check box was checked. The transfer
failed. It creates the tables and fields correctly but does not copy the
data across - it stops with an error message -
[Microsoft][ODBC SQL Server Driver][SQL Server] User does not have
permission to perform this action.
If I open a table, only the column names are shown - I cannot enter a new row.
I can open the newly created database in SQL Server Management studio
Express and enter data into one of the new tables that the Access 2003
transfer has created. I can see that data if I reopen the table in access.
In every case I use Windows Authentication to connect to the database. I
want the “transfer database†function to copy the data and I want to be able
to edit the data when I open a table in access.
I'm new to sql server and access projects so I don't know where to start.
Any suggestions appreciated.
Thanks
Alec