I have to change the Power/Energy Saver/Energy Saver Mode BIOS setting from either "Minimal" or "Advanced" to "Disable". I need to do this on Compaq Deskpro workstations that are running NT 4.0. I know I can do it manually, but I have too many to have to go to...
I am upsizing my Access 2000 database to an Access 2000 Project and am unable to to bring my export specifications into the project. Also, the project won't allow me to save new import/export specifications. Any ideas?<br>Thanks,<br>Arnold
I have a SELECT statement in Access 2000 that contains the following:<br>Format([UnitPrice]/[Weight],'$0.0000') AS expr1<br><br>I am looking for an equivalent in SQL Server, but have yet to find it. The SELECT statement is the source for a ListBox in an Access 2000 Project.<br><br>Any...
I have a SELECT statement in Access 2000 that contains the following:<br>Format([UnitPrice]/[Weight],'$0.0000') AS expr1<br><br>I am looking for an equivalent in SQL Server, but have yet to find it. The SELECT statement is the source for a ListBox in an Access 2000 Project.<br><br>Any...
I have an Access 97 database that I am upgrading to utilize a SQL Server 7.0 backend and an Access 2000 front end. First, I am upsizing the Access 97 database to Access 2000 and then running the Upsizing Wizard to create the Access 2000 database with linked tables to the SQL Server. When I...
I have an Access 97 database that I am upgrading to utilize a SQL Server 7.0 backend and an Access 2000 front end. First, I am upsizing the Access 97 database to Access 2000 and then running the Upsizing Wizard to create the Access 2000 database with linked tables to the SQL Server. When I...
I have an Access 97 database that is made up of a front end and a back end, both in Access 97. Just the tables are in the backend. I then link the front end to the backend with linked tables. Next I make an MDE file out of the front end. I have about 10-15 concurrent users at any one time...
I am trying to convert an Access 2000 database over to SQL 7.0, but I am having some problems. I ran the upsizing wizard to upsize the table structure and link the database tables to the sql 7.0 tables. That worked fine. I then imported all the data into the SQL 7.0 backend. Again no...
I am trying to convert an Access 2000 database over to SQL 7.0, but I am having some problems. I ran the upsizing wizard to upsize the table structure and link the database tables to the sql 7.0 tables. That worked fine. I then imported all the data into the SQL 7.0 backend. Again no...
I have an Access database that works great on one computer, but I get an "ActiveX Component can't create object" error and a "Run-time error '429'" error when I try and run it on a second computer. When I debug the code, the error occurs on "Set dbcurrent = CurrentDb". Am I missing an ActiveX...
I am one of the developers for an Access 97 database that is used in a small business. The database we are using has continued to grow, as has the number of users. We currently have about 15 users in the system at any one time. The database is critical to the day-to-day operations of the...
Is it possible to save a previewed report in Access as a file of some sort? My users have a fax program on there computer and they need the ability to fax an Access report from their computer.
I have an Access 97 database that is on a LAN with about 15 different users. The database runs without problems when it is run on just one local computer, but when it is run on the network with multiple users all at the same time, I often get a "Not a valid bookmark" error. This usually occurs...
While trying to update a field in my table by using a recordset, I got an error that stated: "Reserved Error (-1601) There is no message for this error" I repaired the database and it fixed the problem, but I am wondering if anyone knows what could have caused the error.
While in my access database, I want to click on a button that opens another access database. I want the other database to open like it would if I double clicked on it in Windows Explorer. What code do I need to put behind the button?
While in visual basic code, I want to do the equivalent of copying another database and pasting it with a different name. I don't want to make a replica of it. I do know that I could create a new database with the NewCurrentDatabase Object and then import everything that I want, but I was...
I am trying to write an SQL statement that will update a table in one MS Access 97 database with data from a table in another MS Access 97 database. The tables have the same structure, design, and format. I want to basically do an Update query, but the table being updated is in a separate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.