Recent content by kilt

Hi Barry - try Kb 871260. Kilt

Hi Rednik - could be one of many problems. here's a link that'll help you out http://v4.windowsupdate.microsoft.com/troubleshoot/ Good Luck Kilt

Ok - to simplify, I have a report like so: RefNo Name Paid Method 1 X £50 Cheque 2 3 4 5 6 7 8 9 10 11 12 etc I would like to have: RefNo Name Paid Method 1 x £50 Cheque 2 3 4 5 6 7 8 9 10 Space or line here (after every 10 records) 11 12 13...

Hi all, I have a simple report that has 4 fields based from a query. The 4 fields are RefNo, Name, Amount paid & Payment method. This report is printed on a daily basis & is grouped simply by Name ascending. On a daily basis we have a report that shows all payments from Names A-->Z &...

Hi Bob, I've taken both tables & did what you said. the data field Sort is the added autonumber Here are the last entries from the corrupt table Sort Tref Month Amount Sent 26480 12102 01/05/2004 £0.00 No 26481 12103 01/03/2004 £0.00 Yes 26482 12103 01/04/2004 -£7.50 No...

Hi Bob, I did try that last 40 method but it didn't work with my table. Of the 4 fields in the table, 2 constitute the Primary key with one of them being related in a one to many relationship with the main table of our database, which is an autonumber. That number is pulled out of the...

Bob, I appreciate your help, unfortunately I'm not too hot on my SQL. I understand what the code is trying to achieve but when I write & try to save it I get an error of: Syntax error (missing operator) in query expression "(B.ID) IsNull". I've also noticed that some of the data fields in...

Hi everyone, One of the tables in our database corrupted. It contains 4 data fields & has 40 records in it that have been added since our last backup. I would like to find the records that aren't in our backup so I can manually/ update the uncorrupted table. I know this can be done...

Thanks for the replies - technome i think you're right. We only have an 0.5 Mb ADSL connection with Upstream of 128Kb/s. ( Unfortunately we can't upgrade our connection due to location ) I will add more RAM & hopefully this might increase the Remote Users experience. Cheers, Kilt

Hi Romh - I had the same problem as you (& stll do). i couldn't open our access database over VPN so i started using TS. The database can now be opened but some of the larger queries make the database unstable & we have a 1.8 Gb Pentium 4 CPU & 1.5 Gb RAM + this is when there is only one user...

Hi everyone, My boss & 2 others need to work on our access database, remotely. I've got them connected via VPN & TS but they're complaining that it's very slow when querying etc. I know the speed is going to be less than on the LAN but does anyone know of any way to speed up the...

Thanks for the reply. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas? Thanks, Kilt

Thanks for the replies guys. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas? Thanks, Kilt

Hi everyone, I set up a VPN to Remote Access into our Access XP database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article to support the error...

Hi everyone, One of the main reasons to set up our VPN was for Remote Access into our database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article...