I have worked on a FM database locally with no issues. When I log in with a password that has full access I can create, modify all fields, delete records no problem.

After deploying the database(which comprises of 4 separate db files) to the server, NONE of the passwords in the database can modify any fields nor can they create any records including the full access one.

Any help would be greatly appreciated.

Sam

Once it's on the server you are restricted as to what you can do. If there are no other users accessing the file, then you should have access to most of the design functions. However, it is always safer to work on a separate copy of the database not on the server.