Can Access Database Be Converted To V Basic
Nov 16, 2004Is there a program that can convert an MS Access database to Visual Basic?
View Replies
ADVERTISEMENT
Queries :: Converted Desktop Access Database To SQL Server
Dec 5, 2014I have converted desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA, and built an odbc connection for my front end. It works, except it is painfully slow. Its cos most of the recordsets that drive my front end are query based. And in many instances the queries are comprised of queries, not just tables.
Should i be creating my queries on the SQL server? Is that what people do when using Access front end with SQL server back end? Do away with Access queries? Or does the problem lie elsewhere? How do i network optimise my Access FE / SQL server BE?
Help On Basic Access Database
Oct 16, 2006ok I'm an accounting major and for one of my classes which is accounting information systems, they are making us design a database in access. Long story short, our teacher is horrible and is not teaching us access and continues to assume we know it and ignores us when we explain to her that access was never taught in our lower level classes. Our book also does not cover access to an extent that will help us with this project.
I have a small access assignment that requires we make a database for a small video rental store. The only things that need to be kept in mind are that the store has many customers, you stock over 2,500 different movies with most having multiple copies. All daily transactions need to be managed.
I have a relational database done.. I'm just asking if anyone feels like looking at it and pointing out some mistakes or areas that should be worked on or improved I would really appreciate it.. Thank You in advanced!
http://www.imagestation.com/picture/sraid217/p65593dec940cc3d2f42bbf36ced1324e/ec7ee08b.jpg
97 To 2003 Converted Database Size.
Mar 5, 2008I have searched this site but could find no similar questions. SO..
I am converting an Access 97 database to Access 2003.
I have compacted the 97 database before doing anything else.
The size of the 97 database is 91Mb
I have gone into Access 2003 and performed a database utilities>convert database>To Access 2002-2003 format and it has produced an 03 database with a size of 68Mb
I have also created a blank 03 database and imported all objects from the 97 database, changed all the text/memo fields to Unicode Compression = Yes and compacted the new 03 database and the size is 90Mb
What is the Auto conversion process doing that I aren't doing when importing objects that saves it an extra 22Mb? Plus is there anything I can do to free up that extra 22Mb again?
Thanks. Dan.
Need Some Help - Converted Paradox To Access
Jul 13, 2005I am pretty new to Access, so please bear with me :rolleyes:
We have a paradox v 3.1 database that I somehow converted into Access. At least the data was transfered and I can update it via a query.
What I am having a problem understanding is the difference between the main database file (in the object viewer appears as a db, with the the tables underneath. Am I correct to assume that all of the information is centralized into this db file?
I'm also having a problem changing the field lengths. I get a message "table "name" is a linked table with some properties that can't be modified."
I'm assuming this linkage came from paradox, because I didn't do a darn thing to it!! Any ideas on how to "unlink" would be greatly appreciated.
Thanks!
Linda
Basic Database Questions, Probably
Dec 18, 2006I am new to databases,, in fact I've never created one before,,
However I started learning today , for this project,,
I'm going to be learning on my own, but if someone feels kind they can give me the basics on how (the following) database would be created.
Fields
Box # (Number)
CBS Code (number)
Shackle Code (Number)
Agent Name
Property Street
Date Out
Date In
Where I can put in a Box # and it will fill in the other information for that box, showing if its currently out (aka no check in date with most current record),
If its not I can input Agent name, property, and Date out (then it will be checked out)? or some way to accomplish this.
Info can also be looked up by Agent name with autofill for the rest of the fields?,
Or Property with autofill
If searched by box Num, I want all previous agents used (check in and check out value) as well as current
If search by Agent, I want all box information from past, check in, and check in/out. with the rest of the records,,
I know this is possible,,
And I'll figure it out,,
But help speeding my learning would be appriciated
Thanks!
Collin
If Splitting A Database Isn't Possible? (And Some Other Basic Questions).
Jan 21, 2007Hello.
I have spent the last couple of hours looking through the forums but have managed to get myself really confused. Lots of questions, sorry - if anyone can point me in the right direction with one or two of them, I would be hugely grateful!
I have a database in a shared folder on the network at work. It is due to start being used by users other than myself in future weeks, and I see here that it's sensible to split things into a FE and a BE.
1. My initial problem is that I have a nagging memory of being told that we're not supposed to save anything on the individual computers hard drives. Can a split leave both the BE and the various copies of the FE on the shared drive, or does this negate the reasons for splitting in the first place?
2. Additionally, with little space left on the shared drive itself, it's possible we'll not have the room to put 10+ copies of the FE on it anyway. If I just split the database into the BE and ONE copy of the FE which everyone accesses, will the BE at least be made more secure by the split, even if the FE is still vulnerable, and performance isn't improved?
3. If no sort of split is possible, are there any alternatives to splitting?
Lastly, some questions for if we ARE able to split and put the FE on each computer:
(I would be keeping the BE and the "master" version of the FE on the shared drive. All tables in the BE and queries, reports and forms for the "user interface" in the FE. Hopefully this is roughly what I'm supposed to do).
4. With a split database, what happens with compacting? Presumably the BE of the database can be compacted as normal, but what happens with all the versions of the FE? Does each user have to be responsible for compacting them individually? Does an FE even need compacting if the design is unchanged?
5. Does splitting affect what happens if two people either open or amend a record at the same time, or is that still just governed by the record locks setting in Tools (which would need to be set before splitting presumably)?
6. If the design of the FE changes (but none of the underlying tables, queries etc. are touched), do I just give each user a copy of the new version, or does something more complicated have to happen (ie. does the whole splitting process have to take place again)? What about if new tables are added to the BE, or if existing tables / queries are amended? Can I just issue amended versions of the FE that interacts with the new tables as needed?
7. I have drop down lists and combo boxs in the forms in the FE that use tables to populate them. Will it cause problems that these tables are in the BE - such as impractical amounts of time before combo boxs show their options? (The table has to be in the BE (I think?) because the user updates the content of these tables / combo boxs through one of the other forms in the FE)
Many, many, many thanks if anyone can help me out with any of these.
Basic Fields Must Automatically Show Up In The 2nd Database Table. Plz Help. Thanks.
May 29, 2007Hi Everyone.
I am new to MS Access. I got two databases. The 1st database consists of the basic fields like the department,adress,salary etc of the employers(Primary key is the ID). Now in the 2nd database I have the same basic fields and some extra fields. Now my requirement is to when I enter the ID in 2nd database, all the basic fields have to be filled up based on the 1st database( May be I should link the 2 databases).
I really appreciate your help.
Thanks in advance,
Anil.
Networked Database, Basic User Login System
Jun 11, 2007hi.. i have a database stored on my main computer. all pcs on the network have windows xp.the database is stored in a shared folder.. and at the moment.. everyone on the network can open the database.. but not at the same time..basically if i have the database open.. my colleague on the pc next to me has to wait till i close it.so what i am asking is can someone direct me to a simple tutorial or some reading material..that introduces the methods needed to allow multiple pcs to access a single database with or without a login system.i imagine there will be certain read/write and locking issues.. but i really need it.thanks.
View 9 Replies View RelatedCan Access Do Some Basic Calculation ?
Jul 3, 2005I just want it to deduct:
one numeric field from another - to get a miles travelled number ?
one currency figure from another - to get how much more/less fuel was used than last month ?
also to work out:
an average of 3 figures
to multiply one figure by another ?
Is this possible ?
How easy is it ?
This is because I want to move my Excel spreadsheets to Access so I can alalyse it better and create custom reports. But despite browsing Access for a while, I can't find the features I need, or anything in the help file to help me.
I've been using Access for a few years (Access 2000) and have created two custom databases from scratch.
Jay Evans
IT Support Co-ordinator for Simply Drinks Ltd
Access To Visual Basic
Oct 12, 2005Greetings to all the experts out there,
Here is something I wonder if it has already existed or been asked before, a program or an add-in feature that can compile an Access database (including forms, reports, tables...) to a stand-alone .exe application, just like Visual Basic does. The reason why I think it's doable is because in Access, we use VB codes anyway and it wouldn't need to be rocket-science for Access to do something like that or this would be an improvement for future versions.
There are plenty of advantages of going from an Access form to a stand-alone app, i.e. we wouldn't need codes to hide background and menu or status bar; we wouldn't need to disable mouse-scroll or prevent users to go back and accidentally delete past records; or we wouldn't need to worry about users seeing your terrific coding techniques and on and on.....Agree that all these can be done within Access but imagine how much time it'd save you from not doing all these things.
Thank you all in advance.
Very Basic Question About Access
Jul 19, 2007If you have an Excel workbook that has a connection via a 'connection' to an Access database, do you have to have the Access software itself or is there some other way to get to the data? Idea is to limit the number of licenses that need to be purchased. Thanks.
View 8 Replies View RelatedBasic Access Question - Sorry
Mar 26, 2005To all in the forum,
I know this is probably Access 101 but I seem to have missed the lesson. I have the following in my database:
tblFAA
tblMANUFACTUREs
tblENGINEs
tblMODELS
linktblFAA/MODEL
qryFAA/MODELS
mainfFAA
subfFAA/MODELS
mainfEDIT_FAAMODELS
There exists a many to many relationship between tblMODELS and tblFAA becasue once this problem is understood the database will be expanded. On my mainfFAA form I have the subfFAA/MODELS form which is displaying the information correctly. I also have a command button which properly opens the mainfEDIT_FAAMODELS form. However, when I open the form via command button it does not display the models listed in the subfFAA/MODELS. I know I can use the wizards to make this work properly but would like to understand the underlying requirements the wizard is inputting to Access.
Furthermore, I want to be able to add models with the mainfEDIT_FAAMODELS and not with the subfFAA/MODELS. I want to do this without displaying the MODELID or the FAA APPROVAL ID fields due to the fact they are useless information. I am sure this can be done via SQL but haven't been able to troubleshoot the syntax correctly.
Lastly I want to filter the ENGINE and MODELS comboboxes in my mainfEDIT_FAAMODELS based on the MANUFACTURE combobox (cascading comboboxes). I know there are many threads regarding this subject but I cannot seem to adapt one of the solutions to work with this database and do not know why.
I am not a programming wiz so please be basic. I think the biggest obstical I am having now is the syntax for filtering, sql, etc. Thank you in advance for your help.
Basic Access Mistake
Nov 3, 2005Due to me still trying to grasp the basics of access, I have what I call the "Command Centre" which is basically a form where our administrators verify all records placed and control them from here.
As different stages of each record requires Authorising/Further Authorising by other users, they will require to update the same records as displayed on the admin control from.
The problem I have is that when the administrators make a change to a record which prompts an authoriser to go into the db and authorise, if the admin users keeps their form open (which is what I want), I understand that it doesn't save changes to the record until they exit the form. Naturally this causes problems for the authoriser.
Is there a way of saving changes to records as they are made so other users can edit the records as see it up to date. I'm thinking along the lines some vb code to save on an action.
Many thanks
kempes
Access And Visual Basic 6
Oct 17, 2004hi... i have a form that display things in a table in access. when program the form to delete a query it deletes it but does not do rs.movenext
what i want to do is the form to display the next set of data from the database. i am using dao....
please help me!!
Mapped Drive Converted To UNC Is Slower
Nov 23, 2005I have my database connected to a network of ten computers. I recently switched my linked tables from a Mapped Network Drive to using the actual UNC path \computerfolderdatabase.mdb
My users have started to notice it takes longer for the database to connect in order to log in. Once they have established the connection, the data transfer speed seems to be normal.
Is this to be expected? Any suggestions to speed things up for login? Or is this the downside to using UNC?
~Scott
Basic MS Access With VBA Project Guidance Please
Dec 28, 2005Hi everyone,
First off sorry for jumping in and asking questions on my first post. I have been searching the net templates and answers and while it has got me so far I still cant find specifics I'm stuck on and would appreciate any help.
I have an access design project to do for uni. To give you some background I've done some VBA programming in excel and have a good grasp of office and windows but haven't really used access before.
I have got Ms Access Inside out (bit over my head) and Ms Access Step by Step and have been working through their tutorials which have helped my understanding of access but dont arnt really specific enough to my project (or maybe i'm missing something)
The Brief is as follows:
"You have been instructed to design and develop and information system to capture students module choices for the business school. The system will run on MS Access and be supported by programs written in visual basic. Spec is as follows:
The system should be designed so that students can automatically select their options for semester 1 and 2 from a screen which will indicate to them whether they have broken any of the following constraints:
-> choose 30 credits in both first and second semester
-> business 2 cannot be selected unless Business 1 is
-> Programming 2 cannot be selected unless programming 1 is
-> Decision making and Data analysis share topics so students cant do both
-> Bus Finance and Corp Finance share topics so students cant do both
There is a table with 7 module options for each semester and their credit weight, either 10 or 20.
The outline is deliberately vague, 20% of marks will be for supplementary features that will enhance the systems functionality and usability.
------------------
Based on the examples I have worked through, I see it like a basic ordering system:
3 tables
Customers (Students)
Products (Modules)
Orders (Chosen Modules)
I need a database that will let me input customer information (that I can do)
Then allow me to Create an order for the customer Using a form that lists the products available from the products table
When Creating the order, with the form, rules need to be enforced to ensure the order is valid (ie certain products are not chosen together, the products value adds up to 30 for semester 1 and 2).
Once the order is complete a report is generated to show the products ordered (modules chosen)
Is this the right way to look at the database design?
I see the module choice form as having all the modules listed and tick boxes, however the only order forms I have managed to find have drop downs, any pointers here?
Am I right in thinking it would be VBA that will allow me to set and enforce the rules on module selection? If so any pointers on how?
Is there a way to get VBA to validate the inputs on the order form in real time, eg grey out one selection if another is selected, not allow more module to be ticked than 30 credits. I guess the code can be looped to do this? or is it easier to check the inputs after ok is pressed then give a warning box if its incorrect.
Again apologies for coming in on my first post and asking a torrent of probably basic questions, but I have tried my books and the net and would appreciate any guidance
Kind Regards, tom999
Using Access Query In Visual Basic?
Sep 18, 2006I have an access Query(named newSerial) :
SELECT TOP 1 (Productbase.Serialnumber+1) AS Expr1 FROM ProductBase
ORDER BY (Productbase.Serialnumber+1) DESC;
I want to access this new value. Its not a key since an autonumber may be any number. When I create a new product. How do I get this value inside a form?
It works fine when clicking on it. But if I use an unbound box I get 1 as result and not like 76067 which it should be. If I click the query in access it works fine and show 76067.
I tried:
outbox=Expr1
' gives null
'or
outbox=[newserial].[Expr1]
' which gives "Access cant find the field "|" refered to you in your expression"
What should I write? Whats the correct expression?
Basic Access Query Question
Sep 10, 2004Is it possible to use a value on an Access driven form as a parameter in a pass through query?
View 4 Replies View RelatedNew To Visual Basic Coding In Access
Mar 31, 2006I am not new to Access, however I am just starting to get to the point where I need visual basic to complete some things I want to try. My question is, how do I code a button (or modify an existing one) in my form that will email the same output I get when I use a Print Report button. Here is what I have from my standard buttons:
Private Sub Save_Svc_Record_Click()
On Error GoTo Err_Save_Svc_Record_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Save_Svc_Record_Click:
Exit Sub
Err_Save_Svc_Record_Click:
MsgBox Err.Description
Resume Exit_Save_Svc_Record_Click
End Sub
Private Sub Prt_Svc_Record_Click()
On Error GoTo Err_Prt_Svc_Record_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection
Exit_Prt_Svc_Record_Click:
Exit Sub
Err_Prt_Svc_Record_Click:
MsgBox Err.Description
Resume Exit_Prt_Svc_Record_Click
End Sub
Private Sub Add_Svc_Record_Click()
On Error GoTo Err_Add_Svc_Record_Click
DoCmd.GoToRecord , , acNewRec
Exit_Add_Svc_Record_Click:
Exit Sub
Err_Add_Svc_Record_Click:
MsgBox Err.Description
Resume Exit_Add_Svc_Record_Click
End Sub
Thanks in advance for any help I can get.
Very Basic Question - Beginner Using Access 2000.
Dec 5, 2007Hi, I'm a student, I need an answer to what I suspect is a very basic question for experts or experienced Access users. I'm creating a basic booking system for a real-life client, a professional singer. I have a table with each gig she takes, with details of how much she will earn, and the date of the gig.
I want to be able to show how much she earns every month, so basically adding up all the booking fees up for each month. I'm pretty sure it's a report made from a query - with the query somehow separating fees earned from month to month. Let me know if you have any ideas...
Modules & VBA :: Review Workflows Converted From Data Macros
Nov 11, 2013Is there a way to review / edit the actual SharePoint workflows in SharePoint created by Access Services after a web database has been published?
View 2 Replies View RelatedTables :: Import Txt Files -> Text Converted To Number
Jan 18, 2013I'm having a number of tables in Access which I want to populate with data from excel/txt. In my import files I have some columns which contain alphanumeric data, like 0001 or XYZ0.
I've defined these columns as text in the definition of my table, however whenever I'm importing the text file, it converts those rows that can be read as a number to a number prior to storing it in my table. Hence values like 0001 becomes 1. Which is absolutely not what I need.
How I can prevent Access from doing this conversion? Why does it do the conversion anyway? I wouldn't expect any conversion since I defined the column as text...
When I import the same txt file into a new table (created during import, where I also define those columns as text) everything goes fine, 0001 stays 0001, but I don't want to remove my table and redefine it during the import everytime I need to import new data.
MS Access 2003 Running On Vista Home Basic
Oct 7, 2007hi there,
i'm thinking about upgrading my operating system from XP to Vista Home Basic, but curious if any users have have experianced any dramas running Access 2003 SP3 on the Vista platform? or shouldnt there be any mayjor problems.
regards
Colin
Tables :: How To Rename Access Table In Visual Basic
Jul 20, 2013i need to auto rename a table and for each new time to create date in table name and after that to use query into i am asking if that is possible.
my 1 table name is kalktbl and second table name is kalkulacija.
query is select * into kalkulacija from kalktbl and i am renaming kalkulacija.
i am using visual basic.
How To Open Access 2007 From Visual Basic Program
Nov 22, 2014I have a fully operational Visual Basic program that uses MS Office XP and it's related MS Access. Because of security concerns, I recently upgraded to MS Office 2007 and MS Access 2007. I can open MS Access 2007 using the shortcut on the desktop and run any of the database queries. When I try to run the Visual Basic program (called prjPathfinder) and open Access 2007, it says "Error 5: The type initializer for prjPathfinder.Upgrade Support threw an exception". It then shows the first form in prjPathfinder but does not open Access 2007. What am I missing?
View 3 Replies View Related