Create Database From INI File Provided

Mar 3, 2012

An ancient application I'm working with came with .ini file which looks like an instruction set to create an access database. A sample few lines look like:

TABLE, USER, 13
FIELD,USRID,LONG,2,NODUP,ID,False,0,AUTO
FIELD,USRFNAME,TEXT, 50, NO, , True, 1

TABLE,VISITS,15
FIELD,VISIT,TEXT,12,NODUP, ID,False, 0

and so on.

Is there a way to get Access (2007 in my case) to create a new db by reading from this file? Or do I need to manually enter all this information.

View Replies


ADVERTISEMENT

Modules & VBA :: How To Create New Lock File Within Current Database

Apr 7, 2015

What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This would allow the end users to zip this file up and send it to me.

Because of all sorts of stupidity, I have no network capability and must send data back and forth via email.

I have digressed to a replication table that needs to be uploaded, once data is entered by the users...

Because the files can get relatively large (for emailing purposes), I am trying to figure out how I can get just one table from them vs. sending the whole application file back to me... It's pretty vital that they not be able to edit the table because that could really mess up the process.

So any way to create a new lock file from within the current Db?

View 1 Replies View Related

General :: Create Database In Access That Links To Contacts In Outlook Pst File

Nov 21, 2013

I have limited programming skills but a basic understanding of databases.I want to create a database in Access that links to contacts in an Outlook pst file, and in the Access database I want to create a series of date dependant tasks or processes that I can apply to the relevant contact.The object being to to save that collection of tasks to apply to different contacts within Access.

View 2 Replies View Related

Please Help Me With This - Screenshot Provided

Apr 16, 2006

http://img12.imagevenue.com/img.php?loc=loc1&image=92574_ss.JPG

Hello, i have a form with combo boxes from 3 different tables. Is there a way to generate a report from the data which is selected in each of the combo boxes? Also is there a way to have a button when clicked - takes the data selected in the combo boxes and places it in a new table altogether.

This is pretty urgent since i need to figure this out today. Any help greatly apreciated. Thanks.

View 3 Replies View Related

Display All Records If No Filtering Criteria Is Provided...

Oct 24, 2007

Hello all,

I've run into a little snag and I'm hoping to reach out for some assistance.

I've created a form that has a drop down box. This dropdown box is populated with a list of values taken from a database.

I've created a query and built an expression that filters the query records by the value of said drop down box.

My issue here is if no value is selected in the drop down box, the query produces no records. I would like the query to display all records if the user did not select a value from the drop down.

Although I'm a beginner by any stretch of the imagination, I did manage to make a conditional in VBA to apply a wildcard (*) if nothing was chosen in the drop down, but that didnt work.

I'm at a loss. Can anyone offer a solution?

TIA,

Fuse

View 3 Replies View Related

Looking For Sample Databases Provided Iwth Access 2003 Inside Out

Jun 24, 2006

Dear Friends,

I am a naive in access and really looking for some mentor to help me learn quickly

I am presently going through a book Call "Microsoft Access 2003 InsideOut" I dont have the cd so thus missing the sample databses discussedin the book.

If anyone can provide me with this data base then it would be a great help

Thanks
Sunny

View 2 Replies View Related

Problem In Entering Data Into A Field In A Table. Screen Shot Provided

Mar 3, 2006

Hi,

im having difficulty adding data into a table which i created, i want to use two or more of the same Student_ID's into one field, while adding different data into another field Subject.

i attached a screen shot of the error.

i would appreciate any help

Many Thanks.

View 2 Replies View Related

Cannot Create An MDE File

Jul 4, 2005

I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work.

This is what I got:

This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.

So installed office XP and tried the same steps but still not working.

View 1 Replies View Related

Unable To Create An Mde File

Jan 1, 2006

I am running access 2000 9.0.2720. I wanted to create an MDE file but every time I attempt I get the message 'unable to create an MDE file'. Any advice?

View 1 Replies View Related

Create Custom Help File

Oct 11, 2004

I am just having a heck of a time, in trying to make a custom help file.

Has anyone had any luck? I sure would like to see a sample database, showing a
custom help file. I just about tried everything, but not to smart about setting one up.
I have tried the wizzard as well. I know where I get hung up is, trying to map the help file,
to the Help ID number.

Any help would be appreceiated

View 6 Replies View Related

Unable To Create .mde File

Oct 28, 2004

I was able to create a MDE database from .MDB file (1900 KB) using Access2000 but not on the other database (5000 KB)
I followed the steps (under tool -database utilities- make MDE file), the message box shown " Microsoft Access was unable to create a MDE database"

Is there any limit on the size of the file? What should i do or check?

NaNy

View 4 Replies View Related

Can't Create MDE File - Alternative

Dec 7, 2005

I have tried to create an MDE file for my database but can't figure out why it will not let me. I can't don't think I am over the limit in open TableIDs. I have 76 Forms and 91 Tables.

I am setup with two databases - the database with the data is on the server. Is there any other alternative that I can do other than putting the mdb file directly on the client. And if not is there a way to stop the mdb file from constantly growing in size.

View 4 Replies View Related

How To Create Log File In Access

Jun 11, 2012

How I can create a log file in Access?

This file will record all processing on access file

View 6 Replies View Related

How To Create An Empty Excel File ?

Sep 28, 2005

Hello,
I would like to know how to create an empty Excel file (from Access) ?
I would like to name the workbook (xxx.xls) name the sheets and give the folder where to store it.
Thanks in advance for help.
VINCENT

View 5 Replies View Related

Create Help File Inside Of Access

Oct 6, 2005

I created a help file in access that lets you have text mesasge up to 1024 chars. Just press F1 key on any control that you have setup to bring up help message.

Does any one see any problems with the way I did this?




Form
Help File: = ""
Help Context ID: = 0

For each control on the form where you would like to have a help message do the following.
Form
Control
Help Context ID: = Set to one of the help index numbers in the help table.

Add KeyDown Event to the control

Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
'Add this line
KeyCode = DisplayHelp(KeyCode, Me.ActiveControl.HelpContextId)
End Sub



module

Function DisplayHelp(KeyCode As Integer, HelpContextId As Integer) As Integer
Dim dbs As DAO.Database
Dim rstRecords As DAO.Recordset

If KeyCode = VBKeyF1 Then ' 112 = F1
Set dbs = CurrentDb
Set rstRecords = dbs.OpenRecordset("SELECT tlbHelp.Index, tlbHelp.HelpMessage " & _
"FROM tlbHelp WHERE (((tlbHelp.Index)=" & HelpContextId & "));")

With rstRecords
If .RecordCount > 0 Then
Call MsgBox(!HelpMessage, vbInformation, "Help")
End If
End With
DisplayHelp = 0 ' Clear KeyCode
rstRecords.Close
Set dbs = Nothing
Else
DisplayHelp = KeyCode
End If
End Function



Create Table and Fields

Table Name: tlbHelp
Field Name: Index as Number
Field Name: HelpMessage as Memo
Field Name: FieldName as Text
Field Name: FormName as Text

How type in custom number and message for each help message.

View 2 Replies View Related

Create Connection Without Lock File

Feb 26, 2006

Hi there, we currently have a database that users write to through an excel form. Each time a user sumbits a record to the database we open a connection up with the below code, insert the record and then close it. This creates a ldb file for 1-3 seconds depending on how long it takes.

' OPEN DATABASE CONNECTION
Set dbConn = New ADODB.Connection
dbConn.CursorLocation = adUseClient
dbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0"
dbConn.Open sConn

' INSERT RECORD THROUGH EXECUTE COMMAND
dbConn.Execute("INSERT INTO.... VALUES....")

' CLOSE CONNECTION
dbConn.Close

Is it possible to open the connection up without an ldb file being created so more than 1 user can insert a record into the database at the same time?

Thanks for your time,

Cheers

Tony

View 6 Replies View Related

Expression To Create A File Code

Nov 16, 2004

I have a main filing table and three look up tables (file cabinet, topic, and subtopic). In the three look up tables I have created short codes to identify the name of the field.

I want to create a main filing code that takes the codes from each lookup table and combines it into one field. If the location of the file changed I would need the code to change.

Example file cabinet location Rod 1 is R1, Accounting is AP; file topic Active Jobs is ACTJOB, Bank Transactions is BANKTR; subtopic Northeast Fire Station is NETCFS. For the file for the fire station the code would read R1ACTJOBNETCFS.

The form is set up as a cascading combo.

The only purpose for this field is to allow me to do a mail merge to create labels so that I can re-file folders easier without having to go into the database and look up the locations.

I don't know if I should create the expression in the form or if I should do something in the table field.

Suggestions?

View 1 Replies View Related

An Easy Way To Create An XML File From A Query?

Jun 13, 2007

Is there a relatively easy way to output the results of a query to an XML file?

