I have two problem when I work the sql data in ms-access.
1. My linked ms-access table with sql server, begins with dbo_, how to link the sql server with actual table name (for e.g. sql server table name is customer, the same when I link with ms-access, it shows dbo_customer in ms-access). How to show the actual table name in ms-access as appear in the sql server?
2. I'm wondering, the linked sql server table, I cannot change in the ms-access, it seems to be read only. I cannot make new entry, and cannot change the data also. Pls help me!