I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have split the DB so I can upgrade and debug the
front end before installing on my clients' computer. I used the
ACCESS splitter utility and everything appeared to go OK. If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms. but, I also see the Table. If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table. When I look at the size of the
files, the front end file is the same size as the original un-split
database.
Can someone explain what is happening ?
Thanks,
Stan Hanna
6  1930 
splitting the DB allows you to work on the forms, reports, etc in a copy of
the front end, while a user still uses the DB, then you over write the FE
and no data in the tables is lost
"Stan" <st*******@hotmail.comwrote in message
news:11**********************@w5g2000hsg.googlegro ups.com...
>
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have split the DB so I can upgrade and debug the
front end before installing on my clients' computer. I used the
ACCESS splitter utility and everything appeared to go OK. If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms. but, I also see the Table. If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table. When I look at the size of the
files, the front end file is the same size as the original un-split
database.
Can someone explain what is happening ?
Thanks,
Stan Hanna
Hi, Stan.
Can someone explain what is happening ?
Sure.
If I run
"Copy of DB_be.mdb"
This is because you're working with the first "copy of" the file, rather
than the original.
If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
Then it's working as designed. If you had multiple tables with
relationship, that's where the relationships would migrate, also.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms.
Then it's working as it should.
but, I also see the Table.
Not exactly. You see the link to the table located in the back end. Take a
closer look at the icon in the Database Window. Does it have a blue
right-pointing arrow on the left of the table icon? If so, that indicates a
link to the actual table, because the table no longer resides in the front
end after the database was split with the wizard.
If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table.
You removed the link to the table in the back end, so how is the query going
to find the table? Link to the table in the back end again and use the same
name for the table, and your queries in the front end will work again.
When I look at the size of the
files, the front end file is the same size as the original un-split
database.
The table was taking up space when it was there, but now that it's gone that
space isn't reclaimed until one does a compact/repair on the database file.
Select the Tools -Database Utilities -Compact and Repair Database...
menu in the front end open, and it will reclaim the disk space that was once
used for the table, making the file smaller. Periodically, you'll need to
compact and repair the back end, too, to reclaim the disk space as the table
is used.
Therefore, your database was working as designed, and you needn't worry as
long as you relink the table and compact the database periodically.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Stan" <st*******@hotmail.comwrote in message
news:11**********************@w5g2000hsg.googlegro ups.com...
>
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have split the DB so I can upgrade and debug the
front end before installing on my clients' computer. I used the
ACCESS splitter utility and everything appeared to go OK. If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms. but, I also see the Table. If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table. When I look at the size of the
files, the front end file is the same size as the original un-split
database.
Can someone explain what is happening ?
Thanks,
Stan Hanna
On May 5, 8:26 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
Hi, Stan.
Can someone explain what is happening ?
Sure.
If I run
"Copy of DB_be.mdb"
This is because you're working with the first "copy of" the file, rather
than the original.
If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
Then it's working as designed. If you had multiple tables with
relationship, that's where the relationships would migrate, also.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms.
Then it's working as it should.
but, I also see the Table.
Not exactly. You see the link to the table located in the back end. Take a
closer look at the icon in the Database Window. Does it have a blue
right-pointing arrow on the left of the table icon? If so, that indicates a
link to the actual table, because the table no longer resides in the front
end after the database was split with the wizard.
If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table.
You removed the link to the table in the back end, so how is the query going
to find the table? Link to the table in the back end again and use the same
name for the table, and your queries in the front end will work again.
When I look at the size of the
files, the front end file is the same size as the original un-split
database.
The table was taking up space when it was there, but now that it's gone that
space isn't reclaimed until one does a compact/repair on the database file.
Select the Tools -Database Utilities -Compact and Repair Database...
menu in the front end open, and it will reclaim the disk space that was once
used for the table, making the file smaller. Periodically, you'll need to
compact and repair the back end, too, to reclaim the disk space as the table
is used.
Therefore, your database was working as designed, and you needn't worry as
long as you relink the table and compact the database periodically.
HTH.
Gunny
Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
info.
"Stan" <stanha...@hotmail.comwrote in message
news:11**********************@w5g2000hsg.googlegro ups.com...
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have split the DB so I can upgrade and debug the
front end before installing on my clients' computer. I used the
ACCESS splitter utility and everything appeared to go OK. If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms. but, I also see the Table. If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table. When I look at the size of the
files, the front end file is the same size as the original un-split
database.
Can someone explain what is happening ?
Thanks,
Stan Hanna
Thanks to All. I learned a lot tonight.
Stan Hanna
You're welcome. Good luck with the rest of the project.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Stan" <st*******@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
On May 5, 8:26 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
>Hi, Stan.
Can someone explain what is happening ?
Sure.
If I run
"Copy of DB_be.mdb"
This is because you're working with the first "copy of" the file, rather
than the original.
If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
Then it's working as designed. If you had multiple tables with
relationship, that's where the relationships would migrate, also.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms.
Then it's working as it should.
but, I also see the Table.
Not exactly. You see the link to the table located in the back end.
Take a
closer look at the icon in the Database Window. Does it have a blue
right-pointing arrow on the left of the table icon? If so, that
indicates a
link to the actual table, because the table no longer resides in the
front
end after the database was split with the wizard.
If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table.
You removed the link to the table in the back end, so how is the query
going
to find the table? Link to the table in the back end again and use the
same
name for the table, and your queries in the front end will work again.
When I look at the size of the
files, the front end file is the same size as the original un-split
database.
The table was taking up space when it was there, but now that it's gone
that
space isn't reclaimed until one does a compact/repair on the database
file.
Select the Tools -Database Utilities -Compact and Repair Database...
menu in the front end open, and it will reclaim the disk space that was
once
used for the table, making the file smaller. Periodically, you'll need
to
compact and repair the back end, too, to reclaim the disk space as the
table
is used.
Therefore, your database was working as designed, and you needn't worry
as
long as you relink the table and compact the database periodically.
HTH.
Gunny
Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor
contact
info.
"Stan" <stanha...@hotmail.comwrote in message
news:11**********************@w5g2000hsg.googlegr oups.com...
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have split the DB so I can upgrade and debug the
front end before installing on my clients' computer. I used the
ACCESS splitter utility and everything appeared to go OK. If I run
"Copy of DB_be.mdb" I see only the table, not the Queries or Forms.
When I run the front end "Copy of DB.mdb" I see the Queries and
Forms. but, I also see the Table. If I delete the table from the
front end and try to run a Query I receive the error message that the
application can not find the table. When I look at the size of the
files, the front end file is the same size as the original un-split
database.
Can someone explain what is happening ?
Thanks,
Stan Hanna
Thanks to All. I learned a lot tonight.
Stan Hanna
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:13*************@corp.supernews.com:
you needn't worry as
long as you relink the table and compact the database
periodically.
Front ends don't really need to be compacted. I never have my
clients do it. Ever.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Hi, David.
Sorry. I didn't make that very clear. The front end needs to be compacted
after splitting the database with the wizard (to reclaim the space inside
the file that was previously occupied by the table), and the back end needs
to be compacted periodically.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM>
wrote in news:13*************@corp.supernews.com:
> you needn't worry as
long as you relink the table and compact the database
periodically.
Front ends don't really need to be compacted. I never have my
clients do it. Ever.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: SL_McManus |
last post by:
Hi All;
I am fairly new to Perl. I have a file with close to 3000 lines
that I would like to split out in a certain way. I would like to put
the record type starting in column 1 for 2 spaces,...
|
by: TJ |
last post by:
I am very new to C# (this is my first real project), therefore please be
patient if my question is considered being to newbie.
I am modifying a program which takes a text file, does some...
|
by: merrittr |
last post by:
I have a string "c:\upload\file.txt"
what I want is the file name to do this I was trying split on \ but
I cant seem to get it to work?
Server Error in '/appform' Application....
|
by: quest |
last post by:
I created windows application using C#. I tried to replace the default
application icon by replacing the app.ico file in the project directory but
the application still load the old icon. Can...
|
by: Vlado Jasovic |
last post by:
Hello,
We're developing application in VS2005 using vb.net.
Our application exe file is ~20mb when compiled.
Recently, we have developed auto-update feature that goes on our web-site,...
|
by: ivan.perak |
last post by:
Hello,
im a beginner in VB.NET... The thing i would like to do is as it
follows....
I have a text file (list of names, every name to the next line) which
is about 350000 lines long. I would...
|
by: Martin Arvidsson, Visual Systems AB |
last post by:
Hi!
I have a string containing this information:
Including file: Myfile.fle (C:\Program
Files\Application\Source\Myfile.fle)
After myfile.fle there are three spaces!
Since i use the...
|
by: Mohit |
last post by:
Hi Experts,
I am working on a windows application that generates few text
files and saves it onto the disk. Now I want that only my application
can read the files i.e. I don't want the user to...
|
by: Edwin.Madari |
last post by:
#your thought is right.
=======================================================
def sizes2fields(sizes):
d =
begin = 0
for i in sizes:
if begin:
end = begin + i
else: end = i...
|
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...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
| |
