SQL server 2005

[Kanagam, Nagarajan]

Dears,

I had created the Access database 2003, that DB have more than of 100 MB,
Hence the DB is running very slow while users access that DB. Therefore SQL
server 2005 installed in my PC and i got the Client Access for SQL server.

But i don't know how to that DB tables transfer to SQL server 2005. Kindly
adviced.

Regards,
Nagarajan.K

 

[PieterLinden via AccessMonster.com]

Dears,

I had created the Access database 2003, that DB have more than of 100 MB,
Hence the DB is running very slow while users access that DB. Therefore SQL
server 2005 installed in my PC and i got the Client Access for SQL server.

But i don't know how to that DB tables transfer to SQL server 2005. Kindly
adviced.

Regards,
Nagarajan.K

Sounds like your database isn't indexed properly. How many people are in
your DB at a time? Split FE/BE?
You can use the Upsizing Wizard to transfer the tables. Did you try it?