hi Marybeth,
>"I couldn't see in the access FE"
to have the table show in the navigation pane, you need to link to it from Access. Did you do that? Or try that?
have an awesome day,
crystal
Afternoon,
Please forgive my ignorance in advance. I have just split a database into an SQL BE and an access FE in order to have multiple users in the database. We used a migration tool to do the split and with a few hiccups I can use it like I used to.. The other day I created a new table in the SQL BE and found that I couldn't see in the access FE. Since I don't have full rights to the server that the database lives on I am not sure if I don't have rights to alter the connection or if I am attempting to make the connection incorrectly. So I tried creating the table in the Access FE and migrating it to the BE. Two of the four tables I wanted to add migrated just fine, the other two did not – "target does not exist" was not very helpful. So my questions are since neither routine worked correctly, which would be the best way to add tables and second do you all have any ideas what went wrong with the two ways?
Thank you in advance.
Marybeth
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar