niall29

Hi again,
I got my Roster Database going on Access 2000 and it worked great but now when it is getting used alot more, by 28 Team leaders ( sometimes up to 5 at a time) it is getting very unstable.
I was advised to put it on SQL 2000 and use VB (VB6) as a front but I am new to this and havent a clue where to start.
I know it is alot to ask but can someone give me step by step instructions how to join the 2 or even tell me where I could find the info on joining the 2.

Thanks in advance

KnooKie

Well....

There is an upsize wizard that will turn your access db into a SQL Server db (i.e. tables and relationships). Although depending on your access db it is not (a la Microsoft) full proof.

VB will take you longer to write and is more code intensive than Access. Which versions of each do you have/plan to get ?

Search this site for more info or microsoft site.