urgent help please

[mhmaid]

hope someone can help with this

I using access bd since 2005
I have created a workgroup , and made it as default. this is since a year

every thing was working ok , since last wk , when i started organizing my
tables , forms. renaming some fields, deleting some fields. etc.

after this i noticed the follwing problems which does not happen always
1.if you want to open a form , it want open , even in design view
2.i get a msg like not enough memory to perform this operation , try closing
some objects , but actully no object is opened as that time.
3.logon dialogue box will not come , and db can be opened without any
password.
4.cannot import data , msg like no record found etc.
4.form wizard not working properly , especilly when it reaches the selection
of the layout.here it will give an error msg
5.if i find one form not working , i try to import the same form from my
backup copy , sometimes it works , sometimes it doesnt
5.system is slower than before , time to open the main forms doubled.
6.
size of db is about mb 25 , sometimes everything works fine , sometimes not.
tried to import all objects to another new db , same problem , but may
little less than before.

what could be the problem

 

[Arvin Meyer [MVP]]

It seems to be some form of repeating corruption, perhaps you have a video
card going bad. That is sometimes the cause. In a multi-user database, the
most often cause of corruption is a user not backing out and closing
properly, sometimes just turning off their machine to get home in a hurry.
The next most often reason is a bad (or going bad) network card. My
corruption advice is:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[mhmaid]

thanks for reply

i will go thru all what you said
thank you