Search results

I went through the upsizing process for the tables. The front ends are being run in Access. Would views and stored procedures improve this? I know access really well, but know little about SQL. Perhaps I should learn.

I'm looking to get a new server and am looking for an optimal setup. We are currently on one with dual 1.8 GHz hyperthreaded processors. It seems slow and we can only get 25% usage in the task manager. I suspect that Access isn't capable of using hyperthreaded technology.

I've got a database that is about to blowup with Access' 2GB limit. Just wondering if I should wait for Access 12.

I've got Access Tables that have reached the 2GB limit and I want to do a SQL backend. I've exported my Access table to SQL and linked it up. However, it take 20 times longer to run a query that populates or updates data in SQL than in Access. Anyone have suggestions as to how I can improve this???