Access 2k FE - SQL Server 2k BE
I've been asked to do some work on this Access application. It was an
Access<->Access app., but I've upsized the BE to SQL Server 2k. As far
as I can see it runs fine. It compiles fine.
I'm trying to add it to SourceSafe (Version 6c) and then check it out.
FYI the name of the application is eFIMS, and the name of the file is
eFIMS.mdb
It seems to add the project to SourceSafe with no trouble.
Now I wish to get a working copy from SourceSafe, so I go to Tools,
SourceSafe, Create Database from SourceSafe Project
Select the eFIMS project and choose a working folder.
While SourceSafe is adding the various files it suddenly stops and
tells me:
"Not a legal object name: FIMS.mdb"
If I click "Ok" to that I get a further error message:
"Failed to import file C:\Project\eFIMS\eFIMS.scc\eFIMS.acb into
Microsoft Access".
Click OK and it tells me that the operation completed successfully.
Only it didn't. If I open a code module and try to compile, I get a
"variable not defined" error.
If I re-open a working copy (prior to adding to SS), locate the
variable that apparently isn't defined, and right-click and go to
"Definitiion" I get the message:
"Cannot jump to "Actual End Time" because it is in the library
'C:\Project\eFIMS\eFIMS.mdb' which is not currently referenced"
Can ANYONE tell me what the blue blazes is going on?
TIA
Edward
6  5470 
I have had problems with sourcesafe also, and I heard that other people
have too. I switched to subversion and have not had any issues to speak
of. You might give that a try.
Rich
*** Sent via Developersdex http://www.developersdex.com ***
<te********@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Access 2k FE - SQL Server 2k BE
I've been asked to do some work on this Access application. It was an
Access<->Access app., but I've upsized the BE to SQL Server 2k. As far
as I can see it runs fine. It compiles fine.
I'm trying to add it to SourceSafe (Version 6c) and then check it out.
FYI the name of the application is eFIMS, and the name of the file is
eFIMS.mdb
It seems to add the project to SourceSafe with no trouble.
Now I wish to get a working copy from SourceSafe, so I go to Tools,
SourceSafe, Create Database from SourceSafe Project
Select the eFIMS project and choose a working folder.
While SourceSafe is adding the various files it suddenly stops and
tells me:
"Not a legal object name: FIMS.mdb"
If I click "Ok" to that I get a further error message:
"Failed to import file C:\Project\eFIMS\eFIMS.scc\eFIMS.acb into
Microsoft Access".
Click OK and it tells me that the operation completed successfully.
Only it didn't. If I open a code module and try to compile, I get a
"variable not defined" error.
If I re-open a working copy (prior to adding to SS), locate the
variable that apparently isn't defined, and right-click and go to
"Definitiion" I get the message:
"Cannot jump to "Actual End Time" because it is in the library
'C:\Project\eFIMS\eFIMS.mdb' which is not currently referenced"
Can ANYONE tell me what the blue blazes is going on?
TIA
Edward
Wild shot in the dark.
Try creating under Options: File Types Tab, a File Group for this project,
and make sure to list *.mdb as a binary file.
-ralph
On 22 Sep 2006 07:47:14 -0700, te********@hotmail.com wrote:
Before you use SourceSafe integration with Access at the object level,
it is good to read up on how to use it, and its limitations.
For our company, we consider the limitations too severe, and only
check in entire MDB files.
-Tom.
>Access 2k FE - SQL Server 2k BE
I've been asked to do some work on this Access application. It was an
Access<->Access app., but I've upsized the BE to SQL Server 2k. As far
as I can see it runs fine. It compiles fine.
I'm trying to add it to SourceSafe (Version 6c) and then check it out.
FYI the name of the application is eFIMS, and the name of the file is
eFIMS.mdb
It seems to add the project to SourceSafe with no trouble.
Now I wish to get a working copy from SourceSafe, so I go to Tools,
SourceSafe, Create Database from SourceSafe Project
Select the eFIMS project and choose a working folder.
While SourceSafe is adding the various files it suddenly stops and
tells me:
"Not a legal object name: FIMS.mdb"
If I click "Ok" to that I get a further error message:
"Failed to import file C:\Project\eFIMS\eFIMS.scc\eFIMS.acb into
Microsoft Access".
Click OK and it tells me that the operation completed successfully.
Only it didn't. If I open a code module and try to compile, I get a
"variable not defined" error.
If I re-open a working copy (prior to adding to SS), locate the
variable that apparently isn't defined, and right-click and go to
"Definitiion" I get the message:
"Cannot jump to "Actual End Time" because it is in the library
'C:\Project\eFIMS\eFIMS.mdb' which is not currently referenced"
Can ANYONE tell me what the blue blazes is going on?
TIA
Edward
Tom van Stiphout wrote:
On 22 Sep 2006 07:47:14 -0700, te********@hotmail.com wrote:
Before you use SourceSafe integration with Access at the object level,
it is good to read up on how to use it, and its limitations.
For our company, we consider the limitations too severe, and only
check in entire MDB files.
-Tom.
We've been using SourceSafe integration for Access for nearly ten
years, and this is the first time we've had this sort of problem.
Edward te********@hotmail.com wrote:
Access 2k FE - SQL Server 2k BE
[...]
Sorted.
The problem was the Properties page for the database.
Right-click on the title bar of the Database window.
In the Summary tab is a Title field. This didn't match the name of the
file:
FILENAME: e-fims.mdb
TITLE: FIMS.mdb
When I changed the title, all was rosy.
Edward
<te********@hotmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
>
te********@hotmail.com wrote:
Access 2k FE - SQL Server 2k BE
[...]
Sorted.
The problem was the Properties page for the database.
Right-click on the title bar of the Database window.
In the Summary tab is a Title field. This didn't match the name of the
file:
FILENAME: e-fims.mdb
TITLE: FIMS.mdb
When I changed the title, all was rosy.
Edward
Thanks for the feedback. I have been bitten by that myself occasionally, but
never thought of it - I guess one tends to blank out bad memories. <g>
-ralph This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: pakkocool |
last post by:
¿Como ganar dinero en internet?
Lee atentamente el siguiente texto, es super interesante y te hara
ganar muchos dolares si sigues las instrucciones y le pones empeño:
Hace unos días que...
|
by: __PPS__ |
last post by:
Actually what I mean is that - if I have some memory buffer, lets say
char a; and then I do like this:
DWORD num = 0x1234;
*(DWORD*)a = num; (1)
*(DWORD*)(a+1) = num; (2)
either...
|
by: bluekite2000 |
last post by:
If it is what is this technique called? A good example for this would
be when I need to extract a column out of a matrix, then create a new
diagonal matrix out of this column, ie:
A.cols(3).diag()...
|
by: puzzlecracker |
last post by:
is it possible to call nonconst member function on an unnamed temprary?
ex:
class String{
public:
void doSomething();
};
String createString();
|
by: Alberto Giménez |
last post by:
Hi, I've seen some object oriented programming bits out there and i'm
not sure if they're legal. For example:
struct Object {
int field1;
int field2;
};
struct SubObject {
int field1; /*...
|
by: Kiuhnm |
last post by:
#include <new>
class T
{
};
int main()
{
T t = t;
T u(u);
|
by: Erik de Castro Lopo |
last post by:
Hi all,
The GNU C compiler allows a void pointer to be incremented and
the behaviour is equivalent to incrementing a char pointer.
Is this legal C99 or is this a GNU C extention?
Thanks in...
|
by: Sensei |
last post by:
Hi! I'm concerned about the legality of such a definition:
#define funcX funcY
where funcX belongs to the *standard* C functions. Is it legal to do
this? The standard says "any function...
|
by: Max |
last post by:
This was asked in a C test. Is the following code legal C?
Is it legal in C90? C99?
#define main()
int main
#define mainbody () { return 0; }
mainbody
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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: 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
|
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:
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...
| |