I have the file writer set up more or less:
Code: Dim intFn As Integer Dim strFilePath As String Dim strOutBuf As String strFilePath = "c: emp est.xml" intFn = FreeFile Open strFilePath For Binary Access Write As #intFn strOutBuf = "<?xml version=" & Chr(34) & "1.0" & Chr(34) & " standalone=" _ & Chr(34) & "yes" & Chr(34) & "?>" & vbCrLf strOutBuf = strOutBuf & "<file>" & vbCrLf 'DO FOR EACH LOOP HERE strOutBuf = strOutBuf & "</file>" Put #intFn, , strOutBuf Close #intFn
If this were a C or JAVA application, I would just write a "for each" statement similar to as follows:

Code:For Each (Row in Query){ strOutBuf = strOutBuf & "<entry>" & vbCrLf For Each (Field in Row){ strOutBuf = strOutBuf & "<" & (Column Name) & ">" & (Value) _ & "</" & (Column Name) + ">" & vbCrLf } strOutBuf = strOutBuf & "</entry>" & vbCrLf}
What commands would I use in Access to get each separate row in a query? And then to get each field in that row? And how about the column names for the XML tags?

Thank you for your help.

View 4 Replies View Related

Modules & VBA :: How To Create Hexadecimal File

Sep 13, 2013

I would like to read a TIFfle to ACCESS, and store its content as hexadecimal like below to further other process..., how can I achieve this change and storage??

0000: 49 49 2A 00 4E 00 00 00 80 3F E0 50 38 24 16 0D
0010: 07 84 42 61 50 B8 64 36 1D 0F 88 44 62 51 38 A4
0020: 56 2D 17 8C 46 63 51 B8 E4 76 3D 1F 90 48 64 52
0030: 39 24 96 4D 18 80 80 00 60 00 00 00 01 00 00 00
0040: 60 00 00 00 01 00 00 00 08 00 08 00 08 00 0F 00
0050: FE 00 04 00 01 00 00 00 00 00 00 00 00 01 03 00
0060: 01 00 00 00 11 00 00 00 01 01 03 00 01 00 00 00
0070: 0F 00 00 00 02 01 03 00 03 00 00 00 48 00 00 00
0080: 03 01 03 00 01 00 00 00 05 00 00 00 06 01 03 00

View 4 Replies View Related

Create Linked Read-Only File

Feb 13, 2014

Let's say I have a database saved in Folder 1. Is there a way for me to create a read-only copy of that database in Folder 2 so that it can be up-to-date with the changes made in the Folder 1 database? I am running Windows 7.

View 10 Replies View Related

Tables :: Create A New Database Y And Link To Database X

Aug 28, 2013

I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!

View 1 Replies View Related

Modules & VBA :: Create New Backend File From Existing One

Nov 4, 2013

I'm trying to create a button that will open a save window so that user can select where and the name of a new backend file.

and create a new backend file from the one in use and link to the new open.

View 4 Replies View Related

Embedded Pics Create Huge File Size

Jun 27, 2006

I'd read a few places that embedding pics wasnt the greatest of ideas, but I thought that 1 JPG embedded onto 2 forms would be ok and would prevent the pic from being deleted or moved. (Theyre always screwing with the server here.) But it's making my DB huge.

No pics embedded
Size: 808kB

1 Pic Embedded into 2 forms
Pic Size: 156k JPG
DB Size: 135 MB

Is this normal? I could understand a 156k pic adding somewhere around 156k to my DB, but 134 megs? Anyone have any insight?

View 4 Replies View Related

Create Explorer (File Manager) Style Drill Down

Dec 6, 2006

Hello, I am wondering if there is an efficient way to create an explorer style drill down for a location/equipment table I have

i.e.

-Dept
+Finance
+HR
-Quality
+Supplier
+QA
-General
+Etc1
-Etc2
+Production

I have used the tree control to acomplish this but the major drawback I have found is it becomes WAY too slow when utilizing large amounts of data due to many embeded loops. Does anyone know an alternative or a way to program the tree control to only add nodes once a selection is expanded?

Basically I want this to operate as a drilldown of infinate levels with the speed of windows explorer. Unfortunatly all the code I have seen requires that all nodes are designated/Created when the form is loaded.

Any thoughts are greatly appreciated

View 3 Replies View Related

Modules & VBA :: Parse File List And Create PDFs

Jul 5, 2013

I have a spread sheet which on a per line basis contains columns whose cells contain the path to a file. It looks as if many of the files are tif, pdf, word and excel etc, so multiple file types.

Writing a routine which would take each row and then for each line of file paths turn them into one multi-page document - pdf or something?

View 1 Replies View Related

General :: Create File Explorer Functionality In Access

Jan 31, 2013

how to create file explorer like functionality in ms access.

1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories.
2- I also need to be able upload (copy/paste) folders and files in that directory

I looked at different solutions and found a solution which might work on this foum link below.
---access-programmers.co.uk/forums/showthread.php?t=102667----

The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved