Der kan ikke åbnes flere databaser

"Der kan ikke åbnes flere databaser."


Normally when youwork with Access you only open one database!

Can you give more information please?

Åben programmet 2 gange og lav databeserne i hver sit vindue ?

Databasen er delt op i en front- og backend. Jeg har kun en database åben, men fejlen kommer når jeg forsøger at køre en forespørgsel.

Databasen har til formål at vise kostprisen på en række produkter. Den 1. forespørgsel slår råvareprisen op for den valgte vare og beregner told og afgift. Den 2. forespørgsel tager udgangspunkt i resultatet fra den 1. forespørgsel og bruger dette i nogle andre simple beregninger med tal fra en række tabeller. Samme princip går igen i 3. - 4. og 5. forespørgsel, men i 5. forespørgsel melder fejlen sig "Der kan ikke åbnes flere databaser".

Jeg har kun et vindue åben, men det virker som om at forespørgelserne åben noget som ikke bliver lukket igen???

any chance of seeing the db(s)?

ekspertenATsanthell.dk

AT=@

Her sendt dig en mail dig, terry.

Will look at the db after lunch

I've had a quick look at your database and also searched around the web after information concerning the error you get. Cannot open any more databases. (Error 3048)

The problem is very likely because you are opening too many connection to JET (Access motor) which is 255. I'm actually surprised that the error occurs but it's difficult to see exactly what makes a connection.

Without a good understanding of your database I can't make any suggestions as to what design changes could be made to get around the problem so instead I'm going to suggest that you look at these links.

One of them suggests that moving the tables to the frontend might solve the problem. That's won't be possible if other users need access to the dB also. So another idea is to copy the results of some of your queries into TEMP tables then make queries on these instead of the queries. 



>>>>>>>>(The TEMP tables can be in the frontend dB)



http://www.access-programmers.co.uk/forums/showthread.php?t=122973
http://www.access-programmers.co.uk/forums/showthread.php?t=65601

I hope one of these can help you with your problem, let me know if I can be of more assistance.

TEMP tables løste problemet.

Mange tak for hjælpen!

selv tak