Database Engine Tuning Advisor and autocomplete
Hello there, in the never ending quest for better GP performance, I am onto indexes. I am convinced that there are additional indexes that can improve GP in real life situations, but have been unable to find anyone listing indexes they have used. So my question is, has anyone used the tuning advisor in sql server 05 and implemented its reccomendations? Were there noticable effects on GP performance? While I can run a trace against production and the advisor against a dev environment, I am still wary of implementing the changes in production... On a side question, where are the actual autocomplete values stored? Thanks in advance, Jason
wuwei26
greatplains
29623 articles. 
5 followers.
3 Replies
740 Views
According to KB article 898982, the Autocomplete entries are stored in two files: AutoCmpl.dat and AutoCmpl.idx. You can view the contents with a text editor, but as far as I know you can't change them. They appear to be some sort of database file, but I don't know what kind. You can find them in the following location: Documents and Settings\username\Application Data\Microsoft Business Solutions\Microsoft Dynamics GP\dbname\ Despite what the KB says, the "Microsoft Dynamics GP" subfolder is correct for version 9. -- Bud Cool, Accounting System Manager HDA, Inc. Hazelwood, MO GP 9.0, SP2 "wuwei26" wrote: > Hello there, in the never ending quest for better GP performance, I am onto > indexes. I am convinced that there are additional indexes that can improve > GP in real life situations, but have been unable to find anyone listing > indexes they have used. So my question is, has anyone used the tuning > advisor in sql server 05 and implemented its reccomendations? Were there > noticable effects on GP performance? While I can run a trace against > production and the advisor against a dev environment, I am still wary of > implementing the changes in production... > > On a side question, where are the actual autocomplete values stored? > > Thanks in advance, > > Jason
BudThanks Bud, I looked through the kb but was unable to find this. Much appreciated. "Bud" wrote: > According to KB article 898982, the Autocomplete entries are stored in two > files: AutoCmpl.dat and AutoCmpl.idx. You can view the contents with a text > editor, but as far as I know you can't change them. They appear to be some > sort of database file, but I don't know what kind. > > You can find them in the following location: > > Documents and Settings\username\Application Data\Microsoft Business > Solutions\Microsoft Dynamics GP\dbname\ > > Despite what the KB says, the "Microsoft Dynamics GP" subfolder is correct > for version 9. > > -- > Bud Cool, Accounting System Manager > HDA, Inc. Hazelwood, MO > GP 9.0, SP2 > > > "wuwei26" wrote: > > > Hello there, in the never ending quest for better GP performance, I am onto > > indexes. I am convinced that there are additional indexes that can improve > > GP in real life situations, but have been unable to find anyone listing > > indexes they have used. So my question is, has anyone used the tuning > > advisor in sql server 05 and implemented its reccomendations? Were there > > noticable effects on GP performance? While I can run a trace against > > production and the advisor against a dev environment, I am still wary of > > implementing the changes in production... > > > > On a side question, where are the actual autocomplete values stored? > > > > Thanks in advance, > > > > Jason
These files are stored in the Faircom Ctree database format. The reason they are ctree files is because you don't need a database engine (like Pervasive P.SQL) locally to read/write them. They are stored in your own local profile so they are unique to the user and for that requirement, must be ctree files then. If you had, say, a Dynamics 4.0 CD (or maybe 5.0) the ODBC drivers were on the CD and you could look at the files with whatever appliation you wanted. The drivers were read-only however so that provides pretty limited value unless you were just curious about the table. patrick developer support -- This posting is provided "AS IS" with no warranties, and confers no rights. "wuwei26" <wuwei26@discussions.microsoft.com> wrote in message news:EBD80EA0-20B7-446A-96B6-6251CD584244@microsoft.com... > Thanks Bud, I looked through the kb but was unable to find this. Much > appreciated. > > "Bud" wrote: > >> According to KB article 898982, the Autocomplete entries are stored in >> two >> files: AutoCmpl.dat and AutoCmpl.idx. You can view the contents with a >> text >> editor, but as far as I know you can't change them. They appear to be >> some >> sort of database file, but I don't know what kind. >> >> You can find them in the following location: >> >> Documents and Settings\username\Application Data\Microsoft Business >> Solutions\Microsoft Dynamics GP\dbname\ >> >> Despite what the KB says, the "Microsoft Dynamics GP" subfolder is >> correct >> for version 9. >> >> -- >> Bud Cool, Accounting System Manager >> HDA, Inc. Hazelwood, MO >> GP 9.0, SP2 >> >> >> "wuwei26" wrote: >> >> > Hello there, in the never ending quest for better GP performance, I am >> > onto >> > indexes. I am convinced that there are additional indexes that can >> > improve >> > GP in real life situations, but have been unable to find anyone listing >> > indexes they have used. So my question is, has anyone used the tuning >> > advisor in sql server 05 and implemented its reccomendations? Were >> > there >> > noticable effects on GP performance? While I can run a trace against >> > production and the advisor against a dev environment, I am still wary >> > of >> > implementing the changes in production... >> > >> > On a side question, where are the actual autocomplete values stored? >> > >> > Thanks in advance, >> > >> > Jason
prot1
Similar Artilces:
Access Database Conversion to Excel Database
I need to convert a downloaded database in Access format to an Excel format I can use on my desktop. Hi Greg One way Use Data>Import External Data in the menubar -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "greg" <anonymous@discussions.microsoft.com> wrote in message news:b0f301c3ec2b$2b12d830$a001280a@phx.gbl... > I need to convert a downloaded database in Access format > to an Excel format I can use on my desktop. ...
Nothing shows up in Database objects in Database Wizard
Hello, I am having touble with Visio 2003 once again. Though the db wizard, I created an excel spreadsheet (table) for data and am tryinig to link the chart back to this original database so that when I change something in the database it will change correspondingly. I am going back through the DB wizard, and can only get as far as selecting a database object to connect to. I have selected the original dada source, checked table, but nothing showes up under the database objects. Am I or my computer missing something? Please help! Thank You. Have you defined a name for the region ...
Huge database
Good afternoon, i have to make a huge database wich have to get data from excel file.That is not a big problem problem is that i have to get information for about 1000 families with 1000 elements for every family and this database have to storage this information at leaset one year. This make a huge pack of elements. Can Microsoft Access get so huge pack of data ? If yes i would be glad to read some ideas. Thanks If you are talking about 1000 columns in a table, Access can't do it. 255 is the upper limit. 1,000 * 1,000 is potentially a million records. However if the data is pr...
linking 2 databases in 1
Hi, I am running 2 hqs for 2 different purposes, now the company decided to use 1 hq for both purpose. How can i link the 2 databases into 1 database???? I tired to link them from SQL server enterprise manager-all task- export data from database A to B but some tables can not be exported and show me tables failure, is it possible to link them or im just trying something impossible? Advice me on that plZzzzZZzz -- Aliko ...
Importing Current Database into CRM Database
Hi, I would just like to know if it is possible to tranfer my current database into the Adventure Works Database(and if so how) or is it used just for a few records for testing purposes. You help will be highly appreciated... there is a redeployment tool on support.microsoft.com/downloads under microsoft crm. This may help you. -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "Rock619" <rodger@intervigil.com> wrote in message news:5728edd40161d2cca1c0e079cfd86665@localhost.talkaboutsoftware.com... > Hi, > > I would just like to know if it is pos...
how to start a database
hi guys, i want to start a database on excel 2000, i never had to do this before, and i know this can be done. i just dont know where to start from ! what i want to do is, it is a racing club, i want a listing of all pilot and a sheet where we can enter the number of the car(all pilot info need will be transfer) for final result of the race.(right now they enter the car no, name , city at every race at every registration, if he is register to 3 race they do the process 3 time.) like in access went we create the database and after the query, that what i want to do in excel. any tip or link...
Use query from another database
Hi In the code below is there a way that qryOrderHistory could be in a separate database. If so how would i refer to it in the code. Thanks Dim db As DAO.Database Dim qd As DAO.Querydef Dim rs As DAO.Recordset Set db = CurrentDb Set qd = db.QueryDefs("qryOrderHistory") qd.Parameters("prmCustNo") = lngCustNo Set rs = qd.OpenRecordset() If Not rs.Eof Then .... code to populate an excel spreadsheet Change your 'Set db = CurrentDb' line to something like the following .. Set db = DbEngine.OpenDatabase("full path and name of target MDB here") -- ...
Database Queries with database views, that base on many database t
I created 2 database views. Each of them uses 256 database tables. From every database table only one column is used in the select list of the view. Every database table has one column which is used for the join. Each database table has 5 rows. The database tables have not any foreign keys and indexes. Both views works fine. When I use the database views in a query like this: SELECT v1.*, v2.* FROM v1, v2 WHERE v1.id=v2.id I should get 5 rows with 512 columns in the resultset. But I get the following error from the SQL-Server (after about 5 minutes): Msg 8621, Level 17, State 2...
Impact of changing database column width?
Hi, We are a software product company and are planning to begin using the Contract Administration module. To do so, we will be switching our inventory items from Track: None to Track: Serial Numbers and we will be storing our software license keys in the Serial Number field which is column SERLTNUM in table SOP10201. Unfortunately, SERLTNUM is CHAR(21) and our license keys are a few characters wider than 21. We can get the keys down to 21 characters by removing three embedded hyphens, but there are several databases outside of GP where the license keys must still exist with...
Set Database in Excel
In Microsoft article 183446 under method 2, it refers to using "Set Database" on the Data menu. I am using Excel 2002 (the article says it applies to Excel 2002), but Set Database does not appear in my Data menu. Is this an error? It's an error due, I think, to very old menu structures. The article says that the information applies to everything from version 5.0 (1995) through 2003, inclusive. But I believe that the Set Database menu item disappeared from the Data menu as of Excel 97. And one has long defined a name using the Insert menu, not the Formula menu. But my rapidl...
upgraded from MSSQL 2000 to MSSQL 2005 now database's users have
Hello. I updated the MSSQL 2000 server to MSSQL 2005 server now the database's users have no login names. I found a way to list orphaned users sp_change_users_login 'Report' but it only listed dbo and there are actually five listed with MSSQL Server Management Studio Express. I tried this sp_change_users_login 'update_one', 'RPS', 'RPS' but I get the following error the user name 'RPS' is absent or invalid. Any ideas? Try with Auto_Fix instead; see the example at the end of the following article: http://msdn.microsoft.com/en-us/...
Client access problem after databases restoration
Hello! Recently we had a problem with an Exchange 2003 Back-End server with 6 mailbox store distributed thru 4 SG, and we lost the databases because the SAN's disks partitions were deleted by mistake. So, we had to do a restore from a backup, but when we could not mount the stores, so we used eseutil /p command, and after, eseutil /d, and then isinteg -s servername -fix -test alltests. We could mount the stores, users can use email. The problem now is that we have some users that could not access their mailbox thru Outlook, and when we try to move to another store, we receive an ...
database or other software?
I need help with the following situation: I want to create files or a database that will contain information about my clients, with their business information (i.e address, phone, fax, type of business, in which states they do business) to send an invitation to bid on a construction project. I want , where a database would fill out the information automatically on the bid invitation, then fax, or email the invitation to each selected clients according to their specialty. Then I will need to keep track of who answers my invitations in order to "weed out" clients who do...
Form in another database
How can I check if an Access form is open or loaded when the form is in another Access application (mdb or nde file). Alex ...
Attendance Database Setup
I am creating an attendance database for my company. There are 19 different departments in the company and each manager tallies his/her own employee attendances. I had a spreadsheet set up, but it wasn't on a rolling calendar basis. Then, I was going to have the managers delete old months, but that would most likely mess with the formulas. So the new spreadsheet needs to be on a rolling calendar basis, so that when a new month comes up, the previous month from last year will drop off in calculations. My file has three worksheets, one titled "Summary", one titled "Detail...
Recover a Prod content database to Dev farm
Hello, I was wondering is it possible to recover (copy) a content database from a seperate farm to a Dev farm? I came across a few hints about using the "Copy the database files to a network folder" option, but nothing concrete. I'd appreciate if someone could clarify this for me? regards, Edgar You can recovery a database to a network location. We have the following options: http://technet.microsoft.com/en-us/library/bb808956.aspx You will see the details in the "Tasks" section -- Santhosh Sivarajan | MCTS, MCSE (W2K3/W2K/NT4), MCSA (W2K3/W2K...
Database schema
Does anybody have an "official" database schema or data model for these databases? The list of tables and field names for the dbs are in the Resource Descriptions under Tools in GP Our book Information Flow and Posting maps the movement of data between the tables for the transactions in GP, RM, PM POP, SOP, and Inventory. Find it on our web site at http://www.AccoladePublications.com Are we going to see you at Convergence in Orlando? We are throwing a big party aboard an ocean going cruise ship on Wednesday. Visit our web site at http://www.AccoladePublications.com for d...
moving database
I would like to know how tomove the database we use to another computer while we upgrade to windows xp (formating the drive) and still be able to work i have looked in the book but it only shows how to restore..thanks You first need to do a manual backup of the database. Take the .bck file over to the computer that you are going to be using in the interim. Follow the steps on restoring the backup. Then change where the database points to in the SO Administrator to on that computer to point locally = (local). After changing the setting press the Test Database Connection button if it suc...
Showing the actual database, not access's idea of it...
I've been working with MS Access for the past few weeks. A friend has a side job working for a summer camp and he needed a database to store all the kids information. Using VBA is not going to happen, I thought I could do what he needed much much easier in visual studios.net 2008 and I probably could have if that department of Microsoft didn't do what appears as drastic as disown the MS Access department. After much work I am able to read/replace and edit the data, but through the whole process I started noticing this. First, in Access the ID(auto number) is listed co...
how do I print mailing labels from an Excel database?
I want to use my database on excel to print mailing labels as well. Is that possible? How? Hi Patrizio1957 See http://www.mvps.org/dmcritchie/excel/mailmerg.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Patrizio1957" <Patrizio1957@discussions.microsoft.com> wrote in message news:44DFA6B5-E091-4301-AC65-67B55A2C033B@microsoft.com... >I want to use my database on excel to print mailing labels as well. Is that > possible? How? Labels from within Excel alone is a trial and error operation. Best to use Word for the mailmerge operation. For help on Word...
Printing database model
Hi All I am using VISIO 2007 and have created a database model and would like to print it out with table properties, notes, column properties, information etc. However when I print I see only a picture of the tables and nothing about the detailed database properties that I spent so much time entering. Also how do I build SQL/ make a database with the model I created here? Is this tool not capable of doing this basic stuff? Very frustrated! TIA Hi Arun, You must have the Visio for enterprise architects version for generate a database from you visio drawing and for having more repor...
Remote Database and Office Database
Hello, My boss would like to have several of his field employees (9) have an Access application on there laptop/netbook device so when they visit customers, they can input data into the database. They will not have access to the internet or any type of Remote connection. This will be a stand-alone Access application on their laptop. ( Field person will meet with 10 customer a day.) My two questions have to do with when the field employees come back into the office. What will be the best way to a) get data from their version of the database on their l...
Excel database
Folks: I have a small spreadsheet consising of 5 columns & 10 rows of information. Each day I manually update this spreadsheet so I end up with a new set of data in the rows & columns. But this means that the previous day's data is lost. * Is there a way to create (then save) each day's data to a database so that I can always go back to check on the old data ? When I enter data in the spreadsheet, it should get stored in this database. The spreadsheet is merely acting like a FORM thru which data gets sent to the database. Thanks, Jo.. I usually do this manually. I...
Database with Multiple Users
I am trying to create a database that has the potential for many users. I recently learned how to set securities and passwords for the database, but I still can't figure out one thing: Is there a way to have a database with multiple users, but restrict what each person sees? The way my database is set up now, all information is stored in a table, and the user would fill out the form to enter their information. These users will also have the ability to edit their information later. On both the table and the form, however, other users can still see all of the information, ...
unable to rebuild entourage database ( Error corruption opening database [-39])
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Email Client: pop Me at Mac osx 10.5.8 Intel 2.66 4GB <br> Office 12.0.1 <br><br>I was just working fine with my entourage last 2 days ago but the next day i found the message Entourage database failed to open <br> I tried all what i can do the microsoft 6 Steps as well and moving data to another mac <br> But Still the same problem is <br> Error Corruption Opening Database [-39""] <br> can any one tell me that what i can do <br> Microsoft sayin...
I need to convert a downloaded database in Access format to an Excel format I can use on my desktop. Hi Greg One way Use Data>Import External Data in the menubar -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "greg" <anonymous@discussions.microsoft.com> wrote in message news:b0f301c3ec2b$2b12d830$a001280a@phx.gbl... > I need to convert a downloaded database in Access format > to an Excel format I can use on my desktop. ...
Nothing shows up in Database objects in Database Wizard
Hello, I am having touble with Visio 2003 once again. Though the db wizard, I created an excel spreadsheet (table) for data and am tryinig to link the chart back to this original database so that when I change something in the database it will change correspondingly. I am going back through the DB wizard, and can only get as far as selecting a database object to connect to. I have selected the original dada source, checked table, but nothing showes up under the database objects. Am I or my computer missing something? Please help! Thank You. Have you defined a name for the region ...
Huge database
Good afternoon, i have to make a huge database wich have to get data from excel file.That is not a big problem problem is that i have to get information for about 1000 families with 1000 elements for every family and this database have to storage this information at leaset one year. This make a huge pack of elements. Can Microsoft Access get so huge pack of data ? If yes i would be glad to read some ideas. Thanks If you are talking about 1000 columns in a table, Access can't do it. 255 is the upper limit. 1,000 * 1,000 is potentially a million records. However if the data is pr...
linking 2 databases in 1
Hi, I am running 2 hqs for 2 different purposes, now the company decided to use 1 hq for both purpose. How can i link the 2 databases into 1 database???? I tired to link them from SQL server enterprise manager-all task- export data from database A to B but some tables can not be exported and show me tables failure, is it possible to link them or im just trying something impossible? Advice me on that plZzzzZZzz -- Aliko ...
Importing Current Database into CRM Database
Hi, I would just like to know if it is possible to tranfer my current database into the Adventure Works Database(and if so how) or is it used just for a few records for testing purposes. You help will be highly appreciated... there is a redeployment tool on support.microsoft.com/downloads under microsoft crm. This may help you. -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "Rock619" <rodger@intervigil.com> wrote in message news:5728edd40161d2cca1c0e079cfd86665@localhost.talkaboutsoftware.com... > Hi, > > I would just like to know if it is pos...
how to start a database
hi guys, i want to start a database on excel 2000, i never had to do this before, and i know this can be done. i just dont know where to start from ! what i want to do is, it is a racing club, i want a listing of all pilot and a sheet where we can enter the number of the car(all pilot info need will be transfer) for final result of the race.(right now they enter the car no, name , city at every race at every registration, if he is register to 3 race they do the process 3 time.) like in access went we create the database and after the query, that what i want to do in excel. any tip or link...
Use query from another database
Hi In the code below is there a way that qryOrderHistory could be in a separate database. If so how would i refer to it in the code. Thanks Dim db As DAO.Database Dim qd As DAO.Querydef Dim rs As DAO.Recordset Set db = CurrentDb Set qd = db.QueryDefs("qryOrderHistory") qd.Parameters("prmCustNo") = lngCustNo Set rs = qd.OpenRecordset() If Not rs.Eof Then .... code to populate an excel spreadsheet Change your 'Set db = CurrentDb' line to something like the following .. Set db = DbEngine.OpenDatabase("full path and name of target MDB here") -- ...
Database Queries with database views, that base on many database t
I created 2 database views. Each of them uses 256 database tables. From every database table only one column is used in the select list of the view. Every database table has one column which is used for the join. Each database table has 5 rows. The database tables have not any foreign keys and indexes. Both views works fine. When I use the database views in a query like this: SELECT v1.*, v2.* FROM v1, v2 WHERE v1.id=v2.id I should get 5 rows with 512 columns in the resultset. But I get the following error from the SQL-Server (after about 5 minutes): Msg 8621, Level 17, State 2...
Impact of changing database column width?
Hi, We are a software product company and are planning to begin using the Contract Administration module. To do so, we will be switching our inventory items from Track: None to Track: Serial Numbers and we will be storing our software license keys in the Serial Number field which is column SERLTNUM in table SOP10201. Unfortunately, SERLTNUM is CHAR(21) and our license keys are a few characters wider than 21. We can get the keys down to 21 characters by removing three embedded hyphens, but there are several databases outside of GP where the license keys must still exist with...
Set Database in Excel
In Microsoft article 183446 under method 2, it refers to using "Set Database" on the Data menu. I am using Excel 2002 (the article says it applies to Excel 2002), but Set Database does not appear in my Data menu. Is this an error? It's an error due, I think, to very old menu structures. The article says that the information applies to everything from version 5.0 (1995) through 2003, inclusive. But I believe that the Set Database menu item disappeared from the Data menu as of Excel 97. And one has long defined a name using the Insert menu, not the Formula menu. But my rapidl...
upgraded from MSSQL 2000 to MSSQL 2005 now database's users have
Hello. I updated the MSSQL 2000 server to MSSQL 2005 server now the database's users have no login names. I found a way to list orphaned users sp_change_users_login 'Report' but it only listed dbo and there are actually five listed with MSSQL Server Management Studio Express. I tried this sp_change_users_login 'update_one', 'RPS', 'RPS' but I get the following error the user name 'RPS' is absent or invalid. Any ideas? Try with Auto_Fix instead; see the example at the end of the following article: http://msdn.microsoft.com/en-us/...
Client access problem after databases restoration
Hello! Recently we had a problem with an Exchange 2003 Back-End server with 6 mailbox store distributed thru 4 SG, and we lost the databases because the SAN's disks partitions were deleted by mistake. So, we had to do a restore from a backup, but when we could not mount the stores, so we used eseutil /p command, and after, eseutil /d, and then isinteg -s servername -fix -test alltests. We could mount the stores, users can use email. The problem now is that we have some users that could not access their mailbox thru Outlook, and when we try to move to another store, we receive an ...
database or other software?
I need help with the following situation: I want to create files or a database that will contain information about my clients, with their business information (i.e address, phone, fax, type of business, in which states they do business) to send an invitation to bid on a construction project. I want , where a database would fill out the information automatically on the bid invitation, then fax, or email the invitation to each selected clients according to their specialty. Then I will need to keep track of who answers my invitations in order to "weed out" clients who do...
Form in another database
How can I check if an Access form is open or loaded when the form is in another Access application (mdb or nde file). Alex ...
Attendance Database Setup
I am creating an attendance database for my company. There are 19 different departments in the company and each manager tallies his/her own employee attendances. I had a spreadsheet set up, but it wasn't on a rolling calendar basis. Then, I was going to have the managers delete old months, but that would most likely mess with the formulas. So the new spreadsheet needs to be on a rolling calendar basis, so that when a new month comes up, the previous month from last year will drop off in calculations. My file has three worksheets, one titled "Summary", one titled "Detail...
Recover a Prod content database to Dev farm
Hello, I was wondering is it possible to recover (copy) a content database from a seperate farm to a Dev farm? I came across a few hints about using the "Copy the database files to a network folder" option, but nothing concrete. I'd appreciate if someone could clarify this for me? regards, Edgar You can recovery a database to a network location. We have the following options: http://technet.microsoft.com/en-us/library/bb808956.aspx You will see the details in the "Tasks" section -- Santhosh Sivarajan | MCTS, MCSE (W2K3/W2K/NT4), MCSA (W2K3/W2K...
Database schema
Does anybody have an "official" database schema or data model for these databases? The list of tables and field names for the dbs are in the Resource Descriptions under Tools in GP Our book Information Flow and Posting maps the movement of data between the tables for the transactions in GP, RM, PM POP, SOP, and Inventory. Find it on our web site at http://www.AccoladePublications.com Are we going to see you at Convergence in Orlando? We are throwing a big party aboard an ocean going cruise ship on Wednesday. Visit our web site at http://www.AccoladePublications.com for d...
moving database
I would like to know how tomove the database we use to another computer while we upgrade to windows xp (formating the drive) and still be able to work i have looked in the book but it only shows how to restore..thanks You first need to do a manual backup of the database. Take the .bck file over to the computer that you are going to be using in the interim. Follow the steps on restoring the backup. Then change where the database points to in the SO Administrator to on that computer to point locally = (local). After changing the setting press the Test Database Connection button if it suc...
Showing the actual database, not access's idea of it...
I've been working with MS Access for the past few weeks. A friend has a side job working for a summer camp and he needed a database to store all the kids information. Using VBA is not going to happen, I thought I could do what he needed much much easier in visual studios.net 2008 and I probably could have if that department of Microsoft didn't do what appears as drastic as disown the MS Access department. After much work I am able to read/replace and edit the data, but through the whole process I started noticing this. First, in Access the ID(auto number) is listed co...
how do I print mailing labels from an Excel database?
I want to use my database on excel to print mailing labels as well. Is that possible? How? Hi Patrizio1957 See http://www.mvps.org/dmcritchie/excel/mailmerg.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Patrizio1957" <Patrizio1957@discussions.microsoft.com> wrote in message news:44DFA6B5-E091-4301-AC65-67B55A2C033B@microsoft.com... >I want to use my database on excel to print mailing labels as well. Is that > possible? How? Labels from within Excel alone is a trial and error operation. Best to use Word for the mailmerge operation. For help on Word...
Printing database model
Hi All I am using VISIO 2007 and have created a database model and would like to print it out with table properties, notes, column properties, information etc. However when I print I see only a picture of the tables and nothing about the detailed database properties that I spent so much time entering. Also how do I build SQL/ make a database with the model I created here? Is this tool not capable of doing this basic stuff? Very frustrated! TIA Hi Arun, You must have the Visio for enterprise architects version for generate a database from you visio drawing and for having more repor...
Remote Database and Office Database
Hello, My boss would like to have several of his field employees (9) have an Access application on there laptop/netbook device so when they visit customers, they can input data into the database. They will not have access to the internet or any type of Remote connection. This will be a stand-alone Access application on their laptop. ( Field person will meet with 10 customer a day.) My two questions have to do with when the field employees come back into the office. What will be the best way to a) get data from their version of the database on their l...
Excel database
Folks: I have a small spreadsheet consising of 5 columns & 10 rows of information. Each day I manually update this spreadsheet so I end up with a new set of data in the rows & columns. But this means that the previous day's data is lost. * Is there a way to create (then save) each day's data to a database so that I can always go back to check on the old data ? When I enter data in the spreadsheet, it should get stored in this database. The spreadsheet is merely acting like a FORM thru which data gets sent to the database. Thanks, Jo.. I usually do this manually. I...
Database with Multiple Users
I am trying to create a database that has the potential for many users. I recently learned how to set securities and passwords for the database, but I still can't figure out one thing: Is there a way to have a database with multiple users, but restrict what each person sees? The way my database is set up now, all information is stored in a table, and the user would fill out the form to enter their information. These users will also have the ability to edit their information later. On both the table and the form, however, other users can still see all of the information, ...
unable to rebuild entourage database ( Error corruption opening database [-39])
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Email Client: pop Me at Mac osx 10.5.8 Intel 2.66 4GB <br> Office 12.0.1 <br><br>I was just working fine with my entourage last 2 days ago but the next day i found the message Entourage database failed to open <br> I tried all what i can do the microsoft 6 Steps as well and moving data to another mac <br> But Still the same problem is <br> Error Corruption Opening Database [-39""] <br> can any one tell me that what i can do <br> Microsoft sayin...