Hi,

Is there anyway I can set users access so they can create and maintain tables themselves, I normally set them up with an Access project and do it that way, is there a better way?

Hope you can help.

HI,

Not sure if u r using SQL Server or ACCESS. What I understand is that u r using SQL Server and using ACCESS as front end to give the funtionality u want (To manage tables).

If u r using SQL Server, U can go to the Database Properties.In Permissions tab u can select the Create table check box and make all other X. This is through ENterprice Manager. If u want to T-SQL You can see Grany, Deny Syntax in Books Online. U can control access on the Database. If u want to go much deeper, U can use Security Folder and set the required permissions there itself.

Hope u can find further.

B. Anant