imorting table info - Microsoft Access / VBA

hi....
currently i have a database we use at work. i develop the database at home. so what i am having to do is copy the database from work, bring it home, make any changes to forms vb scrpit ..etc, save it, then take it back to work, so not to loose info in the tables. what i want to know is if there is a way i can do development work on a 'test' database at home, then import the table info from the works version into it.
cheers

Jan 22 '08 #1

Subscribe Post Reply

938

Jim Doherty

897

Expert 512MB

hi....
currently i have a database we use at work. i develop the database at home. so what i am having to do is copy the database from work, bring it home, make any changes to forms vb scrpit ..etc, save it, then take it back to work, so not to loose info in the tables. what i want to know is if there is a way i can do development work on a 'test' database at home, then import the table info from the works version into it.
cheers

Your easiest method for this Dale would be to SPLIT the database that is to say have all your tables in a backend database and the rest of your objects in a frontend database. You can link the tables to the frontend database. This would enable you to develop in the frontend without impacting on others using your system (they could continue to input).

Jim :)

Jan 22 '08 #2

dale5804

Your easiest method for this Dale would be to SPLIT the database that is to say have all your tables in a backend database and the rest of your objects in a frontend database. You can link the tables to the frontend database. This would enable you to develop in the frontend without impacting on others using your system (they could continue to input).

Jim :)

cheers, was considering that after reading some other posts.

Jan 22 '08 #3

Similar topics

Imorting data from a csv file problems

by: Johnny | last post by:

I have been trying to import a large amount of data into my database using the following format LOAD DATA LOCAL INFILE 'e:\\sydnet2\\_info\\curdocs.csv' INTO TABLE pnp_docs_current FIELDS...

MySQL Database

How to do a <table> with <div> tag

by: Toby Austin | last post by:

I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...

HTML / CSS

Imorting Excel sheets e-mail attachments

by: Osiris Sawiris | last post by:

I inherited an Inventory control application that updates the stock from the branches at the end of each day. We receive the stock transactions via e-mail attachments (Excel Sheets). Those...

Microsoft Access / VBA

Large table performance and vacuum

by: Gavin Scott | last post by:

Hi, I'm having a performance problem with a large database table we use with postgres 7.3.4. The table is: db=> \d log Table "public.log" Column | Type | Modifiers...

PostgreSQL Database

altering a table to set serial function

by: Prabu Subroto | last post by:

Dear my friends... I am using postgres 7.4 and SuSE 9.1. I want to use auto_increment as on MySQL. I look up the documentation on www.postgres.com and I found "serial" . But I don't know...

PostgreSQL Database

Hash Table Implementation in C++

by: Diane | last post by:

Hi everybody. Does anyone have any sample hash table implementation for separate chaining? I'm trying to implement it myself, but I'm stuck. Thanks!

C / C++

table copying in ado 2.0

by: ray well | last post by:

i need to copy in code a table from a legacy dbase III file into an access mdb file. both source and destination tables have the same table names, field names, field types, & field sizes. the...

Visual Basic .NET

table sorting doesnt work in firefox? but everywhere else

by: cluce | last post by:

i have a table sorting feature on my website that works everywhere else except in firefox. but the example code does work in firefox. this has me stumped. The problem is the links in the table...

Javascript

Uploadin Photos and photo info to mysql

by: cumupkid | last post by:

II am trying to create a form that will allow me to upload photos to a folder in the site root directory and add the information to the mysql db at the same time. I have created two forms, one...

ColdFusion

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing