After Upsizing a table to sql I linked to that table using access db
Now when i use one of my forms i get a [Invalid Object name "tablename''], not sure why but i am clearly link and the table is in sql!
Can you help!
If I recall correctly, when you link to external tables in MS Access, the linked table names are not the same as the underlying table so for example a table named foo in SQL Server could become linked as dbo_foo in Access.
I suggest you look at the Tables view in Access and rename the table to match what you want it to be or modify your forms to accept the linked table name.
Regards,
Uwa.
No comments:
Post a Comment