ODBC Database and creating a Macro

C

Carly

We are working with a medical billing software that has
very few good reports on it. I have imported the
information to Access, but the original data is changed
and ammended daily in the billing program. I tried to set
up a Macro to have Access update the database just as
frequently, but I'm not doing it right. I use
the "TransferDatabase" action, change settings to link,
then ODBC, and then get stuck on the Database Name. It
says to type in the ODBC connection string; I have
followed the instructions on how to see an example of one,
but it doesn't work either. Any help or insight would be
greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Create a Macro and Import into Access to RUN 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
TransferDatabase, Database Name ODBC connection string format 0
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
Manage ODBC 2
Password for Transfer Database 1
odbc connection fails in Office 2010 5

Top