Recent content by bthomsin

Hmm i dont know if it uses the same connection. But when i do not have a open link to the database and i make two buttons and make it swap between two diffrent tables on two diffrent backends it takes 2 seconds to load between them. Now i do the same but with a form that has a link to both...

Yes It did work! But i found it harder to do, then just add a small code to the sql. But mabey its just me, and what i understand easier.

Ah i know what you mean, since it has to reopen the backend everytime it is slower. To solve this i added a recordsource to the main form directed to an empty table. This keeps the database connection open but it wont show the all the tables. So for my problem this works.

@isladogs ill do it again and ill PM it

I have done that now, it works. i set the recordsource when opening, this works well without linked tables. It does cost extra work but not that much.

So to get back, i tried your option and it didnt work as i would like to have it work. I would rather not do it with opening a recordset. I just want to set the recordsource. So i tought why not use your idea but then apply it to the recordsource. But how was i going to do this. With a function...

I do not think i need to go to really great length. But i found the option where u can click new query and then get all the info you want a bit to easy. So i am going to do some research on how to link and delink tables and test if that works for me. Thank you for your input

When i call the function i get an error, Invalid argument. dbFailOnError = 128. When i goto the fucntion and hover BErst it says nothing. While the sqlStr contains the string it should. Am i missing something?

Ah sorry didnt get that second part! My bad. So yes that would work for me! Im going to try that as well thank you Micron

It is true if the database is openend exclusive, users could not load it, in excel from the option you say. But everyone has a frontend only for them. Since they can close it and then do the loading in excel it wont work right? But i will keep this option in mind, since i can probably use it in...

This worked for me, but since everyone has there own front-end this alone has no use, or am i mistaken?

I am going to test this now. I dont need it on all my tables just two or 3 so i hope it wont take me to long to test. I will give back a awnser if this helped for my problem in 1 or 2 days. Thank you

So i have checked your file and it works. Even when i remove the password. When i try to see the hidden tables i just see 2. One with ur info and the ribbon one. Do you have thread where u explain how this works?

Thank you all for helping out, I will try the options above and report back what worked for me! Very helpfull and good idea's

I am concerned the company isnt, even is the data is leaked it still isnt a real problem since we do not allow high importance data on the servers at all. I am just trying the best i can do to prevent the easy way to see all the data. I would mind less if it wasnt so easy to get to the data.