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
Marybeth S. F. Tomka, M.A., PS Cert CM
Head of Collections
TARL
The University of Texas at Austin
1 University Station R7500
Austin, Texas 78712
512-475-6853 direct line
512-232-6563 fax
512-471-5960 TARL main phone
www.utexas..edu/cola/tarl/
www.texasbeyondhistory.net
State Certified Repository
Posted by: Marybeth S Tomka <marybeth.tomka@austin.utexas.edu>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar