Access vs. SQL Server

Dear experts,

I am currently using Microsoft Access and the current size of my database is about 250Mb. I need to incorporate an additional set of data which could potentially double the size of the database or more. I am considering whether to switch to a more professional database manager like SQL. I have the following questions:

1. How much data can Access realistically handle before performance starts to degrade materially?

2. What is the next best option for database upgrade in Windows environment (SQL server, etc)?

3. I am currently accessing my database via VBA (ActiveX Data Objects) within Excel application. If I switch to SQL, would I need to rewrite my code?

4. How difficult is it to convert the database from Access to SQL server format?

Thanks for your help. Any additional insights on pros and cons of Access vs. converting to SQL server would be greatly appreciated.

CWF

For a quick MS response: http://www.microsoft.com/sql/solutions/ssm/access/compare-access.mspx

Other than that, i did a quick msn search for "access versus sql server" and found many articles. Look through them and post any other questions you have here.

|||Thanks. This is very helpful.

access permission

it is proberly not right place to post here, but i found there are many experts here. I learn a lot from here. I would like to ask.
I have a new window 2000 server.
my supervisor let me set Domain Admins to both of us, how to set up?
The domain admins is full control, also we have admin for server, what is different? Is that Domain admin has been add in the server, and just let me add two users to be a domanin admins? how to do that? Thanks for your help.Add Domain Admins group to local Administrators group.|||be honest, i don't know where is the domain admins and administrator, where is it? Also i create a share folder, that only the domain admins has full control, others are read only. Can you give me more detail? Thanks.|||I am honest, - right-mouse click on My Computer, select Manage, expand Local Users and Groups, go to Groups, double-click on Administrators, click on Add, type <domain>\Domain Admins, click OK.|||haha, you are very nice, I got it and add domain admins in the group, then how can i set my supervisor and i to be domain admins.|||rdjabarov, after i have domain admins, that means this is a group, i need to add two people(me and supervisor) to this group, is that correct? How can i add the two people? Another thing is that after i add the supervisor, he can have full control on his local machine? such as he can access file, modify and delete the file, is that mean, he also can log on the server using "Domain admins" as user name? Thanks for your help.