Invalid Bracketing of name

[HansV]

What if you enter

SELECT * FROM PamM_Table

in the Command Text (SQL) box of the Query Manager?

If that doesn't help, try assigning a drive letter to the V:\CORPDATA17\RES\Cross Affiliates\AACDB ACCESS Database folder. Let's say you use Z:. You could then use

SELECT * FROM "T:\AACDB_Current_Database.mdb".PamM_Table PamM_Table

SELECT * FROM "Z:\AACDB_Current_Database.mdb".PamM_Table PamM_Table

[Reimer]

Hans,

Did you mean SELECT * FROM "Z:\AACDB_Current_Database.mdb".PamM_Table PamM_Table?

[HansV]

Yes, sorry, I'll correct my reply.

Thanks!