Performance issue

[wes4dbt]

jmc,
Thanks for the reply. They want an Access database, they want to create some of their own reports, export to excel and things like that. Thought maybe dataadapter my have less overhead than tableadapter.

The first thing you need to do is some profiling to work out exactly where the bottleneck is

Not sure how to go about this, have no access to the network except as a user. Is there built in network diagnostic tool in Win7 that I can use from the workstation.

make me rain,

how come the .exe is on network

It's there now for the client to check out how it works, start setting up the db, and provide feedback on what they like and what they want changed/added. The exe could be modified weekly for a while. I don't want to have to go to all the workstations and reinstall every week, also their other office to far away for me to go and reinstalling when I update.

I just never dealt with running an app over an internet network, was hoping someone had experience with this situation.