Hi Marybeth,
Can you tell us what rights/roles you have in the SQL database? Are you using an ODBC/DSN with your connection?
Are you using SQL authentication with a login and password or Windows/Active Directory authentication?
Regards,
Duane
Sent: Thursday, March 29, 2018 8:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Learning SQL BE/Access FE
I did try and link from Access and I couldn't "see it" to select. The migration isn't working now either. I really need some guidance.
Thanks in advance.
Marybeth
Re: Learning SQL BE/Access FE
Wed Mar 28, 2018 1:10 pm (PDT) .. Posted by:
"crystal 8" strive4peace2008
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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar