DoCmd.TransferDatabase gives "2498" error

Hi, for some reason I am getting a "2498" error “An expression you entered is the wrong data type for one of the arguments” when I attempt to run this DoCmd.TransferDatabase feature.
What am I doing wrong? I have triple check ALL the names.

E:\NCHE\ExternalDatatoImport\comprehensivedatafiles.mdb is the location I am copying from
The code resides and the table is being copied to E:\NCHE\WorkingFiles\Issues5.mdb

The table name I want copied is data_members
The table I am importing to is also called data_members and is just structure.

Here’s my code:

Private Sub cmdImport_Click()
Dim strNAME As String
strNAME = Me.txtProperties
Dim intAwnser As Integer
intAwnser = MsgBox("Are you sure you want to run the import function?", 4 + vbCritical, "Run Import?")
If intAwnser = 6 Then
DoCmd.TransferDatabase acImport, , "E:\NCHE\ExternalDatatoImport\comprehensivedatafiles.mdb", acTable, "data_members", "data_members", "False"
 MsgBox "Done"
Else
Exit Sub
End If
End Sub

If any one can see what I am doing wrong I would really appreciate it!
Thanks,
Jacob
LVL 2
JakeBushnellAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornSQL Server Data DudeCommented:
> "False"
Just use False, without the double-quote marks.

Hope this helps.
-Jim

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
thenelsonCommented:
Just to expand on Jim's answer:
"False" is a string containing the letters F a l s e
False is a built in constant in VB which equates to 0
To see the difference try:
msgbox not False
and
msgbox not "False"
in the immediate window of VBE
JakeBushnellAuthor Commented:
Hmm, looks like I have more then one problem.  Now it says
“Runtime error “2507” The type isn't an installed database type or doesn't support the operation you chose. “

Jacob
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Jim HornSQL Server Data DudeCommented:
You could avoid the DoCmd.TransferDatabase command (I don't use it in my apps), and just use linked tables + append queries.
JakeBushnellAuthor Commented:
Thanks guys, I also need to explicitly define what type of data it is. I just inserted "Microsoft Access" and wala!
Thanks so much!

Yeah, I realize now there are several ways to do it but this seemed the easiest for a beginner like me :)

JakeBushnellAuthor Commented:
The other reason I wanted to use this is it will be regularly used every 3 months with new tables that will have the exact same structure every time.
Thanks again!
Jacob
thenelsonCommented:
>regularly used every 3 months with new tables
What Jim was saying about "linked tables" will take care of that too.  To try it, back up your database, goto Tools>database utilities>database splitter.  That will split your database to a front end with all the forms, reports, code and all the "running parts" and a back end which will have the tables with the data.  Every three months, you just change out the back end.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.