I have Access 2007. (I have little experience using Access and have learned
the hard way. The person before me actually started Access and I picked up
where they left off.) I have problems with export using Microsoft Word Mail
Merge. It will not let me access Microsoft Word where my letters are located
or to create a new letter. The message I receive is: ODBC Microsoft Access
Driver Login Failed; "Locked for editing by another user". This is the only
computer in the office that has Access. Can I delete Access and reinstall
without losing all my tables, queries, forms and reports? Thanks in advance
for any help.

Marilyn

You've come up with a solution -- delete Access -- but haven't described how
you think that will help.

The error message you described implies that Access isn't able to use an
ODBC connection.
?can you confirm that your PC still has an ODBC connection?
?have you checked to make sure there isn't an .accldb (a "locking"
database) file? That could confuse Access and make it think someone else
has it open.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Marilyn Myers" <(E-Mail Removed)> wrote in message
news:4946738C-D988-48C6-B56B-(E-Mail Removed)...
>I have Access 2007. (I have little experience using Access and have
>learned
> the hard way. The person before me actually started Access and I picked
> up
> where they left off.) I have problems with export using Microsoft Word
> Mail
> Merge. It will not let me access Microsoft Word where my letters are
> located
> or to create a new letter. The message I receive is: ODBC Microsoft
> Access
> Driver Login Failed; "Locked for editing by another user". This is the
> only
> computer in the office that has Access. Can I delete Access and reinstall
> without losing all my tables, queries, forms and reports? Thanks in
> advance
> for any help.

Hi Jeff,
1. Control Panel>Admn Tools>Data Sources(ODBC)--This is whats listed there:
dBASE Files>Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)
Excel Files>Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
MS Access Database>Microsoft Access Driver (*.mdb, *.accdb)
2. I can use my tables to merge with Word, but when I look at my queries,
the one I'm trying to use under "Date Mailed" has a criteria of Between
[Begin Date] and [End Date]. When I remove the criteria, the merge will
work. Could this be my problem??
Marilyn

"Jeff Boyce" wrote:

> Marilyn
>
> You've come up with a solution -- delete Access -- but haven't described how
> you think that will help.
>
> The error message you described implies that Access isn't able to use an
> ODBC connection.
> ?can you confirm that your PC still has an ODBC connection?
> ?have you checked to make sure there isn't an .accldb (a "locking"
> database) file? That could confuse Access and make it think someone else
> has it open.
>
> Regards
>
> Jeff Boyce
> Microsoft Access MVP
>
> --
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
>
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
>
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
>
> "Marilyn Myers" <(E-Mail Removed)> wrote in message
> news:4946738C-D988-48C6-B56B-(E-Mail Removed)...
> >I have Access 2007. (I have little experience using Access and have
> >learned
> > the hard way. The person before me actually started Access and I picked
> > up
> > where they left off.) I have problems with export using Microsoft Word
> > Mail
> > Merge. It will not let me access Microsoft Word where my letters are
> > located
> > or to create a new letter. The message I receive is: ODBC Microsoft
> > Access
> > Driver Login Failed; "Locked for editing by another user". This is the
> > only
> > computer in the office that has Access. Can I delete Access and reinstall
> > without losing all my tables, queries, forms and reports? Thanks in
> > advance
> > for any help.
>
>
> .
>