Rick Brandt wrote:
sbowman wrote:
>I'm linking a bunch of tables that are in SQL to my Access db and I
get the following error on 3 of the tables: "Seq.Group is not a valid
name." I tried doing an import instead of a link, but I got the same
error. ???
FYI I am not the SQL dba and I'm not able to change table names or
reload data. I need a way around this issue stat!!
Thanks,
Shelley
SQL apparently allows characters in table names that Access does not.
Unless you can get the name changed on the server or have a view
created on the server with a proper name then you will not be able to
create the link. At least not through the linking wizard. Creating
the link via code "might" work. I'd have to test that.
Have you tried a passthrough query instead of a link?
Just tested. Apparently you have field names with periods in them. That
will not work in Access even when creating the link in code.
Tell the creator of the tables that he needs to fix them or create a view
with proper names that you can link to. IMO anyone that would put special
characters in a field name doesn't know what he's doing.
A passthrough will work, but the field name will show up as only the portion
after the period. That will make it difficult to work with because criteria
still has to be applied to the illegal name with square brackets around it.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com