Publishing Access Databases In Dreamweaver

Aug 26, 2004

I want to publish my access database on my local pc and was thinking of using something like Dreamweaver to do this. Is this possible? I don't want to put this on the webserver but on my local machine (only a few people will be connecting), and I've read something about a Personal Web Server so this could be done. Does anyone have any ideas / thoughts on the best way to do this? Oh, I want the database / web to be "live" so the tables get updated as they are changed over the web.

View Replies


ADVERTISEMENT

Publishing Access Programs

Oct 29, 2005

Hi,

just starting out building a database product for mineral collectors and wanted to know what to do went it is complete.

If you want to issue the finished collectors data base as an application to other users do you need a program generator?


I have heard o the Access tollbox, does this do carry out the generation?

Thanks

View 1 Replies View Related

General :: Publishing Access Database On Web - Convert To HTML?

Feb 1, 2013

I have small program in access database which contains about 100 cca tables, querys, forms, macros in total. Customer which both program from me, wants me to enable him to access this program not just from work, it wants to access it from home or when he is on business trip from hotel etc.

I am little confused how to achieve this and what are my options? I assume I have to set by database somewhere on server and so my customer could access it any time? Do I have to upsize access database to SQL express or similar?

Also, one more important question: is it possible to "convert" access database into HTML code or similar so it could be accessed via web browser without need to install microsoft access and with freedom that it can be opened from any type of PC OS (Linux, Mac etc)?

View 14 Replies View Related

General :: Publishing Access Tables For Runtime Viewers?

Feb 4, 2013

My office recently purchased Microsoft Access for our secretary to keep track of our contacts. No other employee owns Access so we have to distribute the tables through Access Runtime. However, there seems to be a problem.

I save and publish a database using the Packaging Wizard. I then send the associated folder with the install program to a computer which has Access Runtime installed on it. But, when I install the file I created with Packaging Wizard it just opens an Access window that is completely blank. It's actually the same thing that occurs when I try to open an Access file on a computer that doesn't have Access or Runtime installed on it at all.

View 7 Replies View Related

Missing Lines & Pics When Publishing Access Report In MS Word

Sep 24, 2003

Hi all,

It's my 1st posting! Need help on how to get Unbound OLE objects (i.e. lines, pics, et.) reflected when publishing my Access report into MS Word. So far, only the data are exported. Appreciate your help.

System Info: Intel Celeron 700MHz, W98SE, MS Access 2002

View 4 Replies View Related

Linking Excel To Access Automatically - Publishing Daily Report?

Dec 6, 2012

Having experimented with Access for a few months now; I know you can link an Access Database to SharePoint, and you can export Excel files into Access for inclusion in tables.

My question is; If I have a daily report being produced, through script, with an excel output. Is there anyway to automatically publish this in Access, negating the need to manually go into Access to import?

View 5 Replies View Related

Publishing To Web

Sep 25, 2006

Hi folks,

I'm new to the business of publishing a database on the net... though I have some experience with HTML and XML, I have absolutely no knowledge of ASP at all. I wonder if anyone would be kind enough to walk me through the steps of getting my database up and operational on the web. Thank you in advance!

~Lana Faith Call

View 2 Replies View Related

Using Access Databases With Web Sites

Oct 20, 2006

Hi,

I curently have a website that has a registration page on it that uses a simple access database that contains a single table with the same fields on as that of the reg. form. What I want to do, in one way or another, is to make some sort of macro that starts once some datails have been submitted to the database using an SQL statement I made within Frontpage, send an email to the registrant telling them what there customer number etc (autonumber in database) and various other welcoming messages etc.
The SQL statement is along the line of INSERT INTO...

Am I thinking along the right lines with a macro or some code or is the access database literally rendered to a table/number of table and thats it?

Cheers folks

View 5 Replies View Related

Problem With Access Databases

May 5, 2007

Hi,

Recently, i had upgraded my computer with some new hardware, therefore i did a fresh install of win xp sp2.

Now I noticed that after i installed all the usual software including microsoft office 2003, when i am opening a ms access database and i open the first form, most of the fields on the particular form (no matter which form in the database as long as it is the first one) display just a value on most field (i am noticing those fields with text datatype), and i am noticing that the number shown is the same as the autonumber i have for that record. Eventually, closing and re-openining the form will fix the problem. this is happening with all of my access databases, some of which i have been using for ages.

