Re: Data corruption with SQL server installed

I have tried a recompile, but the problem is still there.

By way of explanation, one of teh procedures involves adding a new record to
a table of transaction, for which I use a recordset .AddNew method. When the
..Addnew executes, it fills every field in the table with the value of the
Primary key field (which is an autonumber field), and ignores the
instructions to give the values I specify. Since some of the fields are
strings, and some are boolean, the .Update method fails.
This is quite exasperating.

Stephen


"Sylvain Lafontaine" wrote:

Maybe a mixe-up in the references: check the References in the VBA window
and make sure that the Microsoft DAO 3.6 Object Library is selected and that
is displayed *before* the Microsoft ActiveX Data Objects 2.5 library and not
after it.

While in the VBA window, it might also be a good idea to make a full
recompilation: add a dummy reference in the references window and then make
a full recompilation from the Debug menu. Having added a new reference will
force Access to recompile everything.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Stephen Raftery" <StephenRaftery@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:499F3010-1381-4875-B1A4-E62FCB2206F8@xxxxxxxxxxxxxxxx
Can anyone please help!

I have been running a database for several years, with several VB
procedures
in a variety of forms.
I have recently started thinking about upsizing to a server based
database,
so I downloaded MSDE200a desktop server emulator to see how it works.
Ever since then, all my VB procedures have gone haywire. i have SQl
statements that refuse to execute, claiming duplicate keys or similar; I
get
data conversion type errors because fields that should be simple integers
now
appear as dates, and string fields that will not accept string input, and
many such things.

I have tried disabling the MSDE and rebooting, but I cannot get rid of it.
More to the point, I cannot see why the presence of MSDE should affect the
running of pure Access files.

I would appreciate any assistance
I am using MS Office Pro 2003 under WXP Pro

Stephen




.

Relevant Pages

  • Re: Class Library
    ... Note that if you change or recompile the code database containing your ... you must recompile ALL databases that reference it. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Getting the file name from a FILE *
    ... string -- which might perhaps include the filename openned with, ... but as there can be considerable differences in parameter ... passing between non-varargs routines and varargs routines, ... I expect that that recompile / relink step would not be considered ...
    (comp.lang.c)
  • Re: calling function in C
    ... Construct a lookup table (e.g. hash table, binary search tree, or something ... associated with that string). ... The nice thing with Richard's solution is that you will not have to recompile ... since in standard C you cannot spot a function pointer by the function's name. ...
    (comp.lang.c)
  • Re: Q: // and "magic"
    ... Meaning the regex will not ... be recompiled each time perl sees it. ... regex, it will recompile it each time, even if the string hasn't ...
    (comp.lang.perl.misc)
  • Re: Unicode with D2008
    ... <chris.nospam at lynxinfo dot co dot uk> ... You are unlikely to get away with a simple recompile. ... Even simple input validation code is going to be rendered likely ... does not pick apart or otherwise process string data in any ...
    (borland.public.delphi.non-technical)
Loading