object name doesn't follow microsoft access object naming rules

[Chuck W]

Hi,
I have a database called DB1 on my local drive. I stored it at
C:\Databases\DB1. Our company has a G Drive which I have read/write access
to. There is a database located at G:\Database\Encounter.mdb. I can click
My computer, navigate to this database and open it.

I created a macro in DB1 where I am attempting to transfer a table called
tblEncounter from DB1 to the Encounter.mdb database. I used the
TransferDatabase function and filled out the correct information regarding
Transfer Type, Database Type etc. However, I am getting an error when I run
this stating that the object name G:\Database\Encounter.mdb doesn not follow
Microsoft Access's object naming rules. I made sure that that there were not
spaces in my path but am unsure why I am getting these errors. Can someone
help?

Thanks,

 

[golfinray]

You could try using the unc path, which would be
\\servername\foldername\filename or you could just import what you want from
one database to the other.

 

[Dale Fye]

It sounds like you left out the parameter telling Access one of the following:

Transfer type: acExport
Object type: acTable

Are you explicitly defining the parameters, or just providing them in a list
separated by commas? You might want to try it explicitly:

docmd.Transferdatabase TransferType:=acExport, _
DatabaseType:="Microsoft Access", _
Databasename:="G:\...", _
ObjectType:=acTable, _
Source:="tblEncounter", _
Destination:="tblEncounter"

 

[Gina Whipp]

Chuck,

See if any of this applies to you... http://support.microsoft.com/kb/826763

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm