SQL server

[broadbean]

My database is in 2003 and the back end is currently being converted to run on SQl server by I.T department. I am using Access 2003 at present with a normal mdb back end. When it is converted to SQL server if i want to modify the back end such as add or modify tables is it easy to do. Is it as simple as modifying a mdb back end.
I guess i will also need to convert the front end to 2010. IS there anything i need to be aware of. I have switchboards written in 2003. Will these convert to 2010 with no problem or do i have to write new switchboards.
I have very few macros. Most of it is done through VBA.

 

[Galaxiom]

Unlikely to be a need to convert the front end. The ODBC connection translates SQL Server to Access.

Macros run in Access. You may be able to improve performance by converting some things to Stored Procedures on SQL Server.

The IT department would need to give you the permissions to add and modify tables. You can make changes by sending SQL ALTER TABLE or CREATE TABLE commands.

Otherwise install SQ Server Management Studio which provides a graphical interface to designing in the server. For much of the functionality it generates the SQL commands which you can run.