Search results

We are mixing terms again. The network that the FE is located on MIGHT be NAS, but is not web-enabled. The network that the BE is located on is web-enabled. I don't know if it is NAS, but nobody accesses it from the internet. I asked someone in IT if the network the backend is on is...

Okay - I don't know even where the drive is - and I'm not sure who does, much less how it is configured. I can check. May be able to get the sniffer set up. How would I set that up? I'm thinking if I created a "test/dummy" BE on the network drive and had new copies of the FE to access that...

So the BE is okay to be on a web-enabled network drive if the drive supports SMB protocol, correct? How would I verify whether it does or does not support that?

Is there a way I can test it? It doesn't SEEM to be working as you describe. For example - we have multiple users in the database. I haven't heard of anyone saying their changes weren't saved b/c someone else updated a record in the same table. Also, someone can open a record and save it and...

Let me explain the setup in as much detail as I can. I don't know if we are using NAS Drives. @The_Doc_Man mentioned them and that seems correct. We have two classes of users. One group uses Citrix. The other group uses local resources and uses VPN (Pulse Secure/Ivanti) when working from home...

See Reply #210. I'm not sure if it is web-enabled or not. I tried to access it from the address bar in Google Chrome and was not able to do so. However, I was able to access the folder that the BACKEND of the database is located in through Google Chrome. Is that an issue? Remaining questions...

I'm feeling a bit better, but still confused. Essentially, @The_Doc_Man is saying what I have setup is horrible for network traffic and @Pat Hartman is saying everything is normal. No two users are opening the same copy of the FE. It is not being shared. #204 wasn't clear to me that first...

We are getting away from my central question - i.e.: I'm still not clear if that (having the FE separate from the Citrix server) causes an Issue. I'm not tracking here. Locally, we are using C:\Users\<username>\Desktop. I can get to that. I have other folders named C:\Users\<otherusername>\...

If I went with your implementation. And that is not happening. The front end won't open unless it is in a directory that only that user has Access to. The central question at this point is whether under Citrix there is an issue with the FE being on one server folder and the BE being on a...

We handle things a bit differently. I've seen implementations where the FE is copied from the master directory to a local directory and then opened. What we do if have a version number in a table in the backend. If that number is greater than the number in the local table in the front end, than...

I'm good, but I'll reply to clarify. I don't think that presents an issue. All of the Citrix users have the ability to launch MS Access (along with MS Word, MS Excel, and various other apps.) The issue is getting them a unique folder that they alone have write access to. I know that CAN be...

@The_Doc_Man - I'll wait for the next reply, but I'm confused on part of #199.

I'm not familiar with this. Is there more to it than ensuring the FE is installed on the Citrix server and each users runs their own copy of it? Could the front end being on one network folder and FE being on a different network folder (neither part of the Citrix Server that is called both of...

This is not the issue and is resolved - although it wouldn't have been if you had not commented - much appreciated. See Reply #192. The FE was on OneDrive on Monday night and Tuesday morning, but the user isn't actively working in the database yet, and the file duplication happened apparently...

I wrote this yesterday prior to Reply #194, but it didn't post ... @gemma-the-husky In each table, there is a field named PrimaryKey. It is set as an Autonumber field, and it also has the "Set As Primary Key" property and the little Key icon by it in design mode. (Or it did in last night's...

@The_Doc_Man - Solved the OneDrive issue. The new users Desktop folder is on OneDrive but I was able to create a C:\Users\username\Desktop folder and put the FE there and put a shortcut on the OneDrive Desktop to open the FE. @Uncle Gizmo - There are only 8 users, but each user has there own...

@The_Doc_Man - To clarify: the BE is staying on the share drive (Network, not OneDrive). The FE is either local or on OneDrive. Is that still an issue? I can potentially put the FE on a local folder and have a shortcut on OneDrive to open the FE. Would that work and would that be...

Found a new wrinkle and now I am highly confused. The first issue that I found with a field not having a defined primary Key and having duplicated records occurred on 17-Jun. I deleted or restored the records on 17-Jun and verified each table had a defined primary key. The duplication I found...

@ GPGeorge - That helps. I do run a nightly C&R on the backend. So it is POSSIBLE the BE was corrupted, the C&R removed the PK and then a later corruption/error allowed the duplicated record. @jdraw - I have a procedure to check for unknown records. I don't have a procedure to confirm that the...

Seems to be what is happening and happening repeatedly, and seems to be what the answers.microsoft.com thread is describing also. I don't think so. I could figure out how to write DDL code (I think) to change it, but I haven't done so, and I don't think anyone else with access to the db knows...