#Error

[vanny]

Hi, hope someone can help me.

I have a table stored in the database and all of a sudden when I tried to input a new record, an error happened giving #Name in the Form and #Error in the Table. When clicking on the field directly in the table, it gave me Invalid Argument.

Can someone tell me the cause and reason for all this.

Thanks a lot

 

[Dennisk]

sound like a corrupted database. run the compact and repair

 

[vanny]

Yes I will definately try that out. Any idea how that could have happened??

 

[Dennisk]

if the database is running on a network then that is your problem.

 

[vanny]

Yep it is actually running on a network..so what do you suggest, so that next time I can avoid such problems?

thanks for the help..very much appreciated.

 

[Rabbie]

If you have a DB on a network with several users it is always a good idea to split the DB into FE/BE

 

[vanny]

In fact the DB is split : thus tables are separted in one db which is linked to another having all the forms, queries, reports etc.

 

[Simon_MT]

Basically, only the data is stored on the Server (BE) whilst the users (FE) have an mde file that contains all the Forms, Reports, Queries, Scripts and a linkage or connection to the backend.

Simon

 

[Rabbie]

Each use should have their own copy of the FE part to avoid corruptions.

 

[vanny]

Currently both FE and BE are on a common network. Thus better if I leave the BE(tables) on the common network and store the FE(forms etc) on each users' directory.

Thanks a lot

 

[Rabbie]

Exactly. That should significantly reduce your risk of corruption

 

[vanny]

Thanks guys a lot for your help and ideas.

 

[Simon_MT]

The one issue with FE / BE is having an always open situation on the locking file of the BE. The performance of Access can be greatly enhanced with a Form (always open)bound to a Table at the Back End. The file can be useful or a dummy.

Simon

 

[voidcranium]

The one issue with FE / BE is having an always open situation on the locking file of the BE. The performance of Access can be greatly enhanced with a Form (always open)bound to a Table at the Back End. The file can be useful or a dummy.

Simon

Can you give an example of this?

 

[Simon_MT]

I have a Menu system starting with a Menu Form which is the Default Form opens when the database opens. This is bound to a Query from Companies returning just one record.
This Form is never closed until exiting the database. Therefore on the BE the ldb file will have an entry for every user logged into the database.

Simon