UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Error 3734 With Multiple Users, Access 2016    
 
   
JAchord
post Nov 20 2019, 03:13 PM
Post#1



Posts: 147
Joined: 11-July 14



Data base works fine with one user but get error 3734 now if more than one person accessing back-end. Each user has a copy of the front end installed locally with the BE in a network folder. Tried C&R with no luck. This started after a report made access unresponsive and I had to kill the task in task manager. The report was on a development FE that I am working in. Not sure how it effected the back end. This also happens on all installations so it is not just a single computer issue.
Go to the top of the page
 
cheekybuddha
post Nov 20 2019, 03:18 PM
Post#2


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


Just a guess, but you can try:

Get everyone out of their front-ends.

Go to the folder where the back end resides.

If there is a file called 'database name.Madden then delete it.

Try and log people back in.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
JAchord
post Nov 21 2019, 10:04 AM
Post#3



Posts: 147
Joined: 11-July 14



No file by that name. In the folder.
Go to the top of the page
 
cheekybuddha
post Nov 21 2019, 10:05 AM
Post#4


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


Have you done a compact and repair on the backend?

--------------------


Regards,

David Marten
Go to the top of the page
 
JAchord
post Nov 21 2019, 10:24 AM
Post#5



Posts: 147
Joined: 11-July 14



So it is just one of the BE files the other seems to be working normally. This back end has no code, forms, or queries. Just tables and relationships. Could there be a setting that was changed by access?
Go to the top of the page
 
cheekybuddha
post Nov 21 2019, 10:25 AM
Post#6


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


Did you try C&R?

--------------------


Regards,

David Marten
Go to the top of the page
 
JAchord
post Nov 21 2019, 10:45 AM
Post#7



Posts: 147
Joined: 11-July 14



Yes C&R done on the back end. I can use a back up but there is about 200k of data that will be lost. Doesn't seem like much but never know what the data is. I guess i could backup the malfunctioning BE and replace it with a back up and then append the missing records to the new BE.
Go to the top of the page
 
cheekybuddha
post Nov 21 2019, 10:47 AM
Post#8


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


>> I guess i could backup the malfunctioning BE and replace it with a back up and then append the missing records to the new BE. <<

That sounds like a plan. Make sure to work on a copy of the backup!

--------------------


Regards,

David Marten
Go to the top of the page
 
JAchord
post Nov 21 2019, 11:13 AM
Post#9



Posts: 147
Joined: 11-July 14



Well that didn't work either still have the same error. Tried compiling the FE and BE as well. Seems to be an use with just the back end all of the backups are having the same issue even if I just open multiple instances of the BE.
Go to the top of the page
 
cheekybuddha
post Nov 21 2019, 11:15 AM
Post#10


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


Has anything changed in your network?

Do all users have write permission to the folder where the BE resides?

Check from a computer that can't connect whether you can create a simple text file in that folder.

--------------------


Regards,

David Marten
Go to the top of the page
 
JAchord
post Nov 21 2019, 11:18 AM
Post#11



Posts: 147
Joined: 11-July 14



Well had to go back to a backup made on the 15th. 300K of data lost. cryhard.gif Hopefully importing back in does not cause it to break again.
Go to the top of the page
 
cheekybuddha
post Nov 21 2019, 11:21 AM
Post#12


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


doh.gif Good luck! thumbup.gif

--------------------


Regards,

David Marten
Go to the top of the page
 
JAchord
post Nov 25 2019, 03:32 PM
Post#13



Posts: 147
Joined: 11-July 14



Thanks for the help seems to be all good now. Need to make the back ups more often though.
Go to the top of the page
 
cheekybuddha
post Nov 25 2019, 04:26 PM
Post#14


UtterAccess Moderator
Posts: 11,904
Joined: 6-December 03
From: Telegraph Hill


Isn't hinsdight a wonderful thing? ohyeah.gif

Glad you're sorted now.

thumbup.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    10th December 2019 - 05:00 PM