Linking Table Error

G

Guest

Hi, I've been linking tables from AS400 and the original name in the AS400 is
blah1.blah2.blah3 so my Access would normally convert it to
blah1_blah2_blah3, however after updating the jet sp 8 now I get error
message saying "blah2.blah3" is not a valid name. And of course I also can
not update the linked tables in the DB's I've previously created with the
same table.

Please Help. Thanks
 
G

Guest

How would I bracket the table at the time of linking?
here are the steps I take:
when in tables window in MS access --> mouse right_click-->Link Table
which opens my data sourses, --> ODBC Databases -->Machine DSN-->blah1

At that time I get an error" "blah2.blah3" is invalid name. make sure it
doesn't include invalid characters...or somethink like that.

Also when I am trying to update the link in the Linked Table Manager for
that blah1_blah2_blah3 table (since this is how it use to come through before
yesterday)
it tells me invalid object proceedure.

Thanks


--
If at first you don''''t succeed, destroy all evidence that you tried.


Klatuu said:
Have you tried bracketing it?
[blah1.blah2.blah3]

kontra said:
Hi, I've been linking tables from AS400 and the original name in the AS400 is
blah1.blah2.blah3 so my Access would normally convert it to
blah1_blah2_blah3, however after updating the jet sp 8 now I get error
message saying "blah2.blah3" is not a valid name. And of course I also can
not update the linked tables in the DB's I've previously created with the
same table.

Please Help. Thanks
Click to expand...
Click to expand...
 
G

Guest

Sorry, I misunderstood your post. I thought you were trying to use the name
and it wasn't working. I don't know of any way you can bracket it during
linking.

kontra said:
How would I bracket the table at the time of linking?
here are the steps I take:
when in tables window in MS access --> mouse right_click-->Link Table
which opens my data sourses, --> ODBC Databases -->Machine DSN-->blah1

At that time I get an error" "blah2.blah3" is invalid name. make sure it
doesn't include invalid characters...or somethink like that.

Also when I am trying to update the link in the Linked Table Manager for
that blah1_blah2_blah3 table (since this is how it use to come through before
yesterday)
it tells me invalid object proceedure.

Thanks


--
If at first you don''''t succeed, destroy all evidence that you tried.


Klatuu said:
Have you tried bracketing it?
[blah1.blah2.blah3]

kontra said:
Hi, I've been linking tables from AS400 and the original name in the AS400 is
blah1.blah2.blah3 so my Access would normally convert it to
blah1_blah2_blah3, however after updating the jet sp 8 now I get error
message saying "blah2.blah3" is not a valid name. And of course I also can
not update the linked tables in the DB's I've previously created with the
same table.

Please Help. Thanks
Click to expand...
Click to expand...
Click to expand...
 

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

Inserting Calculated Variables into a table? 9
Key violation on Append Query 1
"Index already exists" error when attempting to link to AS400 tabl 1
Help needed in linking to tables using Access 2007 1
multi-level table linking 2
Merge 2 Db's 3
Type Mismatch in Expression 1
Linked Table Manager Issue 3

Top