i preface this message with apologies. i'm not someone who uses
access very often, and i'm only an SQL dba on a fundamental level.
here's my situation:
an ms access database was created by an individual in my company,
since retired. this database contains a macro that runs several
queries. the primary function being to connect to an existing SQL
database, retrieve specific pieces of data, and update the ms access
the SQL database has been migrated from SQL7 to SQL2k.
in the process, the database instance and database name were changed.
when you run the ms access macro, a dialogue window pops up.
Data Source: DATABASE
enter the password, receive following error...
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been
have successfully created an ODBC connection to DATABASE, using SQL
authentication and 'loginname'. connection tests ok.
am able to log into SQL database using query analyzer and 'loginname'.
'loginname' has LOGIN to database and rights to database.
and that's where i'm stuck.
not being an access person, i can't find where in the queries that it
selects its data source. i don't even know if that's the root of the
issue. my only assumption is that since the queries are getting the
data source from somewhere, they may also be assuming a database name
that no longer exists.
i'm not going to be able to re-create the ms access database, the
queries, or the macro... but i think i can redirect what's already
any help is greatly appreciated.