Actually, i have tried running the detect and repair tool from the microsoft access help menu to no avail. I have even tried importing the database objects to a new database but still to no avail. Finally i also tried uninstalling and re-installing microsoft office, and the problem is still persisting.

Any idea what might be going on, and hopefully a resolution to sort out this nightmare?

Thank you very much all for your attention.

View 7 Replies View Related

Merging Two Different Access Databases

Jul 22, 2006

Hi,

I've asked this on a few other websites with limited or no success.

this is from one db. this table originally had about 20-30 different fields,

WarehouseNum ItemNum load_date Shipped
101 31 6/26/2006 200
101 31 6/27/2006 180
101 338 6/26/2006 162
101 338 6/27/2006 357

this table is from another db. Notice how WarehouseNum is '9' instead of '1' and itemNum is '000'. This is just one of many impediments I face. As well, none of the table fields are the same, I changed them here to make it easier to work with.

SupplierNum ItemNum WarehouseNum PlannedDelDate DeliveredQty
869747 00031 901 6/26/2006 250
869747 00031 901 6/27/2006 300
869747 00338 901 6/26/2006 490
869747 00338 901 6/27/2006 490


The goal here is to query the two simultaneously, perhaps with linked tables, type in an ItemNum using a parameter and know for instance that on the 26th, we received 250 item31 and shipped 200 for a remaining balance of 50. The 50 is what I'm after. Basically, my company uses one program for sales and another for purchasing and absolutely nothing for inventory management. I started with this company about 3 weeks ago and unless i can implement some kind of temporary solution, it will drive me insane.

Advice? Best approach? As well, this db will use data on two different servers
Thanks for the help.
As well, my access experience is limited and our company I.T. is seriously backlogged, besides which, I would like to learn how to do this myself.
Thanks again

View 1 Replies View Related

Publishing With Word

Mar 7, 2005

How do I Pubish a from from access into word using a word template i have created? and not just into a blank word document?

View 1 Replies View Related

Running Access Against Multiple Databases - DEV/UAT/PRD

Feb 21, 2007

Access 2003

I've inherited an Access Application which has
(1) a number of linked tables that are used to seed the underlying SQL Server database.

This system has been set up and is working in Development. My task is to move it to UAT but with regards to point (1) above I can't see any alternative but to copy the Access Database, create a new System DSN and re-import the External Data from the new DSN. What I'd like to do is use the same Access Database to point towards DEV or UAT or PRD. Is this possible to do this or am I stuck with maintaining 3 different Access Databases ?

I am a developer with many years of experience but my Access knowledge is limited so any pointers would be helpful.

View 5 Replies View Related

Access Databases Won't Open On A Workstation

Feb 22, 2008

I'm having a problem on a workstation that I've always used to create databases in Access. When I open any of my saved .mdb's I get a the error "end query expression" with the table name. The message gives me the option to click OK or Help and Help refers to "<Message> in query expression <expression>. (Error 3075)".

I've copied the .mdb's to another PC with Access installed and they open with no problem and I've removed and reinstalled Access on the problematic PC but still the same problem.


Also, I have a UPS Worldship shipping application that uses an Access database and when it opens it gives me a Micrsoft Visual C++ runtime error then closes, which may or may not be related.

I get the sense that something is corrupted in either Access or Windows XP but I'm not sure where else to look.

Any ideas?

Thanks,

Stuart

View 2 Replies View Related

General :: Communicating Between Different Access Databases

Jul 31, 2014

I have an access db as the backend with the tables. Then multiple front end access dbs that link to the tables (as external sources). The front end dbs are setup with different forms on a per user basis, depending on their role. From my user db I want to be able to request information from another user. I want something in their db to pop-up and request the information.

I was thinking about approaching it using the datamacros. I thought maybe each front end db could have a messages table that the main db and other front ends link to. Then whenever they add data to your specific table it would respond and ask the user for the information. The info would then populate back into the message table where it could be retrieved by the requester.

Example: User A opens A.accdb and has a table called A_tbl. User B opens B.accdb and has a link to A.accdb.A_tbl. User B adds a record to A.accdb.A_tbl with Field1 = "what is your name". User A receives a pop-up with the info from Field1 and responds in a textbox for Field2. User B can then look at A.accdb.A_tbl and see the response as Field2.

Another option I thought of was simply trying to get one db to run a form/macro on another db remotely.

Example: User A opens A.accdb and User B opens B.accdb. User A clicks a button on one of his forms and it opens B.accdb.FORM in the session of User B. User B fills out the form and submits. User A retrieves data from shared tables as normal.

View 2 Replies View Related

Need To Merge Changing Databases Into One On Access

Sep 27, 2012

I have to coordinate a dbase in the US, one in the UK, and one in the KSA. I have multiple documents that may, or may not, be in each of the three dbases. I need to merge all three, and maintain them so that the document additions, as well as any changes associated with that document, (i.e. "revisions"), are updated. Having looked at access and having read through some of the Access forum questions, I understand that it can do that, but after having identified the information from the dbases that will go into access, I'm trying to establish a consistant process for maintaining and updating it. Can I export my information from each of the dbases, into an excel spreasheet, (1 for US, 1 for UK, and 1 for SA), and have the access dbase search for the document number, compare the data following the document number, and if it's the same ignore it, and if it's different, update it?

I'm trying to muddle through this and get access and excel to do as much of this as possible, as it's a very tedious and time consuming process to manually check each one, one or two times a week.

View 8 Replies View Related

Linking Two Access Databases In Sharepoint

Aug 22, 2012

I currently have two Access Databases (one with the raw 'data' and the other with the queries and reports that turn it into 'information' - the data database links into the other).

For contingency purposes, I now want to move both Databases onto sharepoint in case I have a system failure on my laptop (I don't have a server I can put these on). When I upload these onto Sharepoint the second database still seems to link to the file on my computer..

Is there a way I can get a Database to link into another database that's held on sharepoint?

View 1 Replies View Related

Publishing Your Results Online

Dec 18, 2005

Hello. This is my first post so be kind!

Im currently working on a project which involves taking customers data via MS ACCESS and storing it in a database. Which has in iternet connection. I would like stored data to be available online.

Which would be the best way to go about this?

MYSQL?

Just a little confused.

Also had a quick browse round the forum and looks like i might be spending a lot of time here:D

View 3 Replies View Related

Publishing URLs In This Forum

Nov 1, 2006

Brain-death is a horrible thing to witness.

I have searched FAQs, advanced search, etc., and know I'm not looking in the right places.

Question: How do you, in this forum, publish a URL using a descriptive title versus the actual URL itself?

Obviously it's not rocket-science since so many contributors do it apparently effortlessly, but folks I'm struggling.

Please point me in the right direction.

Thanks - Bob

View 3 Replies View Related

Publishing Forms To Word

Feb 14, 2006

Maybe this shouldnt even be done in a form as simple of a task i need. I have a query of multiple tables andi want to be able to export it to word with only a few of the columns from the query as well as displayings yes/no instead of -1/0. Basically im just trying to make a table in word so i can have all the correct pages headers and such to make our document control people happy.

Is there a way to publish a form to a word document and get the header of each column to appear at the top of each page? I noticed that if i export the form to HTML then copy and paste the table in the html file to word its works but thats a huge pain in the you know what, and the table ends up looking a bit odd in word and no amount of table formatting seems to fix that but thats a different issue.

Thanks

View 3 Replies View Related

Client & Server Scenario Access Databases

Oct 20, 2006

This post is really aimed at someone that has experience of network databases and the problems they can pose but if you can help at all that would be great!

I work for an insurance company and we have created a database for registering complaints on. The one we currently use is a single .mdb file which can be shared by up to 60 people at any one time. This is creating a lot of problems when the queries and some VBA code are run. I therefore made a server file which is just an mdb file with data tables in and NO forms or queries. This file is stored on a shared drive on the network server. We then created a client file which contains all of the forms and queries and code. This file contains linked tables to the server so when data is entered into the form, it "Sends" it to the server mdb file. The client is installed on each of the local machines c:. The problem with this was that if we made a change to the database, we would need to reinstall the client on every single user pc. This would of took ages. I therefore made an auto-update function that checked the version number on the server and if the server number was greater than the client number, a simple .bat fiile was run which copied the updated client file from the network to the relevant users local disk.
The problem we have now is that our IT department are concered that if we make a change to the client and all the staff log in at 9am for example, it will start doing multiple copying of a file around 8mb in size to around 60 machines. They are only running on a 2meg pipe so this could cause some problems. We are not looking to change the client & server idea but does anyone know if this will have a big impact and infact if the updates for 60 machine is the equivalent or lesser of 60 people sharing the single file i mentioned earlier. If the IT dept are happy with 60 users accessing the same file at the same time, which they currently are, why are they unhappy with it updating these machine using the new method.

Would really apopreciate any thoughts anyone has..

Thanks a lot.

Gaz

View 6 Replies View Related

URGENT: Protecting Access Databases Online

Sep 20, 2006

Hi All,

What's the best way to go about protecting an MS Access database online? Hoping to launch tomorrow, but no can do without protecting the DB first

Basically, I have a database containing some personal information and I need to block people from downloading it, while still allowing my ASP pages to read/write/modify its data.

Can anyone point me in the right direction here? Any relative links, methods, tutorials, etc, would be a fantastic.

I've looked into User-Level Security Passwords, but am not sure if there's a better way to achieve what i'm trying to do (i.e. setting up specific access rights to the folder in which the MDB file is contained).

Thanks in advance...

View 4 Replies View Related

Modules & VBA :: Loop Through Access Databases And Get Table Definitions

Mar 9, 2014

I have 192 databases that I need to redact certain information in certain columns. Generally, I'm looking for field names like name, first name, last name, address, address2, shipping address, mailing address, and phone numbers. Not sure how to get this information without going into every database and every local table inside the databases. Is there a way to get this information programmatically and just access the databases and table that I need to redact info in?

View 6 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

Forms :: Importing Navigation Form Between Access 2003 Databases

Mar 31, 2015

When I import a form with the Navigation control on it The following attributes of the navigation buttons are changed to #FFFFFF:

Hover Color, Pressed Color, Hover Fore Color, Pressed Fore Color

I was hoping to be able to automate the updating of customers databases by sending them a database which would export the required objects rather than the whole front end database. I can think a way around this by including code in the form so that it changes the attributes to the desired values, which are:

Accent 1, Accent 1, Background 1 and Background 1. But I would rather not have to do that.

It is interesting to note that the Border Color attribute is not changed on importing.

View 1 Replies View Related

Reports :: Publishing Multiple Copies Of Selected Reports

Nov 18, 2013

I am trying to add to a db I inherited. One of the end reports that is produced is a cost breakdown for each end user.As things stand, the data collates into individual reports which are then grouped into one file and saved via PDF. What I am trying to work out is whether or not I can selectively pick some of those reports to have more than one copy.

I see a form (within an existing form) that will list all of the end users for a particular scheme and, next to that, be a dropdown that will allow the db user to select how many copies of each report needs to be published. These will then collate merrily into one document to be saved to PDF.

View 8 Replies View Related

New To Databases: I Need Some Advice

Jun 2, 2005

I'm creating a database that keeps track of printing jobs at a printing company... I started my project by drawing out how I want the databases to be configured.

I was going through a book that was made for access 2000, but I need to create this in access 97 because that's what the company has on their computers. One of the features in Access 2000 thats not in 97 is subdatasheets...

Basically, what I want to do is for each printing job, there can be a bunch of different tasks that need to be completed and billed for. For example, on one printing job, they need to design a logo, and then they need to print it out and send samples across the globe, and then they need to create a pdf, etc. This is going to be different for each job.

What I figured I would do is create a separate table to take care of all of the different tasks that are related to each job. This table would have the primary key of the job from the main table for each individual job, and then they would be related in a one (MAIN entry) to many (tasks) relationship.

Is this correct in how I want to do that? How will I do this inside a form, I want them to enter the information in table that expands as they put more tasks in?

This might be a very simple question, I just want to know if I'm going in the right direction.

Thanks much!

View 2 Replies View Related







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