Hi
Can any one tell me what is meant if access appends a ";1" to the names of
stored procedures?
Note, that the ";1" isn't already part of the name of the procedures
name as they exist in the database served from the MSDE2000 server, nor
does it become part of the name, but it is how they appear it the access
container window. Two different machines can browse the same database,
server from the same machine and each see a different version of the name
(one with the ;1 suffix and one with out). Of course trying to execute or
design the procedures fails as MSDE simply reports back that the procedure
doesn't exist.
Another interesting observation is that the problem is machine specific -
a machine that adds 'sees' the suffix always sees suffix and a machine
that doesn't never does - even though (we believe) the software (os,
access version, msdac version and service pack levels are the same)
Any information about what ;1 means, what could be causing it, or how we
can stop it would just make my week complete
Thanks
Glenn 1 1613
It's a bug.
You need to apply a service pack for office.
There is a kb article on http://msdn.microsoft.com/support but I can't
remember what it was, just saw it last week from another post.
--
Jerry Boone
Analytical Technologies, Inc. http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access
"Glenn Davy" <vm*****@tpg.co m.au> wrote in message
news:pa******** *************** *****@tpg.com.a u... Hi
Can any one tell me what is meant if access appends a ";1" to the names of stored procedures?
Note, that the ";1" isn't already part of the name of the procedures name as they exist in the database served from the MSDE2000 server, nor does it become part of the name, but it is how they appear it the access container window. Two different machines can browse the same database, server from the same machine and each see a different version of the name (one with the ;1 suffix and one with out). Of course trying to execute or design the procedures fails as MSDE simply reports back that the procedure doesn't exist.
Another interesting observation is that the problem is machine specific - a machine that adds 'sees' the suffix always sees suffix and a machine that doesn't never does - even though (we believe) the software (os, access version, msdac version and service pack levels are the same)
Any information about what ;1 means, what could be causing it, or how we can stop it would just make my week complete Thanks Glenn This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: haoren |
last post by:
Can anybody help me with this problem:
How can I echo a string that contain <? and <?php?
For example,
$str="test <? and <?php echo";
echo $str;
|
by: JMCN |
last post by:
is it possible to have two tables as field source in a form? for
instance i created a query that concatenates the comments fields from
two tables (see below). i can easily create a subform however, the
comments field needs to be updateable. as i am writing this, i think
it may be impossible.
if any one has any suggestions, it will be...
|
by: JMCN |
last post by:
hello
i am not getting the correct percentage results from the following
code. the "prelimpercent" variable = 0? why would that be the case
when i try to divide numrecs by numrecs2?
any advise would be appreciated. thanks in advance - jung
*************************************************************************
Dim rst, rst2 As...
|
by: aa |
last post by:
How to save and read the picture with MS ACCESS in ASP.NET.
It woul be good in VB
|
by: Vycka |
last post by:
Hello,
There is a enterprise web application that is based on asp.net technologies
and works on Microsoft IIS. The total number of users is 850. When the load
of system gets very high, the system stops working and all users are
receiving an error (see at the bottom). Doing IISRESET or restarting server
helps (but just until the next big...
| |
by: yxq |
last post by:
Hello,
The XP Desktop clean wizard can get the last access time of desktop
shortcut, i found that the info come from
"HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\UserAssist\{75048700-EF1F-11D0-9888-006097DEACF9}\Count"
The valuename and value are encrypted using ROT13, the function below can
decrypt them
...
|
by: Jon Noring |
last post by:
Out of curiosity, may a CDATA section appear within an attribute
value with datatype CDATA? And if so, how about other attribute
value datatypes which accept the XML markup characters?
To me, the XML specification seems a little ambiguous on this, so
I defer to the XML authorities. Refer to sections 2.4 and 2.7 (it all
hinges on if CDATA...
|
by: freegnu |
last post by:
how to declare a friend function that can access two class
it will look like the following
class A
{
private:
int i;
public:
A(){}
~A(){}
friend void call(A &a, B &b);
|
by: webmasterATflymagnetic.com |
last post by:
Folks,
I'm struggling to put the question together, but I have this problem.
I have written an HTML form that I can use for data entry. This uses
PHP to write a SQL UPDATE command that gets written to my MySQL
database. I can later view this data back in the form.
One thing I've noticed happening is if I enter code such as < it
gets...
|
by: Kitty001 |
last post by:
Hi Guys
I am new to MS Access and using MS Access2007.
I have been fooling around with Access trying to solve this problem for weeks but i just cant seem to chack it and I need some help.
I have a database based on the machines used for the maintenance of a golf course here in South Africa.
I have tables containing the "Groups of Machines",...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |