Cannot update date - need quick fix! Urgent!
Cannot update date - need quick fix! Urgent!
(OP)
OK - i have made up a database, locally on my workstation. I have tested all things, such as splitting it, so that i have a frint end running off the database (how i want it to work when i go live). And, all things work fine, no problems!
Ok, now i have put it on our server, and on there created a new database linked to this one, andmade this as the front end app. Everything works ok, apart from the data is NOT UPDATABLE. Why is this? I have a read only option on the switchboard, but im sure that is nothing to do with it. Why have i done wrong when i put it on the server?
I have looked at the Back end, and there appears not to be showing the Msys tables. IS this the source of the problem? IOf so, how do i get them to appear again? As i must have done that when i was jumping around the design phase and not payed enough attention.
Please help ASAP someone?
Ok, now i have put it on our server, and on there created a new database linked to this one, andmade this as the front end app. Everything works ok, apart from the data is NOT UPDATABLE. Why is this? I have a read only option on the switchboard, but im sure that is nothing to do with it. Why have i done wrong when i put it on the server?
I have looked at the Back end, and there appears not to be showing the Msys tables. IS this the source of the problem? IOf so, how do i get them to appear again? As i must have done that when i was jumping around the design phase and not payed enough attention.
Please help ASAP someone?
Thank you for your help already.
Matt Pearcey
RE: Cannot update date - need quick fix! Urgent!
Check if your database Recordset is set to Dynaset.....to be able to update it
RE: Cannot update date - need quick fix! Urgent!
Assuming:
No user security that may have permissions not set.
No use of queries which would create a non-updatable recordset.
Steve King
Growth follows a healthy professional curiosity
RE: Cannot update date - need quick fix! Urgent!
Thanks for the tips, learned a bit more yet!
Thank you for your help already.
Matt Pearcey