Cannot update date - need quick fix! Urgent!

[mattpearcey]

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? Thank you for your help already.

Matt Pearcey

 

[zodlani]

Hole..

Check if your database Recordset is set to Dynaset.....to be able to update it

 

[scking]

Don't forget to check whether you have the proper permissions for the directory on the server. This is sometimes overlooked in the heat of battle.

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

 

[mattpearcey]

Guys - problem solved! I have had to send the mdw file over to the server for the users to login with. Now all the permissions are set and they can add and edit data.

Thanks for the tips, learned a bit more yet! Thank you for your help already.

Matt Pearcey