Stored Procedure names are different
An Access 2000 adp (ade) app has been running smoothly on Windows 2000 paltform with a SQL 2000 backend database. Recently, the app has been installed on an XP Professional desktop and immediately ran into the problem where all the Stored Procedures in the SQL 2000 database is interpreted by Access 2000 connection as having ";1" added to the end of each Stored Procedure. Actual SQl 2000 database has the correct names for the Stored procedures (without ;1 at the end of the names). However, the data source behind the various forms are pointing to the correct names of the stored procedures and the project shows these names as having ;1 added to the end of each therefore creating a discrepancy between the real source and what the project seems to think.
Any ideas would be greatly appreciated
Thanks
|