473,327 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Access 2003 backend db path display

On apps I support for some charitable and non-profits I use a form which
displays application version history info, along with a few system setup
parameters.

One of these setup bits is the backend db filename based on the
technique mentioned on Allen Browne's Tips for Serious Users page
(Thanks Allen for this ... and the calendar and much more !)

="Backend: " &
Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]("Donors").[Connect],11)

At a client who has migrated to Office 2003 I noticed that the textbox
displays a Value# error. (iirc) While this isn't something the client
even sees in most cases, of course I'd like to fix it.

I don't have A2003 to test this locally. Can anyone suggest where this
is likely to fail? I don't know if there could be a library reference
issue on the client's computer - the rest of the application has worked
fine since the client upgraded, several months ago. The app is authored
in A2002 and saved in A2000 format.
TIA

--
F L
-
May 18 '06 #1
2 1735
Frank L <Le***************@sympatico.ca> wrote in
news:en*******************@news20.bellglobal.com:
One of these setup bits is the backend db filename based on the
technique mentioned on Allen Browne's Tips for Serious Users page
(Thanks Allen for this ... and the calendar and much more !)

="Backend: " &
Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]("Donors")
.[Connect],11)

At a client who has migrated to Office 2003 I noticed that the
textbox displays a Value# error. (iirc) While this isn't
something the client even sees in most cases, of course I'd like
to fix it.


I would replace Allen's controlsource with:

="Backend: " & Mid([CurrentDB].[TableDefs]("Donors").[Connect],11)

I don't know if this will fix the problem, but I see no reason to go
through DBEngine(0)(0) to get to it when CurrentDB will always
return exactly that (whereas DBEngine(0)(0) in certain very rare
circumstances (i.e., after a wizard has run) may return something
other than the database currently opened in the Access UI).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 18 '06 #2
David W. Fenton wrote:

I would replace Allen's controlsource with:

="Backend: " & Mid([CurrentDB].[TableDefs]("Donors").[Connect],11)

I don't know if this will fix the problem, but I see no reason to go
through DBEngine(0)(0) to get to it when CurrentDB will always
return exactly that (whereas DBEngine(0)(0) in certain very rare
circumstances (i.e., after a wizard has run) may return something
other than the database currently opened in the Access UI).

I'll apply this simplification and hopefully get to further debugging on
next client visit ... thanks.
--
F L
-
May 20 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
3
by: Marc B | last post by:
Hello all, In a split database environment, is it safe to still use the following?: set db = CurrentDB or must one be more explicit and indicate the path and name of the database being ...
17
by: Jon Ole Hedne | last post by:
I have worked on this problem some hours now (read many-many...), and I can't solve it: In vba-code I create a table with Connection.Execute, and add some data to it. This table is saved in the...
7
by: JMCN | last post by:
Is this possible to have the 97 users with 97 front end, 2000 users with 2000 front end, 2002 users with 2002 front end, and 2003 users with 2003 front end all linked up to an access 97 backend? ...
13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
3
by: Bob Dydd | last post by:
Hi Everybody I have an Access 2000 db with a setup for inserting images in records. I am using the image path only with the actual images stored elswhere on the hard disc. This works perfectly...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
7
by: needin4mation | last post by:
Hi, I have an Access 2002 - 2003 database. I am using Access 2003. Whenever I link an image all it shows is the filename. Not the image. Other versions of Access can link the image just fine. ...
7
by: bhavin30 | last post by:
Is there a way to obtain user information (using LOGON_USER server variables) when you have set up the security to Anonymous Access? I have tried setting the security to both Anonymous + Window...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.