Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 18th, 2005, 12:46 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks, I'll try the late binding with the subforms next weekend when I have some time to "tinker", and see if it helps.

And I'll try splitting a copy again and see what happens. (Toward the end of testing before we started populating is when I split it and found the lag and so we just didn't split it. The lag occurred whether the FE was on my local machine or in the same Share folder on the server as the BE. The server lives in the other end of our building...)

Thank you,
Loralee

 
Old April 18th, 2005, 04:25 AM
Authorized User
 
Join Date: Apr 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for all your replies etc. I've got plenty to be going on with. However, I've another problem, I converted all my queries to pass-through. and now I'm having trouble with ODBC. Im sure I'll hit upon the cause of the problem eventually, but I thought whilst I'm scratching my head I'd ask if there is something specific I'm looking for. Everytime I know try to access a table or run a form etc, it pops up asking me to select an ODBC connection. I've set one up to my SQL Server but it doesn't work. I'm not sure what I'm doing wrong!

 
Old April 18th, 2005, 07:24 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

Loralee, I've heard that the FE/BE situation performs better if you stick to the 8.3 DOS naming convention for files. Apparently Jet has to convert Long File names to 8.3 to perform the work. And it calls Windows routines over and over to do that.

Rob, mmcdonal will have the most appropriate answer. But I think that when you open your database, sometime during startup you need to create an ADO connection that stays open until your database is closed. Wish I could help more.
 
Old April 18th, 2005, 07:32 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I use file names for my front ends like this:

"ABC MedSurv Administration Rev 03.mdb"

And I don't have any problems opening them. I think the issue is that there is just a shortcut to the front end file, and all users are opening the same front end file. This will kill your app. Have them each save their own copy of the front end file to their desktops.

The ODBC issue sounds like you did not create a System DSN to connect to your SQL server. Did you do this? If so, then you may still have to log in to the server if you are not using Windows authentication. Perhaps your SQL administrator can help you on this one.

mmcdonal
 
Old April 19th, 2005, 07:21 AM
Authorized User
 
Join Date: Apr 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is really confusing me, When I set my queries to be pass-through, I repeatedly get an DSN selection box appear. I have an ODBC link to my SQL server set up, using trusted connections, and the test button works fine. I have set up my linked tables to use the correct DSN (these work ok when the queries are local). I'm clearly missing something simple, but I can't for the life of me work out where it is!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple SQL Databases for Same Access Front End darrenb Access 0 May 27th, 2008 12:07 AM
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Oracle back-end MS-Access 2003 client front-end Corey Access 2 February 16th, 2007 08:31 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 06:00 AM
using msde and sqlserver with access front-end catkins Pro VB 6 1 April 1st, 2004 04:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.