passing to client/server architecture

[livia]

Hy,
I have moved the tables from my Access database to a SQL
Server (keeping the queries, the forms, the report and the
cod at each user’s PC).
Problem: To open a report in the new architecture it’s
taking much more time than before, when we hade the
database on an ordinary server from where it was accessed
by the users. I was expecting to have a better
performance, not a slower system.
Thank you,
Livia

 

[Scott McDaniel]

It's not unusual for performance to suffer, in the scenario you describe.
Moving tables to SQL Server is not a magic pill ... you've still got a lot
of work to do re: moving queries to stored procedures, unbinding your forms
(and therefore removing the table links to your SQL Server), etc etc.