Search results for query: *

Hello I have a massive problem with a corrupt Access 97 database. Everytime I try to open it I get the message that Í should repair it. But at repairing the database I get the message "The database can´t be repaired or is no Microsoft Access database". I also tried to compress it but...

Hello I have a big problem with Access databases when two are using/updating one database at the same time. I have seen that more and more datasets are getting corrupt (this means that in the field with the error stands the text #Error#)and the information stored in this field is lost. And then...

Hello I have the problem in MS-Access when I want to sum up fields with format "Time" and the counted values gave a time that goes over 24 hours because than it´s starts counting by zero again to 24. In Excel there is the chance to say that he shouldn´t stop at 24 and count all up but...

Sorry but my problem is not that I can´t read the entry the field itself is limited to a specific digit range. So F2 only gives you the possibility to switch in the field but it doesn´t allow you that the field take more digits.

Hello I have the problem with the header that when I say I want a header it will be displayed on every side. But I don´t want the header on the last side and I don´t know how this works.

Hello My problem in MS Access is when I am in a Macro and I want to make an expression sometimes it happens that the place for the expression is to small. Is there a way to make the space for the expression bigger or is it really limited?

Thanks Dannyocean for this help. What kind of user level security do you mean? The other thing I don´t understand (and that´s why maybe this is server related) is that on one server you can work with more users and on the other you can´t.

I have the problem that when two users are working on the server in the same database after a while the database starts making faultable datasets (in fields you get the #Error# values in) and then it gets corrupt and you have to repair it but before you have to delete the corrupt datasets. So...

Hello I have managed to change table names for a query through a form so the user can enter which table should be shown in a defined query. Now I can change the table but also the criteria that I put in is lost. So I need a way that the tables will change but the criteria will still be there...

Thanks Databaseguy You have solved one thing of the problem. The other problem is now the tables will change but also the criteria that I put in is lost and that´s a problem. So this means I have in all different tables the same fields with the same criteria so the fields that have been filtered...

Hello I have in MS Outlook the issue that I need the tables Calender and Contacts linked together so that they will be one file and then they should be imported into Access. My problem is that when you are exporting once the calender and then the contacts you don´t have a link between the two...

Hello Does anybody know a good way of database security within Access? My problem is that I need a way that tables within a database can´t be opened/exported etc. The user should only get the view with the form. The internal security isn´t the right way to do it because you can only say that you...

Hello Thanks for your help Dreamboat. There is a need for me to make several tables because server performance is to slow in my company. So that means I have a few different tables with the same field names and therefore I need a way that all queries and forms will change the table source so...

I need a way to change the source(table) within a Access query automatically. But this should be done by the user so there must be a way that the user can select which table should get selected via a Form.