B
Brant Gluth
I've got a uniquely annoying problem that I haven't found a resolution to
yet searching the newsgroups, so I thought I'd pitch a fit here
I've got a SQL 7.0 server. I have two development machines, one a Win 2K
with Office 2K, the other an XP Pro with Office XP Pro.
On the 2K machine, I created an ADP in access to access a database on the
SQL server. On that machine, I see everything the way I expect it, have no
problems logging in with either the SA account or the editing account I set
up.
I copied the ADP over to the XP machine, and opened it. I cannot access the
server using the editing account, but can access the account with the SA
account. But wait, with the SA account, I only see seven of the forty
tables. Also, I see none of the Stored procedures I created, but have ten
procedures that I did not create. Now the funny part is these procedures all
have a name similar to "sp_MSdel_tbl_CounterLists", and match each of the
tables that do show, and all have a similar format to:
"ALTER procedure sp_MSdel_tbl_CounterLists @pkc1 char(10) as delete
"tbl_CounterLists" where "strSKU" = @pkc1"
Thinking I had a bad install, I uninstalled the Office from the XP machine,
reinstalled, then reapplied the SP's. Has anyone had a similar problem or
has an idea of what may be happening here? Any input would be greatly
appreciated.
--
Brant Gluth
O'Boise Systems and Services
(e-mail address removed)
(970) 231-416
Tho' much is taken, much abides; and tho'
We are not now that strength which in old days
Moved earth and heaven: that which we are, we are;
One equal temper of heroic hearts,
Made weak by time and fate, but strong in will
To strive, to seek, to find, and not to yield.
Tennyson, "Ulysses"
yet searching the newsgroups, so I thought I'd pitch a fit here
I've got a SQL 7.0 server. I have two development machines, one a Win 2K
with Office 2K, the other an XP Pro with Office XP Pro.
On the 2K machine, I created an ADP in access to access a database on the
SQL server. On that machine, I see everything the way I expect it, have no
problems logging in with either the SA account or the editing account I set
up.
I copied the ADP over to the XP machine, and opened it. I cannot access the
server using the editing account, but can access the account with the SA
account. But wait, with the SA account, I only see seven of the forty
tables. Also, I see none of the Stored procedures I created, but have ten
procedures that I did not create. Now the funny part is these procedures all
have a name similar to "sp_MSdel_tbl_CounterLists", and match each of the
tables that do show, and all have a similar format to:
"ALTER procedure sp_MSdel_tbl_CounterLists @pkc1 char(10) as delete
"tbl_CounterLists" where "strSKU" = @pkc1"
Thinking I had a bad install, I uninstalled the Office from the XP machine,
reinstalled, then reapplied the SP's. Has anyone had a similar problem or
has an idea of what may be happening here? Any input would be greatly
appreciated.
--
Brant Gluth
O'Boise Systems and Services
(e-mail address removed)
(970) 231-416
Tho' much is taken, much abides; and tho'
We are not now that strength which in old days
Moved earth and heaven: that which we are, we are;
One equal temper of heroic hearts,
Made weak by time and fate, but strong in will
To strive, to seek, to find, and not to yield.
Tennyson, "Ulysses"