I have a Access 2000 program that I created. I placed the access database 

on the server, and in a shared folder.(This is just a peer-to-peer 

network, 2 wrkstations and a third acting as a server.)

One workstation can use the database just fine, but the second workstation 

has problems with running it. It won't open some forms and sometimes says 

it in exclusive and has problems with public variables.

   These very same forms etc work just fine the first workstation !! Both 

machines have same hardware configuration etc, both machines have Access 

2000 loaded locally. I did not use a switchboard form, nor did I setup any 

security that I am aware of. Can anybody tell me what is going on here ??  

It is really kinda urgent.

Any help would be appreciated,many thanks.

Hi Martha,



We had some problems similar to the ones you had and we traced it to some 

users "admin" (administrative assistants) having insufficient security 

rights on Novell network (did not have modify rights).  Once we gave them 

modify rights to directory housing our database the problems disappeared.  

Why users who have nothing with modifying database needed modify rights is 

beyond me, however, the solution does work for us.  You could have a 

similar problem with your application.  Just a thought, may be an idea to 

check...



John





>>> marthaj@r... 14/08/2001 8:53:28 >>>

I have a Access 2000 program that I created. I placed the access 

database

on the server, and in a shared folder.(This is just a peer-to-peer

network, 2 wrkstations and a third acting as a server.)

One workstation can use the database just fine, but the second workstation



has problems with running it. It won't open some forms and sometimes 

says

it in exclusive and has problems with public variables.

   These very same forms etc work just fine the first workstation !! 

Both

machines have same hardware configuration etc, both machines have 

Access

2000 loaded locally. I did not use a switchboard form, nor did I setup 

any

security that I am aware of. Can anybody tell me what is going on here ?? 



It is really kinda urgent.

Any help would be appreciated,many thanks.

Could be lots of things but the first thing I would check is that the

machine not running well has a FULL Access installation. If, when

installing Access, the Typical option was chosen there may be some

necessary components missing. I would reinstall, choosing the Custom

option, and make sure ALL components are checked as Run From My

Computer.

If this does not work, we can look at some other possibilities.



Richard Lobel

Accessible Data

richard@a... <mailto:richard@a...> 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx

Thank you for your response, I do appreciate it. We just run Win98 on the

the three machines, two acts as workstations and the third as a "File

server".

So , i really don't know what I would check on that system. I do for Novell

and Nt , but just plain old WIn98 ??? any clues ??

again thank you so much,

marthaj@r...

Since you said that it was saying exclusive locks and such, it does strongly

suggest that either one machine is opening the database in Exclusive mode,

or that your Win98 Shares are setup incorrectly.



Do both machines have "Share My Files" ticked in the Network Neigbourhood?



Can both machines open the database individually, or do the errors only

occurr when both try to open them?



Does the faulty machine show any other signs of problems at all?



Have you split the data into a separate MDB file and the forms into another?

(proper way to share a DB)



Just some thoughts.





-----Original Message-----

From: Martha J. Sayers, A.A.B. [mailto:marthaj@r...]

Sent: Tuesday 14 August 2001 05:33

To: Access

Subject: [access] Re: access problems with user





Thank you for your response, I do appreciate it. We just run Win98 on the

the three machines, two acts as workstations and the third as a "File

server".

So , i really don't know what I would check on that system. I do for Novell

and Nt , but just plain old WIn98 ??? any clues ??

again thank you so much,

marthaj@r...

Hi Martha



Even though each PC has Access loaded, they are still trying to run the 

same copy of your database. Your problems are caused by both PC's 

wrestling over the same sets of forms and trying to update variables 

simultaneously.



A simple solution would be to split the database into a data store and 

front end. Place the data store on your server, place a copy of the 

front end the other two PC's, and you'll have far fewer conflicts.



Access has a handy wizard that'll help you through the process. Just 

look in 'Database Utilities' on the 'Tools' menu.



Have fun



-BDS



-----Original Message-----

From:	Martha J Sayers [SMTP:marthaj@r...]

Sent:	13 August 2001 23:53

To:	Access

Subject:	[access] access problems with user



I have a Access 2000 program that I created. I placed the access database

on the server, and in a shared folder.(This is just a peer-to-peer

network, 2 wrkstations and a third acting as a server.)

One workstation can use the database just fine, but the second workstation

has problems with running it. It won't open some forms and sometimes says

it in exclusive and has problems with public variables.

   These very same forms etc work just fine the first workstation !! Both

machines have same hardware configuration etc, both machines have Access 

2000 loaded locally. I did not use a switchboard form, nor did I setup any

security that I am aware of. Can anybody tell me what is going on here ??

It is really kinda urgent.

Any help would be appreciated,many thanks.

