Database FE freezes up every time I try to open it.

[krc547]

I created a copy of the whole db and sent it to a friend, he did a change to one of the tables to fix it (nothing to do with the login) and sent it back. The one he sent back is the one that freezes up or doesn't work with the login.

 

[cheekybuddha]

OK, did you attempt the decompile/compact and repair?

 

[cheekybuddha]

Also, does it have a backend that it's supposed to be linked to? If so, did you re-link the backend when you got it back?

 

[krc547]

It does have a backend and I did relink it once I got it back. I have not decompiled/compact yet. I waiting for the admin to get back to me.

 

[cheekybuddha]

Ok, keep us posted with progress.

Is the db mentioned in your screenshot the backend? Perhaps double-check that all table were properly re-linked.

 

[krc547]

It won't even let me open it without holding the shift key, or it locks up.

 

[krc547]

The screenshot is fe, but I did recheck the be and everything is linked.

 

[krc547]

His instructions say open any module and compile/decompile. I have no modules to open.

 

[cheekybuddha]

To decompile, you need to use a special command line argument to open the db.

It will then be in a decompiled state.

Then, compact and repair (from the Access Tools menu)

Then open any code module (e.g. a form's module), and go to the Debug menu and choose Compile.

Then compact and repair again.