Tabel i hukommelse der kan redigeres

I've never had the need to create a table in memory so cant be sure if its possible or not.

You can create a recordset which is theoretically in memory and add/edit (I think) records.

May  ask why I needs to be in memory? Its only going to be available for the user at creates it, not other users. So you could just as well create a table and then drop it when work is complete.

What I need is to do a sql search in a table which is then displayed to the user. For each item there must be a checkbox which the user can check or uncheck, how do I get this checkbox shown? There is no field in the table that the checkbox can be bound to.
Here I thought I could use a temporary table.

Wouldn't it be easiest just to add a checkbox to the table?

I'm sure we can find another solution but not as easy having it in the table.

That would not work since there are multiple users, if they check and uncheck at the same time it would mess things up for each user

Is it not possible to build a temporary table and give it a random name and fill it with data using a SQL like

SELECT *, false AS checkbox FROM tblMyTable

That SQL works fine is I just run it but then I cant edit the checkbox field.

When the user is done with the table then I can delete it again.

Not knowing your full requirements its not easy to give the perfect solution. But I'm assuming you have a dB which allows all users to edit data in a table at the same time, and you want a way of allowing each user to edit the checkbox without interfering with other users.

You dont say if you have a front end and a back end set-up but if I assume that you do then it would be simple to create a temp table in the front end and copy required data into this. Then users could do whatever they wanted with it and delete when finished.

If you dont then whatever way you create objects which will allow users to edit the data is going to affect other users.

The "Back-End" database just contains the tables
The "Front-End" database contains the application objects (everything except the tables) and links to the tables in the back-end database

But it also allows you to create object in the front-end which will only be available for a single user.

I found this page on how to make in-memory recordset
http://www.databasejournal.com/features/msaccess/article.php/3846361/Create-In-Memory-ADO-Recordsets.htm

it works fine but I think I am going to use a temp table in the front-end database as you suggested, and then run a query like this:
SQL = "insert into rds_temp (firstname, lastname, email) " & _
          "Select firstname, lastname,email from employees where lastname like 'madsen'"

Smid en svar

for some reason I'm not able to see that link right now :-(

Good you found something you could use though

Drop an answer :-)

Oops :-)