Recent content by WhizzkidWallace

Hi, I wonder can I do this....I have a form which views data from a number of tables, and shows a lot of data. I then use simple criteria to narrow my results down and view the data I am looking for...fine....now I want to add a button on the form to produce a report which will only include...

So...I took the plunge and installed XP Pro on my workstation (then spend a whole day on patching, fixing, updating etc etc. I finally got a virgin XP Pro installation with all XP and office patches. Now to test the speed thoery.... I am running Access 2000 on an XP Pro server and...

Maximum ten users... ....and all my forms, reports etc would work ?

Could I use my access front end with a SQL backend, and is it a lot faster than the Jet4.0 engine? ...and is it expensive...

Its not that complex...there are approx 80 tables, very few queries (all done on the fly with SQL in forms and reports), but the relationships are quite complex, and the particular bit of SQL that takes so long involves a lot of opening and closing of recordsets.

Thanks JrJr...already tried that...was slower as I recall.

Thanks Ghudson. I will be trying it tomorrow with an XP machine with 512MB RAM and will post the results. As a bench, when I ran a particularly complex query I timed the following: 1. With file ALL IN ONE, and stored on the server....24 seconds. 2. With file SPLIT Client Local and Backend on...

Actually I mis-stated the specs. The machines are 2.6Ghz Celeron with 256Mb of RAM. I think my best plan is to re-install XP on one of the machines, and try the various configs of client/server location etc to see if something comes up fast enough. Did anyone have any thoughts about the...

Thank you all for your comments. We had actually downgraded our machines to W98 due to a dos based legacy system, which is what has been replaced by the new Access db, so I guess now would be a good time to get XP back on the workstations, and bump the memory up to 512Mb. I can then do the...

They are all 256Mb. When I have local client progs and remote server tables, even the Switchboard takes ages to load when you select an item. Maybe that is down to the Switchboard Items table being on the server? I don't know how to configure for the best.

Hi, I have a growing Access database in a multi-user environment over a 10/100Mb network. The database is all in one file at the moment, on a shared directory of our XP-Pro 'Server', and the workstations have a mapped drive to it and are W98SE machines. All the machines are 1.2Ghz Fujitsu...

Hi, Has anyone seen this one? I have a form on it with a date field, and want to use that date field as a criteria within a 'where' statement for a report. Problem is that on the form, if I extract the date to a variable, it comes off in a dd/mm/yy format, BUT when I want to include that...

This would be the ideal for me.... The user can click into any active field on the form, and then by clicking a single FILTER button, an input box appears, they type something in, and when they press enter or click ok, the form uses that input to filter on the currently selected field. This...

Thanks. I have created buttons on my forms to do most things, and I agree that users should not have access (pardon the pun) to the built in menus etc. The only reason I have not disabled the right click menu is the users need to filter, so I could use some help with the necessary code to put...

Hi there, I am using access a lot these days, and try to use keyboard shortcuts where possible (leave that mouse alone....), so does anyone know a way to get to the FILTER menu when viewing a form using the keyboard...i.e without having to right click on the field and then click in the FILTER...