Open several databases at once

[XXD]

Question: Using Access with Citrix

Hello acces experts.

I have a database created in MS Access 2007. I have put the database as a mdb-file in a server to make many computers able to use the database.
The problem is that, the database can only be open at once, in one computer.
I'm able to connect to the server and see the database, but when I click on it twice to open it again, nothing happens. Not even an error message.
Does anyone know how I can get several computer to be able to work on the databse at the same time?

Thanks in advance
XXD

 

[boblarson]

Does anyone know how I can get several computer to be able to work on the databse at the same time?

The database should be SPLIT (Frontend/Backend) with the BACKEND (tables only) on the File Server. The Linked FRONTEND should be on EACH user's computer.

See here for more about splitting:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[jsv2002]

If your trying to do what I think your trying to do have a look here:

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

Good luck John

EDIT:

Or do what Bob says it probably makes more sense

 

[XXD]

The database should be SPLIT (Frontend/Backend) with the BACKEND (tables only) on the File Server. The Linked FRONTEND should be on EACH user's computer.

See here for more about splitting:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

The thing is that I connect through the internet into an account in the server and that can be done by so many different computers. That solution would be a little difficult.

 

[boblarson]

The thing is that I connect through the internet into an account in the server

What do you mean exactly? Are you doing RDP? Terminal Services? Citrix?

 

[XXD]

What do you mean exactly? Are you doing RDP? Terminal Services? Citrix?

Yes, It is MetaFrame(Citrix) we'r working with.

 

[boblarson]

Yes, It is MetaFrame(Citrix) we'r working with.

Then you need to read this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=127874

 

[XXD]

Thank you for the link. It's a little messy to find out exactly what I need and I could not find out how to make multiply users to be able to use the database at the same time, since the thread contained more advantages and disadvantages on using Citrix.
(I need to go now, but look forward to see replies tomorrow)

Thanks in advance
XXD

 

[XXD]

Hi, Is it another way than splitting the database into tables and forms etc.?

 

[XXD]

No one knows how I can solve this?

 

[jsv2002]

If your using access the above are your only options over a network to be honest... having not used a citrix server system I cannot advise on this but depending on how many users will be connected you may even need to upscale to SQL.

I think what you are trying to accomplish may be beyond an average access user/creators ability and should seek an experts help on site.

 

[boblarson]

No one knows how I can solve this?

Repost the question with the title: "Question: Using Access with Citrix"

and you might get a better response. (I've not used it that way myself, but there are those here who have but your initial question is a bit misleading).

 

[XXD]

Repost the question with the title: "Question: Using Access with Citrix"

and you might get a better response. (I've not used it that way myself, but there are those here who have but your initial question is a bit misleading).

haha, ok. Thank you for the tip Bob.

 

[XXD]

Repost the question with the title: "Question: Using Access with Citrix"

and you might get a better response. (I've not used it that way myself, but there are those here who have but your initial question is a bit misleading).

Can't change the name for the whole thread only my posts. Can a moderator please change the title to "Question: Using Access with Citrix"

 

[boblarson]

Can't change the name for the whole thread only my posts. Can a moderator please change the title to "Question: Using Access with Citrix"

I would just post a new thread. It is okay in this case due to the nature of things.

 

[Matoco1]

having just upgraded to 2007 myself check your access settings there is a tab to select how you want to open the file i.e. 'open exclusive' this could be part of the problem

 

[Simon_MT]

This is the second posting regarding Citrix and the more I hear about Citrix I'm glad I went for a Terminal Server, it just a much robust solution. There is no remote access to the data just locally to the Terminal Server. All the data calls are local. Fast, piece of cake for Access, no re-programming and no delays. I've even seen users vacate interrupt active Terminal Server session only to re-join at another desk.

Up-speed was issue but that only because we were dealing with about 17,000 (50-100KB) image files.

Simon