Search results for query: *

Aha! Now I know what you mean with persistant connection :) Problem is solved by having the keepopen form in de front end Thank you VERY much!

ps I've tried to run the update code from a copy opf the front end, so that ther's only one user loged in the update file. This is not making any difference..

1. Each user opens the same front end file from a server 2. I don't know what you mean with linked form, but they aren't linked to the back end, the back end only keeps the data. The forms are in the front end and the tables are linked to the back end. (There's no local table in the front end)

Hi Majp, I'm connecting via odbc; I linked the foxpro tables in access. The performance is good as long as only one person is logged in in Access.. It looks like access needs a lot of time opening the tables in the backend when other users are logged in.

Hello, I have made an access application which runs a vba update script every 1 minute. The code opens a foxpro database and updates the changed records to the access backend. The updating process is working fine, but the time needed for the updating is much longer when more than one user is...

Hi John, my application is using linked tables, when i close a table it seems that access stays connected to the vfp database..

Hi, I'm dealing with the following problem: I have a Access database which is updating his data from a visual foxpro database every 30 seconds. That work fine till the visual foxpro database is being organized; access cannot retrieve data at that moment. In my error handling access is just...

thats works great! thanks a lot!

Hi, Since the new year has started i am dealing with this problem: to filter records from the last 4 weeks i use this formule: Format(Date();"yyyyww")-1 Or Format(Date();"yyyyww")-2 Or Format(Date();"yyyyww")-3 Or Format(Date();"yyyyww")-4 the problem is in week 2 of the new year this...

Hi, I am building a scoreboard to show te results of the sales group in my company. There are 3 tables: - sales employees - Offertes - sales What i want is a query which calculates the total number of offertes and sales for each sales employee in a period (year/month / week) Is there a way...

That works, Thanks a lot!

That's right, but is there a way to get another language than the system language, when using the format(date()) function?

Hello, I've got an access application which contains a report with the field birth date. The standard language is dutch, so the month of the birthdate is shown in dutch. the report is also translated to a english version, the problem is that the month of the birthdate is shown in dutch, like...

Hi when I run this sql FAQ701-6293: Parsing Delimited Fields i often get the message "invalid procedure call", when i empty all the tables and restart Access the query works again. Does anybody knows why access sometimes comes up with this "invalid procedure" message?

Thanks a lot! This is axactly what I needed. The only remaining question i have left is: Is there a sql solution to group the multiple results for each employee into one field? Like this: Before employeeid experiences 1 A 1 B 1 C After employeeid...

Hello, I have the following question: There are 2 tables: - employees - experiences a employee can have more than one experience, the keys of those experiences are being stored in the field experiences of the table employee like this: 1,2,3,4 What i want is to show the descriptions of each...