Re: ADP works, ADE on same machine does not
- From: Philipp Stiefel <phil@xxxxxxxxxxxxxxx>
- Date: Thu, 3 Nov 2005 19:07:49 +0100
<NorbertMeiss@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> I installed Access 2003 runtime on a Windows 2000 system and tried to start
> an ADE which I had prepared shortly before on the server where the SQL Server
> 2000 database resides. I had to do so because the connection had to be
> changed because we transferred the adp from the development environment to
> the production environment. The ADE returns errors like 'The expression you
> entered as OnClick Event...' and problems with 'str, left, right, asc'.
> However I can start the adp, which was the source for creating the ade, on
> the same machine without any problems. Since there is no office installed I
> cannot really debug...
> Any ideas where to start thinking?
Check your refrences (Menu "Tools"->"References" in the VBA-Editor) of
the ADP you used to create the ADE. Remove all refenrences that you do
not need, make sure any refenrence you need is available on the target
machine.
HTH
Phil
.
- Prev by Date: Re: Connecting ADP to SQL server
- Next by Date: Re: Convert MDB to ADP
- Previous by thread: Re: Convert MDB to ADP
- Next by thread: Re: ADP works, ADE on same machine does not
- Index(es):
Relevant Pages
|
