My db is on a shared server used by people in 2 different time zones. When they fill out a field on one of the forms, a date and time automatically get entered into two other fields through code I added.
However I would like the time always to be EST. Currently it gets entered as whatever...
I think I am almost there, I'm just now trying to fine tune the db for a multi user environment.
This is what I have currently, please let me know of any suggestions:
"Default record locking" - Edited record
"Open db with record-level locking" checked
Any suggestions for...
Thanks, The help has been great and I know am starting to understand Batch files.
For all users to get the .bat file. Can I just send it in an email and make sure they save it in the same location as defined in the file. Then have them create the shortcut?
Lastly, I couldn't find the option...
If the batch file is created to copy and open the frontend locally, if someone does shut down illegally will/can the db on the shared drive still get corrupt?
Also, I have never used .bat files before. Thank you and I understand what needs to be done but where do I put:
@echo off
mkdir...
I am already working with all the users to make sure they use the db properly, especially shutting down the app.
But like I said, I am going to split it and someone on another post suggested to create a .bat file making a copy of the FrontEnd on their local PC, opening it and connecting to the...
sorry about that,
I want a bat file that runs each time a user opens the program and makes a copy of the Server FrontEnd, places the copy on the users local hard drive, opens that local copy and connects to the server BackEnd.
thanks!
I was having problems with my db on a shared network. It was corrupted and even after being repaired multiple times a day the problme would recur.
I have re built the db and I plan on splitting it this time and creating a bat file. How do you create the bat file? Help with this would be...
I have a fairly simple db on a shared drive. There is only one table, a few forms, and a bunch of reports run off queries that are set up. The table and queries are hidden so the users (about 15) only access the forms and the reports. We keep having problems and get the message:
Database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.