Access with Citrix

[shadow9449]

Great, thanks!

SHADOW

 

[shadow9449]

Here's a good list of papers on Jet & ODBC.

This should be the first thing to read: Whitepaper on Jet and ODBC Connectivity.

That paper was for Jet 3.0 but I understand is still valid for 4.0 (and have not been able to find anything more recent anyhow). You also can download that paper and print it out if you want, but can't find that link...

The whitepaper will tell you why/how Jet behaves with external data.

I don't understand anything in the White Paper. (maybe a few phrases here or there). Is there one translated into English?

 

[Banana]

I checked my links and they pointed to English version?

 

[shadow9449]

I checked my links and they pointed to English version?

I was being facetious. I just meant a version that I could understand - perhaps something with more of an introduction.

I do own Alison Balters guide to Access Enterprise development. She writes pretty much for my level of knowledge so perhaps I will check out her sections on ODBC.

Thanks again

SHADOW

 

[Banana]

I have Alison Baltier for Access Development. Interestingly, her information about ODBC is almost dead-wrong as Pat Hartman has blasted the myths such as needing unbound forms and doing everything manually (which is what Alison claims you need to do). After that, this is probably most useful reference book and I always use it when I need a nudge to my memory.

As for the whitepaper, I'm not sure where else to get more introductory as I felt that was *the* introduction. Maybe if you googled?

Now to fix my sarcasm detector...

 

[shadow9449]

I have Alison Baltier for Access Development. Interestingly, her information about ODBC is almost dead-wrong as Pat Hartman has blasted the myths such as needing unbound forms and doing everything manually (which is what Alison claims you need to do). After that, this is probably most useful reference book and I always use it when I need a nudge to my memory.

As for the whitepaper, I'm not sure where else to get more introductory as I felt that was *the* introduction. Maybe if you googled?

Now to fix my sarcasm detector...

I don't remember Alison claiming that you need unbound for everything. The book that I have is the sequel to the one you are referring to, and it focuses on Enterprise Development.

One thing that I'd like to start doing is basing forms on one returned record based on a query rather than on a complete table. I do feel that this could be another reason my program crashes with 25 users. I'd like to see an example of this type of design, including how it uses subforms.

SHADOW

 

[Banana]

It's possible she may have wrote it differently in your book, but I can tell you that for my book, she'd say that you need to use unbound forms once you fetch data from ODBC and there's no way around it (which is hogwash).

You're not the only one; I'd like to see how this can be done. I know that we can use query as a recordsource for form so we don't need to pull everything from the server, but not sure about the most efficient for managing a recordset if you wanted to let your users look at the whole table, but without pulling all records at once. Will have to do more research into this.

 

[shadow9449]

It's possible she may have wrote it differently in your book, but I can tell you that for my book, she'd say that you need to use unbound forms once you fetch data from ODBC and there's no way around it (which is hogwash). .

I'll scan through the book and see if she clearly indicates one way or other.

You're not the only one; I'd like to see how this can be done. I know that we can use query as a recordsource for form so we don't need to pull everything from the server, but not sure about the most efficient for managing a recordset if you wanted to let your users look at the whole table, but without pulling all records at once. Will have to do more research into this.

I was thinking about this and my problem is that when the form opens, there is no recordset defined until the user selects a client from the client table (for example). I am going to experiment by adding a client with an ID of 0 which blank information. When the form opens initially, the recordset is set to just that blank row. When the user selects another client then the recordset changes to the new client. This should work and improve performance.

If you are neither using this technique nor unbound forms, how are you binding your forms on linked tables in your MySQL-based applications?

SHADOW

 

[Rx_]

This thread digressed....
Can we start a new thread with this subject for Citrix?
I feel this is the start of a solution for Citrix that would solve a lot of people's (i.e. *ME*) problems running Access on Citrix.
In years past for a Long-term health care applicaiton, a Citrix guy set up Access 97 so each user logging in automatically created a copy of Access FE for the session.
Dozens of people on dial up did amazing things with out incident.
Today, I am looking for a soluton for Windows Server 2003 running Citrix and Access 2007.

Previous Post
"I wrote a front end version control utility that put the front end in a specific folder on the C drive. That's fine for a PC environment, but caused problems in a Terminal Server/Citrix environment. While users theoretically run their own copy, in reality they don't. I modified my utility to create a subfolder based on the logged in user, so now each person truly has their own copy. The quirky issues I was having went away."

 

[pbaldy]

Can we start a new thread with this subject for Citrix?

Are you waiting for someone else to do it? Why don't you just start a thread?

 

[Rx_]

Thanks! I did start one about an hour ago. Given your background, I hope your can contribute.

Had a talk with my Citrix Admin. And in fact, we are serving up the same file.

He understands the problem now. And needs time to come up with a low maintenance solution.