Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 26th, 2008, 01:50 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default Problems while opening form

Hi all,

         Sharing an database through LAN is an problem. I splitted the DB and made the frontend in an user computer everything goes fine till I started using the database more then 2 clients . When i proposed to open in the 3rd system. Some of the forms may not get open and showing the usual error misspelled and or all . what the prob really does it mean...?

awaiting for your positive reply....

bye,
anukagni

Reply With Quote
  #2 (permalink)  
Old March 26th, 2008, 06:48 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

How is the database split? Do you have only tables on a back end on a server? Are the tables linked? How do users access those tables? Are all users mapped to the same drive letter and path for the back end?

What is in the front end?

Is the front end an application that resides on the users' desktops, or is there a single copy of the front end on a network drive that all users open with a shortcut?

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #3 (permalink)  
Old March 27th, 2008, 01:38 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

hi donal,

 database split into frontend and Backdend and i pasted the frontend in the client computer and the problem occur while the database is accessed by more then 2 clients .

 DB contains nearly 12 table and 7 forms and 6 reports ...

 When the DB is accessed by more then 3 clients most of the forms get opened but some 1 or 2 form give error .... " This form is exclusively opened by another user or your not having that much of permission to open the forms".

 Give me an solution as soon as possible ...

thankx donal
bye
anukagni

Reply With Quote
  #4 (permalink)  
Old March 28th, 2008, 07:27 AM
Authorized User
 
Join Date: Mar 2007
Location: Sydney, NSW, Australia.
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

Just a quick note on this, don't know if this will fix your problem, but i have seen this issue arise when different versions and/or service packs are used. I run a split DB with around 30 clients connected using access 2002, even though the db was written in 2003 initially i did have some issues with differing service packs on the users machines. Are your tables linked via drive letter mapping (P:\MYDB\DATA) or unc (\\MYSERVER\MYDB\DATA) and does access manage this link or do you connect via code??

Reply With Quote
  #5 (permalink)  
Old March 31st, 2008, 05:54 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

hi,

      i have connected through drive mapping



Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening 1 form from another jainin_shah9 C# 2005 5 February 18th, 2008 07:31 AM
Form opening with filters ayazhoda Access VBA 2 August 22nd, 2007 03:58 AM
Opening a Form arholly Access 1 January 17th, 2007 11:59 AM
Problems opening MS Access database JayM ASP.NET 2.0 Basics 1 June 5th, 2006 01:59 PM
Closing a form after opening another form rosebushr Access 2 January 7th, 2006 04:34 AM



All times are GMT -4. The time now is 09:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.