Hi I'm developing an application to access a mdb database. I will like to use a different db other than the actual db wille developing this application.Instead of changing the db name before creating an .EXE I would like to write a sub to detertmine if the file name is exe or not. How do I do this? TIA
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I am using a devolepment db to text my application and I'm making .exe files as i make improvements to use the live db
Instead of changing the db name before creating an .EXE I would like to write a sub to detertmine if the file name is exe or not to use a live db if its exe or a development db if not an .exe file name. How do I do this? TIA
OK, use this :
EXEName Property
Returns the root name of the executable file (without the extension) that is currently running. If running in the development environment, returns the name of the project.
example :
a$ = app.EXEName
The object placeholder represents anobject expression that evaluates to an object in the Applies To list.
Just make sure your project name and the EXE root name are not exactly the same, and this handles your request.
Hi!
Someting unclear in here now, I'm thinkin about this:
If you have used that Datacontrol and like to redistribute so that user might use anypath when he install's, need to use a variable or constant whit database name.
This might just solve the whole problem in here.
App.path returns path, just sum it.
const DBname = "MyDbname.mdb"
Form_Initialize event
Data1.Databasename = app.path & "\" & Dbname
Matti
"get the application exename without the extension then use the Dir() function to see whether a file with that name and exe exists of course if you already compiled an exe previously this wont be much help but it may be what you want" - y2kwacko
if the file already exist try to open the file with code like
Open App.Path & "\" & App.EXEName & ".EXE" For Input Lock Read As #1
Close #1
if an error occurs you the exe is running, probably means you are running from the exe ;)
Check out this URL at Microsoft:
HOWTO: Check If Program Is Running in the IDE or an EXE File
http://support.microsoft.c
Cheers!
Quote from microsoft page:
"If the project name and the compiled version share the same name, then use the GetModuleFileName API function to determine if your program is running from the IDE or from a compiled version. GetModuleFileName retrieves the full path and filename for the executable file containing the specified module. If the function returns a path to the Visual Basic development environment (IDE) file, VB5.EXE, then the program is running in the IDE. Otherwise, the program is running from an executable file."
Cheers!
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
http://www.experts-exchang
http://www.experts-exchang
Thank you,
Moondancer
Moderator @ Experts Exchange
Business Accounts
Answer for Membership
by: vettrangerPosted on 1999-10-10 at 21:59:58ID: 2115247
Forgive me if I'm missing something, but I usually do this by including a test version of the db in my development directory, and the live version of the db in the normal application directory.
Then just refer to the database with :
dbname$ = app.path & "\yourdata.mdb"
Now if you're running from your development directory, you'll pick up the development db, and when running from the production directory you'll pick up the live file.
It doesn't make any difference whether your testing in the IDE or running the production EXE.