Need help regarding VBA

[fiqnabas]

Hi guys,

I need your advice and help. I uploaded my accdb file in a server meant to be used by users across the network. Initially I can run the database but after some time when I opened the database again, it says:



"The VBA modules in this database appear to have been saved with errors. Access can recover the modules, but you should backup the database first. To cancel so you can make a backupcopy of the database, click Cancel. Then make a backup copy of the database.
If you have a backup copy of the database, click OK. When the database opens, examine the modules to see that they are correct. If they are not, you should revert to a recent backup"

I already made a copy of the database after clicking cancel. Then I Clicked "OK" and I get this message:

"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project"

What should I do? What may have caused the error?
I have attached the accdb file for your reference and testing.

I appreciate all your help. Thank you.

[RuralGuy]

Can you compile your project without errors? Does everyone using the db use Access 2007 or do some have Access 2010?

[bcofie]

Hold down shift key and open database. Need to comment "SetStartupProperties". I am looking and can't find any problems though. Still looking.
I was able to open database without any problem.

[fiqnabas]

@RuralGuy - Yes I am able to compile without errors.

@bcofie - Yap I'm able to run the database but I faced problems when I set up the databse in a multi user environment.


I believed since I'm running the databse in a multi-user environment, I need to split the database according to a Back-end/Front-end schema. I think I cannot safely work with an Access database in multi-user mode if the interface is shared. Sooner or later , the database becomes corrupted.

I'm aware that I can use the database split assistant. However when I tried to split the database using the wizard, there is a prompt :

"The search key was not found in any record."

However the back end file was still created in the designated directory.Thou upon opening the file, there are no tables and blank interface.

This is my first time using the database splitter option. I'm in need of your guidance and advice. Many thanks once again!

[RuralGuy]

The best Multi-user link I've ever found: http://www.accessmvp.com/TWickerath/.../multiuser.htm
BTW...I get an error when I compile in one of your modules that uses the Me keyword.

[fiqnabas]

Hi guys,

Thanks for the advice.

I found this link : http://support.microsoft.com/kb/304932#appliesto which is helpful.

By the way I read and understand the guidelines but encountered one problem. It seems that the 'Category' table cannot be imported into the back end database as there is an error 'Operation is not supported for this type of object.'Can you help me to take a look at the problem and rectify it if possible?

By the way I did manage to create the front end database without problem. The only thing is upon opening the front end database, it did not load the login interface automatically.

I have attached the front end and back end files for your reference.
I seek your assistance. Thank You.

[RuralGuy]

Here's directions on how to do that: http://www.btabdevelopment.com/ts/de...aspx?PageId=96