Fresh Copy - Microsoft Access / VBA

alpapak via AccessMonster.com

Fresh Copy
------------------------------------------------------------------------------
--

hi
i have a Db and i want to empty all my entries and distrubute it

how can i do it??

I know that i can open the tables and delete everything but it will start
counting not from the begging

thxs

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200603/1

Mar 15 '06 #1

Subscribe Post Reply

1515

Wayne Gillespie

On Wed, 15 Mar 2006 07:47:50 GMT, "alpapak via AccessMonster.com" <u19061@uwe>
wrote:

Fresh Copy
------------------------------------------------------------------------------
--

hi
i have a Db and i want to empty all my entries and distrubute it

how can i do it??

I know that i can open the tables and delete everything but it will start
counting not from the begging

thxs

Delete all your data and then compact the database. After compacting all
autonumbers will start from 1 again.
Wayne Gillespie
Gosford NSW Australia

Mar 15 '06 #2

Larry Linson

You can't use this trick now, but you can the next time. Create the tables
in the Front End, and never store data in those. Use them as "templates" via
CopyObject to create a new, empty database from code. It is handy if you
have a "sample" database for users to use for practice, a separate
production database, or want to start your data over as you describe.

Larry Linson
Microsoft Access MVP
"alpapak via AccessMonster.com" <u19061@uwe> wrote in message
news:5d47ef69541b6@uwe...

Fresh Copy
------------------------------------------------------------------------------
--

hi
i have a Db and i want to empty all my entries and distrubute it

how can i do it??

I know that i can open the tables and delete everything but it will start
counting not from the begging

thxs

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200603/1

Mar 16 '06 #3

Similar topics

Submit vs. a fresh page load

by: Martin | last post by:

I'm developing a page - mostly for the learning experience - that includes a form with several text fields and a submit button. When it's submitted, there is some server-side processing and the...

PHP

How to fresh or delete a file in azip-archive via zipfile module?

by: Åâãåíèé Êîñåíêî | last post by:

Hi! I need to fresh a zip-archive using zipfile. However, it seems it is no function to fresh the archive. When I use the append-mode of ZipFile, the written file is merely appended to the...

Python

Accessing Mysql after fresh installation

by: sanjay gupta | last post by:

Hi All, I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message " Access denied for user root@local host .......using...

MySQL Database

How Do I Remove MySQL so I can Start Fresh?

by: KC | last post by:

Hello I installed MySQL ver 4.0.20d on a Windows XP Professional PC. I created a user and database that I would like to delete, and at this point I would just like to uninstall MySQL and do a...

MySQL Database

installing .Net com tlb project on fresh PC

by: Sutapa | last post by:

Hi, I have created a tlb file in .net to use in VB6 application. this application works fine in my Pc which has development environemnt. Now i want to deploy this VB6 exe to other fresh...

C# / C Sharp

RequiredFieldValidator in action immediately in fresh form

by: peshrad | last post by:

Hi ! I'm using Visual Studio .NET to program a Web application coding in C#. In my form I use an HtmlSelect control that calls a JavaScript function when the selected item changes. This...

ASP.NET

Adding a fresh column to a datagrid

by: Mike Fellows | last post by:

I want to add a fresh column to a datagrid that is bound to a datasource i want it to be the first column on the datagrid so that i can number each row 1,2,3,4.... etc. (but i have no need to...

Visual Basic .NET

request for a page using random id to get the fresh copy each time

by: dmjpro | last post by:

when a page is placed then it can be refresh using JS. but if i request for a page using AJAX then how can i get the fresh copy every time. i did that using caching management.... i mean .......

Javascript

Forcing retrieval of a fresh copy of a file with a link

by: Don | last post by:

Is it possible to create a link which will cause either A) the server to serve a fresh copy of a file or B) the browser to "refresh" the copy of the file. Doing it via a link is the only...

HTML / CSS

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

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

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++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA