virtual table?

[ingridvg70]

Hi all,

I have a resource planning tool in Access, and I'm trying to make a recurring appointment option; e.g. plan the weekly meeting on friday. The application has to check if there are prior appointments for any of the recurring dates

I figure that I need a temporary table, where I can store the dates so I can link it to the planningtable.

Problem is, that the application runs on a virtual desktop, and the front end part is shared between users. Even if I use a tblTemp in the front end, there is a chance that two people are using it at the same time.

Is there a way to make a virtual table in VBA, that is confined to the user who calls the code?

Thanks in advance,
Ingrid

 

[vbaInet]

With regards recurring events, here's a link a lot of people use:

http://allenbrowne.com/apprecur.html

As for temp tables linked to just the user, you would have to create a local table. That is, create one table in the Front End. The Jet Engine isn't as sophisticated as SQL Server or Oracle that allows you to create virtualised tables and views.

 

[ingridvg70]

OK, thanks. Trouble is, that applications are made available for groups of users by way of a common link, so the front end is used by more than one user. I will have to make named temporary tables then.

Ingrid

 

[speakers_86]

You should not be sharing the front end. Each end user should have their own copy.

 

[nanscombe]

Since "virtual desktop" is mentioned, I suspect this may be a Citrix type installation (working with a remote copy of the database) rather than a LAN based one.


OP: You could have a Username field in the temporary table and query the records based on that, so people would only see their own records.

 

[Insane_ai]

I am working through a similar issue where I need to use a temporary table to properly join information. I am thinking of using a recordset in memory to accomplish this. Has any tested that method? What should I be planning for to avoid possible problems?