Re: Data corruption with SQL server installed

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: Print/Email command buttons no longer work
    ... Check that none of you references are missing. ... In a VBA window click Tools, ... References and fix any that show as missing. ...
    (microsoft.public.access.forms)
  • Re: Date/Time help
    ... Try typing Ctrl-G to open the VBA window and type ... it appears to be the very common References ... Uncheck it, recheck it, close and open Access. ...
    (microsoft.public.access.queries)
  • Re: XP and 2000 differences....problems
    ... You probably have a problem with references. ... Open the VBA window. ... If any are marked as missing, ... MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: Problem w/ Word 97 templates in Word XP
    ... Possibly references in the macros that have not upgraded or code that purely ... Opening the VBA window using alt + F11 and click tools ... the code for your version of word and whatever automation app you are using. ... Hope this helps it depends on what the template is designed for, ...
    (microsoft.public.word.docmanagement)
  • Re: Database connection problem on VB6.0
    ... You'll need to post more information about which References ... it'll help if you post how you're declaring ... Microsoft DAO 3.6 Object Library, ... Private autodrs_db As Database ...
    (microsoft.public.vb.general.discussion)
Loading