Hello everybody,
I have a question.
I have a button on a form.
When I press that button, another database should be opened.
I tried this:
Dim dbMyDB As Database
Dim rsMyRS As Recordset
Set dbMyDB = OpenDatabase("C:DocumentenJohnnyStyle_be.mdb")
Set rsMyRS = dbMyDB.OpenRecordset("nslArtikel", dbOpenDynaset)
But it didn't work.
Thank you very much in advance...
Hi There
Im probably being thick, but...
ive just upgraded our sales database from access 97 to access 2002. everything is fine apart from when i try to open the database twice on one machine - it wont allow this. In access 97 this was allowed and i normally had atleast 3 databases (all the same database) open at once.
is there an easy answer??
many Thanks
Neil
I recently found a need to pass a message on to everyone that opened a certain access database. So in I thought the easiest way of doing this would be to use the startup page & macro on the Northwinds Sample Database that comes with access.
However, I kept getting an error because the ok button was pointing the main switchboard which doesnt exist on my database, so I tried deleting the following to see if it would sort the problem: -
' Closes Startup form.
' Used in OnClick property of OK command button on Startup form.
DoCmd.Close
DoCmd.OpenForm ("Main Switchboard")
Now I think I've made things a whole lot worse. When I opne the database I get that first startup form and of course the button doesnt work and everything else is disabled.
I could really do with some help on this one.
Thanks,
Marc.
P.s. Cracking forum guys, if it weren't for places like this people like me would be in a whole world of ****!!
Hi
We have an access database which 3 of us use at work.
All 3 pcs use access runtime to modify the database records
The problem we have is that when you try to open the database with pc3 it just does nothing if pc1 or pc2 has the database open. So we both have to close it and let pc3 open it, then we have to reopen it.
Has anyone else encountered this problem?
The pcs are all configured the same way, are the same model with the same Windows XP Pro image on them.
Help please?
Thanks
Paul
Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.
(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).
I am trying to open up an Access database as read-only from another running Access database. The code I have to open the database currently reads:
"""C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE"" ""f:commonpattyTraining Database.mdb", 1)
How do I change to read only?
Everytime i want to make some changes to my "Testing" Database , always got somebody using it / opening it...
I am trying to create a button , the function of the button is close "Testing" access database who using it or opening it , Example : 5 users included me in a company , when I click a button , 4 of them will received a notification with close "Testing" database message , can do that ?
When I launch my Database file, it would normally run some scripts (I don't actually know what they do, the file is not used by me, only colleagues).
Instead i get this error:
The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events.
When I click 'OK' another error appears:
The expression On Timer you entered as the even property setting produced the following error: Object or class does not support the set of events.
Once i click 'OK' on this error, another error sometimes occurs:
The expression MouseMove you entered as the even property setting produced the following error: Object or class does not support the set of events.
But strangely enough the third error doesn't occur every time i move the mouse.
After these errors have been closed, all i have is my 'form' with a loading bar. I cant access the actual database. Nor can i get into the Visual Basic to try and find the cause. This is happening to multiple clients of mine, and me personally.
Running Windows 7, Server 2008 (64bit), Windows 7 (64bit)
Running Access 2007 and Access 2010.
I have tried changing permissions on the file, this doesn't work.
Using Access 2007, can I return a value for CurrentProject.FileFormat WITHOUT opening the database?
I'm looking for a way to determine the file version of a given Access database without actually "opening" the database in Access (I don't want it to ever be visible at all or in any way).
So to open a database in Access 2007 "without opening it," I'm using:
Code:
Dim db As DAO.Database
Set db = DBEngine.Workspaces(0).OpenDatabase("C:Path-ToFile.accdb")
From here, there are at least two different "version" indicators that can be used, as in this example:
Code:
Debug.Print db.Properties("Version").Value
Debug.Print db.Properties("AccessVersion").Value
Now, if you run this code on an Access 2002/2003 .MDB file, you will get:
Code:
4.0
09.50
If you run this code on an Access 2007 .ACCDB file, you get:
Code:
12.0
09.50
Note two important factors:The db.Properties("Version") seems to be returning the JET version from what I can see in research. This is NOT what I'm after.
The db.Properties("AccessVersion") returns THE SAME VALUE for an '07 ACCDB as it does for an '02-'03 MDB, since Microsoft never updated it, apparently.
Now.... the one way that I have found that ACCURATELY describes the version of a given access database file is to use:
Code:
Debug.Print CurrentProject.FileFormat
...as this will always return, for example, 2.0 for an Access 2.0 .MDB file; 10 for an Access 2002/03 .MDB file; and 12 for and Access 2007 .ACCDB file (and there are others; these are AcFileFormat bitmask constants as described in Access support).
BUT, this CurrentProject object doesn't seem to be available (so far as I can see) when using the "open without opening" method described above.
SO, is there any way to return the FileFormat value without opening the database visibly? (Merely basing it in the extension isn't right either.... that would be easy but not accurate as several formats use MDB.
I'm wondering if there is a way to open an access database (ive started with a microsoft template for an inventory management database) outside of the access environment. I'd like the program to run more like a .exe file rather than a database, but still having the links to and the functionality of the microsoft database
is this possible?
I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
View 6 Replies View RelatedHi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
Thanks in advance..!!
Hello,
I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.
I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.
It's getting frustrating because I've been trying to get this working for 3 hours now with no success.
Here's a little problem I have and wondered if anyone knows a way around it.
I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.
We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.
So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far
Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.
SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.
FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.
Are there any other ways to open a database from within access RT version that will open the access application full screen?
A ex-coworker created a .mde database, but didn't save the .mdb version. The .mde version has been working fine, but today it closed when the end-users tried to open it. It looks like it tried to open the start up form, but it closed. I was able to get into the database and launch the second form, but the start-up is the issue. What could cause the start-up form to keep the database from opening?
Tawain
The problem: I have my database set to open a form on start-up. On opening that form I put in a command for a message box. When I click OK on the message box it tries to open the form again which leads to the same message box. I need to somehow get to the design view on start-up. Any help would be appreciated. Thanks Bob
View 1 Replies View RelatedGood afternoon,
When I'm trying to open a back end database which was previously created is MS Access 97 it gives me the following error;
Cannot update. Database or object is read-only.
I have tried running the "Compact/Repair Function of MS Access 97 and MS Access 2003 to no avail.
I have tried converting the back-end to Access 2003 as well but I still get the same error message. I can link to the database tables from an Access 2003 database fine with no error message!!
Has anyone got any suggestions before I have to take it offline and rebuild the back-end and then copy the data across from the old one?!!!
Hello,
I have a wierd problem I am hoping someone can help me with. Our company database is stored on the server.
The problem is that I can open it when no one is in at and then they can all get in after I open it.
If everyone else is in it, I cannot access it at all until they close out, I open the file and then they can get back in.
Can anyone help me resolve this issue?
Thanks,
Dianne
This is probably very simple and I feel I should know how, but I'm drawing a blank. How can I launch an external database when I click on a button?
Thanks
I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.
I tried that database on 3 different PC's with the same effect.
Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.
Thanks for any help and advice
Josef
I am creating an order processing system and am using 2 tables
OrderHeader
OrderLines
The OrderHeader table includes the number of orderlines on the order.
I want to ensure that when a user completes the order lines they don't up in a line number greater than the number of lines and want to programatically get the number of lines from the order header table.
The form links to the ID of the order header table by using a combo box, which works fine and I can even display the number of order lines in the combo box.
I don't know how to use an ADODB recordset to query the current database.
I can't use something like :
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:filesdatabase.mdb"
which i see all over the place, because I don't know where on the PC this will be running on it will be stored.
There must be a simple way to find out a value from a field within a recordset of the current application database?
Any ideas?
My database is opening much slower than normal just over the past few days. When I run a performance analyzer it is telling me that my database is only being compiled in a partial state. How did this happen and what do I do to fix it??
Thanks...
I am hoping someone out there will be able to help me figure this one out! I have a database I just created which houses approximately data on about 500 physicians/practitioners - from their personal info to information regarding their licensures, liability coverage, and DEA. In order for us to be compliant with administration and government criteria we have to monitor expirations of their license, liability, DEA, and other things. We do this by sending letters/e-mails out 30 days in advance of expiration dates (which is a field in my database). What would really be great if when I bring up my database it would automatically give me a pop-up saying these licensures are expiring in 30 days and send out reminders. I am a rather new user to Access but I do recall a few years ago hearing something about databases that have crystal reports??? I am not sure if that is the same thing or not.
I do have parameter queries set up from date to date but it sure would be impressive if I could get it to do the above. Or maybe another way to do this. Any suggestions????????? CMElady in :confused: distress!!!
Thanks.
Hi,
I tried to search the forums for an answer but I still can't seem to solve the problem.
I receive the "Not a valid bookmark" error message when attempting to open my database. I have tried the compact tool through access and also jetcomp but it just brings up the same error message on access and says "error compacting database" on jetcomp. Can anyone provide a solution to my problem in order that i can either open the database or else retrieve data from it?
Many thanks, any help appreciated
Jon.
I have attached the database in case you have any software which might be of use.