Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Could someone please point me in the right direction or give a few examples
of reading and writing data from a vba user form to a .dbf file. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Is the dbf file open in Excel?
-- Regards, Tom Ogilvy "James W." wrote in message ... Could someone please point me in the right direction or give a few examples of reading and writing data from a vba user form to a .dbf file. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
If the dbf file is open in excel I am assuming that it would be the same as
reading and writing data to a worksheet, correct me if I am wrong. Is it possible to write the data to a dbf file that isnt open in excel? If so please point me in the right direction. Reasoning behind this: Project Shop Floor Control I have created multiple forms that are used on our production floor, using Excel as the host application. I would like to store this data in a more secure location so that data cannot be manipulated in any way except through the forms I have created. I felt that access would be perfect for this but I doubt I could get them to buy 15 seats of access. I am mearly looking at alternative means to store this data rather than just in a worksheet. Your insight is greatly appreciated. "Tom Ogilvy" wrote: Is the dbf file open in Excel? -- Regards, Tom Ogilvy "James W." wrote in message ... Could someone please point me in the right direction or give a few examples of reading and writing data from a vba user form to a .dbf file. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Try searching the knowledge base and you might turn something up or perhaps
someone will jump in with an answer. http://support.microsoft.com Here is a start: http://support.microsoft.com/default...b;en-us;326548 HOW TO: Use Jet OLE DB Provider 4.0 to Connect to ISAM Databases -- Regards, Tom Ogilvy "James W." wrote in message ... If the dbf file is open in excel I am assuming that it would be the same as reading and writing data to a worksheet, correct me if I am wrong. Is it possible to write the data to a dbf file that isnt open in excel? If so please point me in the right direction. Reasoning behind this: Project Shop Floor Control I have created multiple forms that are used on our production floor, using Excel as the host application. I would like to store this data in a more secure location so that data cannot be manipulated in any way except through the forms I have created. I felt that access would be perfect for this but I doubt I could get them to buy 15 seats of access. I am mearly looking at alternative means to store this data rather than just in a worksheet. Your insight is greatly appreciated. "Tom Ogilvy" wrote: Is the dbf file open in Excel? -- Regards, Tom Ogilvy "James W." wrote in message ... Could someone please point me in the right direction or give a few examples of reading and writing data from a vba user form to a .dbf file. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
James W. wrote:
If the dbf file is open in excel I am assuming that it would be the same as reading and writing data to a worksheet, correct me if I am wrong. Is it possible to write the data to a dbf file that isnt open in excel? If so please point me in the right direction. Reasoning behind this: Project Shop Floor Control I have created multiple forms that are used on our production floor, using Excel as the host application. I would like to store this data in a more secure location so that data cannot be manipulated in any way except through the forms I have created. I felt that access would be perfect for this but I doubt I could get them to buy 15 seats of access. I am mearly looking at alternative means to store this data rather than just in a worksheet. Your insight is greatly appreciated. Use Access. You only need a single licence for the person who will create and administer the database. All of the other seats can connect into the Access db via Excel, ADO and VBA. ADO (via the MIcrosoft Data Access Components - MDAC) can be installed freely on all the other machines in the group (in fact it's probably already there). -- Rob http://www.asta51.dsl.pipex.com/webcam/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Rob Bruce wrote:
Use Access. You only need a single licence for the person who will create and administer the database. All of the other seats can connect into the Access db via Excel, ADO and VBA. Get the admin guy to create and administer the database using ADO. That way you don't need a single MS Access licence! Jamie. -- |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Jamie Collins wrote:
Rob Bruce wrote: Use Access. You only need a single licence for the person who will create and administer the database. All of the other seats can connect into the Access db via Excel, ADO and VBA. Get the admin guy to create and administer the database using ADO. That way you don't need a single MS Access licence! <pedant intensity="Extreme"You can't create Access databases with ADO. You have to use ADOX</pedant Seriously, administering a database is a lot easier with a dedicated database administation tool. Sure, you could probably build one in Excel/VBA, but I'm damn sure it would cost a lot more than buying a single Access seat. Rob |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Rob Bruce wrote:
Jamie Collins wrote: <pedant intensity="Extreme"You can't create Access databases with ADO. You have to use ADOX</pedant Sorry, I should have warned you: I'm a dedicated pedant myself. ADOX is one of the 'ADO component libraries', the phrase being Microsoft's rather than mine. See: http://msdn.microsoft.com/library/de...tlibraries.asp I think you may have confused my use of 'ADO' with Microsoft ActiveX Data Objects, however its moniker equivalent to ADOX would be ADODB. Better luck next time <g. Jamie. -- |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read/Write VBA Form to .dbf
Jamie Collins wrote:
Rob Bruce wrote: Jamie Collins wrote: <pedant intensity="Extreme"You can't create Access databases with ADO. You have to use ADOX</pedant Sorry, I should have warned you: I'm a dedicated pedant myself. ADOX is one of the 'ADO component libraries', the phrase being Microsoft's rather than mine. See: http://msdn.microsoft.com/library/de...tlibraries.asp I think you may have confused my use of 'ADO' with Microsoft ActiveX Data Objects, however its moniker equivalent to ADOX would be ADODB. Better luck next time <g. Jamie. I fully realise that usenettiquette dictates that we should now descend into a flame war culminating in both of us proclaiming that the other doesn't know the first thing about data access using MS technology because of a missed apostrophy or some such other typo several posts back, but I really can't be bothered. I'm sure I've got better things to do. ;-) Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read only and write only | New Users to Excel | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
write to/read from add-ins | Excel Programming |