Multi-user set up

[David]

Hi

Please can someone help me set up a database for multiple seats?

I am able to split the databse, ie. the tables on one PC (the "server" as such) and then the forms etc on another PC. The problem seems to be with the VBA project associated with the database - it keeps telling me that it has lost the network connection, even when the mapped drives allow access to the folders on the other machines (the "server")

This is what I am doing
Create database on PC (the "Server") in shared folder on C-driv
Using TOOLS>DATABASE UTILITIES>DATABASE SPLITTER to split the database. I am placing the "back-end" (the tables) in the same shared folder
I am then going to a second PC, creting a new blank databse, and using FILE>GET EXTERNAL DATA>IMPORT to browse to the database on the Server machine, and import the forms from there
I am then using FILE>GET EXTERNAL DATA>LINK TABLE to link to the Back end of the databse on the Server
All of this is fine
However, when I try to use a button on a form (that obviously has VBA code attached, the problems start. It works at first - and then it fails, not to work again
Do I need to go to the VBA project and create a reference to the VBA project of the original databese on Server? I have tried this, and it tells me that there is a conflict as the Project name alrady exists

Any help appreciated!!

Davi
www.stylus.co.za

 

[Joan Wild]

You should ensure that you have applied all service packs. There is a KB
article about this problem.
http://support.microsoft.com/?id=304548

--
Joan Wild
Microsoft Access MVP

Hi!

Please can someone help me set up a database for multiple seats??

I am able to split the databse, ie. the tables on one PC (the "server" as

such) and then the forms etc on another PC. The problem seems to be with the
VBA project associated with the database - it keeps telling me that it has
lost the network connection, even when the mapped drives allow access to the
folders on the other machines (the "server").

This is what I am doing:
Create database on PC (the "Server") in shared folder on C-drive
Using TOOLS>DATABASE UTILITIES>DATABASE SPLITTER to split the database. I

am placing the "back-end" (the tables) in the same shared folder.

I am then going to a second PC, creting a new blank databse, and using

FILE>GET EXTERNAL DATA>IMPORT to browse to the database on the Server
machine, and import the forms from there.

I am then using FILE>GET EXTERNAL DATA>LINK TABLE to link to the Back end of the databse on the Server.
All of this is fine!
However, when I try to use a button on a form (that obviously has VBA code

attached, the problems start. It works at first - and then it fails, not to
work again.

Do I need to go to the VBA project and create a reference to the VBA

project of the original databese on Server? I have tried this, and it tells
me that there is a conflict as the Project name alrady exists.