Hi,
I have an Access 2000 database(auto retrieve.mdb) that has a macro in it which runs automatically when the file is opened and amongst other tasks populates another access 2000 database. Recently I’ve upsized this “other” database to SQL Server 2000 and I am hoping to change the macro in the auto retrieve.mdb to populate the SQL database as opposed to the “other” access database.
I’ve tried converting the auto retrieve db to 2002 – 2003 and changing the action in the macro to ‘transferSQLdatabase’ as opposed to ‘transferdatabase’ but I still receive read only errors and unconverted database errors when I run the macro. in the transferSQLdatabase action I’ve checked Yes for use a trusted connection, do i also need to put in a username and password for the server I intend to update to ?
Any help is much appreciated
Thanks
