Regular Textbox

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hi I have a regular textbox which captures a date. It appeared to be working
fine, once I uploaded the project to the server there was a problem, as the
field isn't being stored in the database. Any ideas as to why this is
happening?
 
You did not say how you performed the "Upload" from the textbox to the
database.

It is hard to know what you did wrong if I do not know what you did.
 
What I did was split the database to have a front end and backend both on the
server. When the user enters the Followup Date (which is the textbox and a
field in the table) it's not saving the field to the database.
 
The followup date is in the main table which is linked. Does this help? How
can I find out if the followup date is pointing to the front end?
 
Did you change it when you split the database?

Put some way out date like 1/1/2222 and see it it shows in a front end table.
Or
Open the form in design view and reverse engineer it by looking at the
record source. If it is a query then open the query to see where it is
pulling data from.
 
Look at Tools >> Database Utilities >> Linked Table Manager to be sure you
are linking to the back end tables.

BTW, the point of a front end is that each user's workstation has a copy.
You should not be sharing a network copy of the front end.
 
I understand that the front end should be on each computer. But our tech guy
descided it would be better to have it shared on the server so I would only
have to update in one spot instead of going to each computer to upgrade. Now
that it's on the server it seems to be working fine.
 
Good luck. Be sure you have a backup on hand, because if somebody's
computer crashes or shuts down unexpectedly while they have the front end
open there is a good chance the front end will become corrupted. Your tech
guy's decision is, frankly, arbitrary and capricious, and runs contrary to
generally-accepted best practices. Maybe you will get away with it for a
while if there is generally only one user at a time.

There are several options for updating front ends automatically, if you want
to investigate that, either now or after problems develop. Here is one
method, with links to others:
http://www.granite.ab.ca/access/autofe.htm
 
Emma said:
I understand that the front end should be on each computer. But our tech guy
descided it would be better to have it shared on the server so I would only
have to update in one spot instead of going to each computer to upgrade. Now
that it's on the server it seems to be working fine.
Click to expand...

Look at Tony Toews' most excellent "Auto Fe Updater"
http://www.granite.ab.ca/access/autofe.htm

You would upgrade in only one spot. And every time your users go to
start your application, Tony's utility will compare their local copy of
the FE with the version on the server. Whenever the server version is
newer, it will be copied down to replace the user's FE copy.
 
Thanks I'll check it out

Hans Up said:
Look at Tony Toews' most excellent "Auto Fe Updater"
http://www.granite.ab.ca/access/autofe.htm

You would upgrade in only one spot. And every time your users go to
start your application, Tony's utility will compare their local copy of
the FE with the version on the server. Whenever the server version is
newer, it will be copied down to replace the user's FE copy.
Click to expand...
 
Back
Top