Multi users Access 2010

[Acke]

I have a DB that was in use on one computer. Now, I need to set it to work simultaneously on two computers.

DB is split to one Access file that contains only tables and to another that has forms, reports, queries, macros and modules. One copy of Access file containing forms, reports... is copied on the computer nr. 2 while computer nr. 1 contains one copy of file with tables and one copy of file with form, reports... Both Access files with Forms, Reports... are accessing the same one file containing tables.

It all works fine in case program is active only on one computer, or if it is initiated first on computer nr. 2 and then on computer nr. 1. In case the program has been initiated on computer nr. 1 first, it does not work on computer nr. 2. Messages "Invalid database object reference." followed by "Object invalid or no longer set." then followed by "The visual basic for Applications project in the database is corrupt." then again for 4 times "Object invalid or no longer set." then again "Invalid database object reference." for 3 times and after that Access allows only blank database to be opened.

What should I do to make computer nr. 2 work unrelated to which machine triggered it first?

 

[spikepl]

Default open mode in Access Options is set to Shared on com 1?

And just a side comment: was the DB designed from the outset to be shared by multiple users?

 

[Acke]

Default open mode is set to Shared on com 1.

The DB is about 12 years old. It use to work in multi-user enlivenment before, but under XP and prior Win versions. It worked perfect.

I had some advance in the meantime... I made some permissions on the file and folder containing the table file. I managed to trigger program from both machines unrelated to which machine triggered the program first. Now, I am experiencing something very strange. Some forms on the com 2 are working fine, while others are not working. If I open the form that is not working on the com 2 in the design view, open record source, select datasheet view, the form starts working.

 

[spikepl]

"not working" conveys 0 information. Describe the specific symptoms.

 

[Acke]

Solved! Made new 2007 version file, imported all queries, forms, reports, macros... Everything is working now.

I do not know why everything has to be so complicated with new office and Win versions. Old ones were simple and easy to use.

spikepl, thank you for your interest in my problem!!!

 

[spikepl]

I suspect that the db was copied and not compiled on a new OS.

In the future: ban "not working" from your vocabulary when asking for support. It only means somehing to you , but nothing to someone not watching your screen.

 

[Acke]

Yes the db was just copied, not compiled and thanks for suggestion regarding "not working"!