Re: Data corruption with SQL server installed

Did you check the order of the references and make sure that 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?

If the DAO library comes after the ADO library, you must qualify all
database objects with their full name, ie you must write « Dim rs as
DAO.Recordset » and not just « Dim RS as Recordset »; otherwise an
ADODB.Recordset object will be created because its reference comes firsts.

If not clear from your post if your trouble started after just the
installation of MSDE or after the upsizing of your database to MSDE. From
your first post, I've concluded that you have only installed MSDE without
making any upsizing and that the simple fact of installing MSDE on your
machine have corrupted your MDB database file.

If you are now working with an upsized database and linked tables, you
should say so because many things are different when you are working against
a MSDE or SQL-Server database.


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


"Stephen Raftery" <StephenRaftery@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:F2C967FF-2849-4791-9A5A-425A5FCEBEBF@xxxxxxxxxxxxxxxx
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: Access 2000 Onnotinlist exact add entry to source table setu
    ... >> Private Sub Combo21_NotInList(NewData As String, Response As Integer) ... > "Database" is unknown, because a reference to DAO is missing. ... > check the "Microsoft DAO x.y Object Library". ...
    (microsoft.public.access.formscoding)
  • Re: Database object missing on new databases???
    ... >From the code window, choose References on the Tools menu, and check the box ... Microsoft DAO 3.6 Library. ... > database object no probs. ... > cannot find a reference to DOA which the database object ...
    (microsoft.public.access.modulesdaovba)
  • Re: Split a database
    ... I do have a reference to Microsoft DAO 3.6. ... I am using Access 2003 but the database format is 2000. ... applications with different names, let's say App V01.mdb and App ...
    (microsoft.public.access.modulesdaovba)
  • Re: Searching for a record
    ... your database. ... When viewing code go to the \\Tools\References menu ...
    (microsoft.public.access.modulesdaovba)
  • Re: Component Creation
    ... Simply create ASP.NET application, reference a library and ... > database created with MSDE 2000. ... > examples in which the connection string is placed in the ...
    (microsoft.public.dotnet.framework.aspnet.security)