Rabu, 28 Maret 2018

Re: [MS_AccessPros] Learning SQL BE/Access FE

 

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

On 3/28/18 2:43 PM, Marybeth S Tomka marybeth.tomka@austin.utexas.edu [MS_Access_Professionals] wrote:

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)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar