Forms

[Cristina]

Hi,
Can I please get some help with this problem.
I have an ACcess Database file on a network. However it can only be opened on one computer. The Dbase opens up to a main form called Data Entry. It contains buttons to access other forms or reports. On opening on the other computers an error box comes up saying
an error occurred while loading form Data Entry. Do you want to continue loading the project.

If you say yes and bypass and it opens, but if you click on any of the buttons an error comes up saying

The expression on Click you entered as the event property setting produced the following error. Invalid procedure call or argument. THe expression may not result in the name of a macro, the name of a user defined function of [event macro] There may have been an error evaluating the event or macro.

Thanks


Cristina

 

[Mr. B]

First, if you have need for multiple users to access the same data, you need to "split" your database.

Take a look at this link about splitting your database:
http://databases.about.com/od/tutorials/ss/splitaccessdb.htm

You may also need to take a look at the "Macro" settings in the Access Options to be sure you have enabled macros so your code will work.

You may also need to setup "Trusted Locations"

 

[Cristina]

Thank you for your response. I will not be able to try your suggestions as I have to to another office. I would like to know how to set up "trusted sources"


Thanks

Cristina

 

[Mr. B]

Here is a link about setting up trusted sources in Access 2007:
http://office.microsoft.com/en-us/a...settings-in-the-trust-center-HA010033776.aspx

Here is a link about setting up trusted sources in Access 2010:
http://office.microsoft.com/en-us/a...settings-in-the-trust-center-HA010354326.aspx

 

[Cristina]

Thanks for your help. I am still working on the DBase. I have a question : should the file "BE" be stored on the server. Presently it was on another computer in the manager's office, and we were having the same problem.

Do you think that is the problem?

Thanks

 

[Mr. B]

Cristin,

Normally, if you have a "split" database application, and each user has access to the back-end file on a shared drive, it is not critical that the file be on a server. The file can be on any shared drive. It is critical that users have write capability when accessing the back-end file. If you are using a peer-to-peer network and sharing the file on a mapped network drive, be sure that when this drive is mapped that the option to allow network users to modify my files is checked.