Re: vba problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Sounds like you got some problem with your computer (setup, or install), or
some damage has occurred to your mdb file.

A few things:

can you create a mde file?

When you make a code change, try using ctrl-s to save, and then go
debug->compile

I always done the above, since you should save things when you make code
changes, and even more important is to compile the code each time.

Try also creating a blank mdb, and importing everything from the old one
into anew one.

Further, are you using the a2002 format....if not, give that try. (the
default format is a2000).

Also, I assume you installed the latest sp fixes to office....

Try all of the above and see if that helps.

Given your size of your application, and the number of forms, you are in the
medium range, and nothing close to some "large" ms-access applications with
200 meg front ends, and 2-3 times the number of forms that you got.

It is certainly not the small size of your application here..as it is common
to see applications 10 times your size...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
http://www.members.shaw.ca/AlbertKallal


.



Relevant Pages

  • Re: VB.NET Deployment - Checking for user-modified files
    ... I think your MDB file would be an unversioned file and so: ... Create date for the file on the computer, do not install the file because ... > the installation problem with preferences by using a text file for ... properties and set to not overwrite. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Method ~ of object ~ failed error while opening ADODB connection in vb6
    ... the MDAC or Jet installation is "corrupt" (anything from incorrect ... if using Vista - you can't install the MDAC as it already comes ... ActiveX Data Objects 2.7 library", ... Perhaps the mdb file is corrupt. ...
    (microsoft.public.vb.database)
  • Re: How to get table names from ms access(mdb file) by using odbc library.
    ... engine installed by default (thus you don't need to install anything on a ... windows computer to read mdb files. ... Set dbeng = CreateObject ... So there is a table collection available after you open the mdb file as per ...
    (comp.databases.ms-access)
  • Re: MDE
    ... Well, if you need word, or excel...you install word or excel. ... the code and design parts of the application (the application part is the ... or mde file..you need some ... person a 2002 version of the mdb file. ...
    (microsoft.public.access.formscoding)
  • Re: Error created linked tables from one .mdb to another .mdb
    ... > tables to SQL Server tables in my .mdb file. ... > the strConnect parameter to connect to the other .mdb file that it would ... > link properly but it fails with this messagebox message popping up: ... Sounds like you may need to install the Jet OLE DB provider on the target ...
    (microsoft.public.vb.general.discussion)