Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi, I created a database using Access 2K, and split it into one BE on the server and multiple FEs (one on each user's desktop). Some of my users have Access ver2000 installed on their desktops, and others have ver2003. I'm unfamiliar with ver2003 and haven't used it at all. To top it, the users with ver2003 are in a remote office, and I have to provide the m support over the phone. Are there any known issues with this? I'm hoping that ver2003 is backward compatible, and users should be able to open the FE using either of the versions, and multiple users using different versions should be able to ente r data at the same time. If you are aware of any snags, will appreciate it if you can let me know. Thanks. -Amit PS. Using Windows XP and Windows 2000
Post Follow-up to this messageAFAIK, Access 2003 should be able to run an A2000 db just fine. in fact, the default file format for new databases built in Access 2003 *is* A2000. hth "Amit" <Amit@discussions.microsoft.com> wrote in message news:12183AA3-76F8-4B3A-B924- 7194FC73EDFC@microso ft.com... > Hi, > > I created a database using Access 2K, and split it into one BE on the server > and multiple FEs (one on each user's desktop). > > Some of my users have Access ver2000 installed on their desktops, and others > have ver2003. I'm unfamiliar with ver2003 and haven't used it at all. To top > it, the users with ver2003 are in a remote office, and I have to provide them > support over the phone. > > Are there any known issues with this? I'm hoping that ver2003 is backward > compatible, and users should be able to open the FE using either of the > versions, and multiple users using different versions should be able to enter > data at the same time. > > If you are aware of any snags, will appreciate it if you can let me know. > Thanks. > > -Amit > > PS. Using Windows XP and Windows 2000
Post Follow-up to this messageAccess2003 can use database in A2000 file format without any problem. However, accessing BE using WAN may be unacceptably slow (WAN is generally 1 MBps or less while LAN is generally 100 MBps) and there is an increased risk of database corruption due to the more frequent drop-outs on WAN . -- HTH Van T. Dinh MVP (Access) "Amit" <Amit@discussions.microsoft.com> wrote in message news:12183AA3-76F8-4B3A-B924- 7194FC73EDFC@microso ft.com... > Hi, > > I created a database using Access 2K, and split it into one BE on the > server > and multiple FEs (one on each user's desktop). > > Some of my users have Access ver2000 installed on their desktops, and > others > have ver2003. I'm unfamiliar with ver2003 and haven't used it at all. To > top > it, the users with ver2003 are in a remote office, and I have to provide > them > support over the phone. > > Are there any known issues with this? I'm hoping that ver2003 is backward > compatible, and users should be able to open the FE using either of the > versions, and multiple users using different versions should be able to > enter > data at the same time. > > If you are aware of any snags, will appreciate it if you can let me know. > Thanks. > > -Amit > > PS. Using Windows XP and Windows 2000
Post Follow-up to this messageHi Tina and Van, Thanks for your prompt response. Yes, we have been experiencing slow response at the remote office, and I'll keep an eye on it re:data corruption . Cheers, -Amit "Van T. Dinh" wrote: > Access2003 can use database in A2000 file format without any problem. > However, accessing BE using WAN may be unacceptably slow (WAN is generally 1 > MBps or less while LAN is generally 100 MBps) and there is an increased ri sk > of database corruption due to the more frequent drop-outs on WAN . > > -- > HTH > Van T. Dinh > MVP (Access) > > > > > "Amit" <Amit@discussions.microsoft.com> wrote in message > news:12183AA3-76F8-4B3A-B924- 7194FC73EDFC@microso ft.com... > > >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread