Hi Marybeth (and others),
You might not want to include all of your private information in your postings. I don't know if it will cause any harm but if it's not pertinent to your question then you should probably delete the private signature stuff before posting.
Sent: Wednesday, March 28, 2018 2:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Learning SQL BE/Access FE
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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar