Child ID Access

I want to start a new Access database using the same forms as an older database. Is it possible to ‘import’ them somehow?

You can import from your old Access database. Go to the Forms database window, click File -> Import. Then navigate to the old file, and select the forms you want to import.

Obviously the forms are based on either tables or queries. These will also have to be imported if you don’t already have them. Just go to the relevant database window, and follow the same procedure as above.

I have been sent an Access database but I can’t open it – I guess I haven’t got an Access programme on my PC. How can I get one to open the database?

You should install Miscrosoft Office, or only Microsoft Access.
May be also OpenOffice + something mdbtools

The Access database has a query built into it that yields the desired results. I want to pass a parameter from the web page to the query and have the results displayed on the web page. Looking around the Internet, it looks like some people use ASP for Access databases and some people use PHP. I know some PHP, but no ASP. I’m just looking for the easiest way. Please help! =)

If your PC/server runs Linux, use PHP, if it’s Windows, use ASP or ASP.NET. (You can also use Mono on Linux to run .NET and ASP.NET).

I think the easiest way is via ASP.NET using the built-in Gridview and AccessDataSource control. You just need to get the free Visual Web Developer Express from Microsoft.

I have a access database; In query builder how to name parameter for filtering. For sqlserver we can use ‘@xyz’ so what is for access database.

It has been a while since I worked with any parameterized Access databases, but it seems to me that I put the text to display in square brackets like so:
SELECT *
FROM table
WHERE field = [What would you like to search?]

Then, running the query would pop up an input box with the prompt: What would you like to search?

I am trying to connect an access database to dreamweaver but I dont have an Ideah. How do i do it using ASP?

dreamweaver doesnt interface with the database, your code does.

For an example of how to connect to the access database in your ASP Code, refer to the following (the actual code is toward the bottom under heading "Connecting to MyDatabase" ) http://www.haneng.com/lessons_17.asp

I have a 2007 Access database but cannot do hardly anything with it as most buttons are blanked.
The trial period has finished for Access.
How can I convert it to an Sql SDerver Express R2 database?

You could try simply opening the Access mdb (or better still, a copy of it, jic) in SQL Server – since they are both Microsoft products (and SQL Server is more advanced), it might be able to convert it for you automatically. If not, try to export it from Access (if you can do so from an expired version) into a CSV or XML file and then import into SQL Server.

I have created a Microsoft Access Database using a public computer, and now I would like to run it on my computer, I have Works Database, though it is not that good, I was wondering if I could save my database to the internet, and access it, add more information to it, and edit it via the internet.
How can I use my database, on my computer without access?

Is there anyway, that I can run an Access Database, on a computer without Microsoft Access?

You can run any Access database on any pc without actually having MS Office Access installed by downloading the free run-time for Access (from Microsoft website) – search for ‘Access Runtime download’.

To run an Access database over the internet is not recommended as it is not robust enough and considered a true client/server database. You will need to use MySQL (or something just as strong and ready for server side processing).

Hope this helped.
Ben Beitler

missingmanuals.com – This screencast from Matthew MacDonald, author of Access 2007: The Missing Manual, guides you through creating a custom switchboard in a Microsoft Access database.

Duration : 0:5:42

(more…)

Free trial at http://www.caspio.com

This video tutorial will show you step-by-step how to create a searchable web database and deploy it online in just 6 minutes!

Learn how to create online databases and web applications such as CRM, real estate listings, support ticket systems, bug tracking, marketing apps, product listings, online ordering, and more!

See how to use Caspio’s cloud computing platform to build web applications, web forms, and searchable databases. Import data tables from Microsoft Access, Microsoft Excel, CSV, TXT or XML and publish apps directly on your website without programming.

Sign up for a free trial at http://www.caspio.com

Duration : 0:7:51

(more…)

Before I have tried to show how to create Tables or Forms. Here I try to set up TWO TABLES and RELATE them. Once that has been done then I create a QUERY and demonstrate the relationship between the two tables.
This relationship enables me to pull information from both TABLES. This is vital IF I am going to be able to make the Relational Database work properly.

Duration : 0:7:37

(more…)