Access 97 won't let me in and created Record-locking 1

[kiiwii2]

Hi,

We recently had some problem with our Access Database while trying to attempt to print a large merge file. Since then the file grew close to 20,000 kb. We repaired/compacted and it reduced size, but it will not let us in. I think the problem is that it created a Micrsoft Access Record-Locking file... Any ideas how we can solve this problem.

 

[flyover789]

what do you mean by "it will not let us in"?
any errormessage or do you have to enter a password?

suggestion: try to import all DB objects into a new, blank DB.

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[kiiwii2]

From the main computer the message is "this program has preformed an illegal operation and will shut down.

From the other computers on the network..
Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

If youj were in the middle of something... lost

Please tell Microsoft abou this problem...

To see what date this error report contains...

 

[flyover789]

did you try out my suggestion?
suggestion: try to import all DB objects into a new, blank DB

fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[kiiwii2]

Hi Fly,

Woo Woo! It worked. I imported all the tables, forms,queries, resorts... It did not want to bring in the forms or reports so I took them from an old copy.

Thanks Again,

Kiiwii