Access/Windows corrupted????

[Linda354]

I'm trying to run Access. I'm new to it. I programmed dBase a lot years ago, and am trying to get my bearings. I've created a database, which I broke down into a number of tables. I crashed running it several weeks ago, used WinFix to restore my Windows, completely uninstalled Office and re-installed, along with a number of other app's. I went back to work yesterday designing a form and now just switching back and forth between design view and form view, I'll get a message that my memory is full, I should close all app's. All app's are closed, including TSP's. I have 128 mg of RAM. Everything else was running fine. Something's not working right. Any suggestions?

 

[padinka]

Try compacting and repairing the database.
Trisha
padinka@yahoo.com

 

[Linda354]

Thanks, Trisha. Thought for a minute there that would work, but after a few minutes of switching back and forth between design and view modes and trying on various styles (blends, sumi painting, etc.) I got the message again that my free memory was gone. I had to re-boot.

 

[gusbrunston]

Dear Linda:

Had a similar problem some weeks ago, except my problem was ridiculously slow loading between design and form views of the main form (with big tab control and lots of subforms). I reinstalled Office 2000 Premium, etc. One very helpful friend on this site suggested I had a corrupted object somewhere in the db.

I created a blank database for the front end, and copied each macro, query, form, module and report into the new database as I needed them. (My tables are all in the back end...no need to copy...but in another case, there could be a corrupted table!) Rarely now, I have to go back to the old db to get something I missed copying.

Worked for me. Also, now I back up the front end after every session of designing...takes only seconds, and I can go back later to the version when everything worked. I can keep several incrementing versions on a 250 mb zip drive.

Another thought...last time I looked, memory was really cheap...figure 256 mb is the minimum I want and more would be O.K.

Good luck. Gus Brunston An old PICKer, using Access2000
padregus@attbi.com

 

[padinka]

Linda,

Gus has a great idea. A faster and easier method of getting the data in is to create a new database then use File/Get External Data/Import. Select your old database, then click on each tab and choose select all. Click on Options and choose the appropriate options. If in doubt select each checkbox. Takes some time but it will import each object in your database. Good luck.
Trisha
padinka@yahoo.com

 

[Linda354]

Thanks you two! I seem to be in the clear. I did what you said, Trish, just created a new table, then imported the tables and forms from the old database. I gave it the torture test of switching autoforms numerous times and it seems okay now. I remember with dBase weird things happened when files got corrupted, but it was easy to just use the dir or run commands in DOS and spot files that looked weird.

Gus, I don't know what you mean by front end and back end.

I have a few more questions, this time about a good book on learning Access thoroughly, and on usability issues in setting up forms, but I guess I'll set up new topics on those. Thanks again.

 

[gusbrunston]

Hi.

Front end contains all your forms, macros, modules, queries, reports, everything you design so that users can enter, edit, delete, or manipulate data.

Back end contains all your tables with the data.

Allows users to work with the latest version of the front end you've given them, and allows you to continue design work on the front end. When you have have a new or improved front end, you hand it out (let 'em copy over the intranet, etc.) and now everyone can enjoy your new button, checkbox or whatever.

Use Tools > Database utilities > Database splitter...but backup first! Gus Brunston An old PICKer, using Access2000
padregus@attbi.com