text changing to boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database set up to track quotes for an insurance company. I added a new column to the database for Policy Numbers. But for some reason after you input the Policy Number, after a day or two the number changes into a bunch of blocks. This is stange seeing as though the rest of the columns work fine. The column is a standard text column with nothing special done to it. All settings are default. After the blocks appear, and when you try to change them you get an error and it wont let you change the number

Any help would be greatly appreciate
Thanks in advanc

Jeff
 
Jeff,

It sounds like your database may be starting to become corrupt. I would try creating a brand new
database, and then import all objects from the source DB into this new database. Make sure to
set references appropriately (ALT F11, then click on Tools > References), and then do a Debug >
Compile DatabaseName.

If you reply back, please indicate which version of Access and the operating system. Also, what
service packs do you have applied to Office, your Op. System, and to Jet?

Tom
________________________________________


I have an Access database set up to track quotes for an insurance company. I added a new column
to the database for Policy Numbers. But for some reason after you input the Policy Number,
after a day or two the number changes into a bunch of blocks. This is stange seeing as though
the rest of the columns work fine. The column is a standard text column with nothing special
done to it. All settings are default. After the blocks appear, and when you try to change them
you get an error and it wont let you change the number.

Any help would be greatly appreciated
Thanks in advance

Jeff
 
Well, its a brand new database, only has a few records in there, so replacing it is no problem. I just dont want it to happen again, was wondering if there was a reason.

Its Office 2000, on a Win2k server, the clients are Win2K and NT4.0
no service packs are applied to office, that was going to be my next step

thanks for the repl

Jeff
 
Hi Jeff,

You should apply service pack 3 to Office 2000. This will help prevent any occurrences of a very
nasty corruption problem with VBA code (Network Connection may have been lost:
http://support.microsoft.com/?id=304548). I'm pretty sure this is not the cause of your current
problem, but you really don't want to run into this issue later on.

You should also apply the latest service pack to JET on these three machines:
How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/?id=239114

Also, apply the latest operating system updates to each machine. You can see your current
operating system service pack by going to Start > Run and enter Winver For Windows 2000,
this should show Service Pack 4.

Check out Tony Toews site for causes of corruption:
http://www.granite.ab.ca/access/corruptmdbs.htm
http://www.granite.ab.ca/access/corruption/causesoplocks.htm


Tom
___________________________________________


Well, its a brand new database, only has a few records in there, so replacing it is no
problem. I just dont want it to happen again, was wondering if there was a reason.

Its Office 2000, on a Win2k server, the clients are Win2K and NT4.0.
no service packs are applied to office, that was going to be my next step.

thanks for the reply

Jeff
 
Back
Top