Hi Brian,



  Are you referring to the "Database Splitter" ?? How does the coding in my

forms etc ??

  What I don't understand is I converted their 97 projects to 2000 w/o too

much problems (reference problems) and they run fine. But this is a new

project , I didn't use switchboard at all for my project and I have a

snippet of coding that checks to see if any records of that type exist.What

happens, even on my own machine, si that if I don't use a Public var to set

the path, it can not find the database... I don't ever recall having to set

the path before inside of the database.

  thank you very much for responding,

:-)

marthaj@r...

Hi Martha



Even though each PC has Access loaded, they are still trying to run the 

same copy of your database. Your problems are caused by both PC's 

wrestling over the same sets of forms and trying to update variables 

simultaneously.



A simple solution would be to split the database into a data store and 

front end. Place the data store on your server, place a copy of the 

front end the other two PC's, and you'll have far fewer conflicts.



Access has a handy wizard that'll help you through the process. Just 

look in 'Database Utilities' on the 'Tools' menu.



Have fun



-BDS



-----Original Message-----

From:	Martha J Sayers [SMTP:marthaj@r...]

Sent:	13 August 2001 23:53

To:	Access

Subject:	[access] access problems with user



I have a Access 2000 program that I created. I placed the access 

database

on the server, and in a shared folder.(This is just a peer-to-peer

network, 2 wrkstations and a third acting as a server.)

One workstation can use the database just fine, but the second 

workstation

has problems with running it. It won't open some forms and sometimes 

says

it in exclusive and has problems with public variables.

   These very same forms etc work just fine the first workstation !! 

Both

machines have same hardware configuration etc, both machines have Access 



2000 loaded locally. I did not use a switchboard form, nor did I setup 

any

security that I am aware of. Can anybody tell me what is going on here 

?? 

It is really kinda urgent.

Any help would be appreciated,many thanks.

Brian,



  on the verge of being really stupid,  after splitting the db, this would

mean that I would place the mdb  (that contains the forms etc all but

tables) on the user's machine, the db_bend would be on server and then on

the workstation, just create shortcut to the their copy ?? How does it know

where the tables are on the server ??

thank so much, :-)

Hi Martha,



Thats exactly what you need to do!



Once you've run the wizard, you'll notice that the icon by each of your 

table names has changed, and now has a thick black arrow by the side of 

it. This denotes a 'linked table' in Access, and shows that the table is 

physically held in a seperate database file. Behind the scenes 

somewhere, Access holds the filename of that seperate database file. 

Whenever your forms and queries need data, Access will go to the remote 

file and drag it across.



If you ever move the data database, you need to replace the old file and 

path information in the databases on your users machines. Just do the 

following:



Choose 'Database Utilities'|'Linked Table Manager' from the 'Tools' 

menu.

The window you'll see will list all of your linked tables, along with 

the file name of the database they are held in.

Click on 'Select All' and the 'OK'.

If the file name is no longer valid, a standard file box will open.

Find the back end database, select it and click on 'Save'.

Access will check each table, and update the file name.

Finally, click 'Cancel' to return to your database.



Have fun!



Brian



-----Original Message-----

From:	Martha J. Sayers, A.A.B. [SMTP:marthaj@r...]

Sent:	15 August 2001 05:25

To:	Access

Subject:	[access] RE: access problems with user



Brian,



  on the verge of being really stupid,  after splitting the db, this 

would

mean that I would place the mdb  (that contains the forms etc all but

tables) on the user's machine, the db_bend would be on server and then 

on

the workstation, just create shortcut to the their copy ?? How does it 

know

where the tables are on the server ??

thank so much, :-)

Brian



   I would like to thank you for all you help. I haven't worked with Access

for a loooong time and forgotten alot. Once I read your email, I just

laughed at myself cause then I remembered !! Liek riding a bicycle !! Can

you recommend any good books to bring me back up to speed on the Access 2000

?? Also, I would like to pick your head again and this concerns the common

dialog box,which does not show on the toolbar. I know I may have to register

it, but does it only ship with the Professional and Developers edition and

not the "plain vanilla" Access 2000 ??

   I have split the db and etc and it runs well, except for that one

workstation, but in doing so, confirmed something.... Access was never

correctly loaded onto that particular workstation. !! How I know this is

that I could not use the link manager as I needed to on that particular

workstation.

   What a bummer !! So, the fellow who is responsible is going to reload

it...good luck...got me off the hook !!!! So they are going to let me know

how they fare on it all, I offered to do it, but the fellow wouldn't hear

of it.







 And I would like to thank everyone for being so responsive and helpful !!

I hope that I can return the good deeds too

marthaj@r...  :-)  :-)  :-)