Viewing 15 posts - 1 through 15 (of 72 total)
Hi homebrew01
I'm trying to find a commandline utility that will provide change scripts to bring one copy of the database in sync with a second copy of the database....
June 2, 2008 at 6:17 am
Ken, I have spent all day looking for a freeware tool to do this 🙂 If yours is available and works from the command line then please could you let...
June 1, 2008 at 11:54 am
It could be the SET NO COUNT thing, but I am sure we have come across problems with accessing temp tables with the # notation. I can't remember what we did about...
April 12, 2004 at 5:01 pm
Late binding:
Dim ObjJRO
set ObjJRO = CreateObject("jro.JetEngine")
March 11, 2004 at 8:13 pm
Try putting this in your DTS script:
http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3Bq230501&GSSNB=1
HTH
Chris
March 10, 2004 at 5:51 pm
Hi,
I am only talking about your data structure not your forms reports etc.. converting these are a separate issue.
The upsizing wizard in Access really isn't that bad.For the most part it...
February 19, 2004 at 5:28 pm
Hi,
Yes, there is another way;
1)Create a system DSN to your SQL server in control panel ODBC
2) Add your SQL server table or view as a linked table(right click,Link tables,file...
February 14, 2004 at 11:26 am
Further to my last post I just remembered, there is supposed to be an MSAccess to SQL Reporting services upgrade wizard included in the product. I haven't tried it out yet, but...
January 30, 2004 at 8:12 pm
If your sql statement has table joins within it, it will effectively be a view and need to have the unique table property set in order to be updatable.
I cannot see...
January 28, 2004 at 4:11 pm
Yes, it is a shame that the report designer is only available with Visual Studio, right now it is a pain. I have a load of reports I would like...
January 27, 2004 at 6:32 pm
Hi,
Rather than change the name of the .adp file, I put each of my historic versions into a separate directory on the file sytem and name the directory with version info....
January 27, 2004 at 6:09 pm
Hi,
Don't know about the Yukon version but you can do this in SQL 2000. In the DTS designer on your test server select Save As and then save the...
January 26, 2004 at 9:50 am
Hi,
Is your form based on a view or a table?
If a table, you should not need the unique table property to be set at all. I think in this...
January 24, 2004 at 7:33 pm
First thought, "Great they improved it!",
Second thought, "Are all my existing packages going 2 break?"
Will there be a seamless route to migrate SQL 2000 DTS packages into Yukon or will...
January 9, 2004 at 9:12 pm
Hi,
Subforms are set at the form level! In your subform control click properties and set the master and child link properties. This will cause your subform to appear filtered...
January 6, 2004 at 11:24 am
Viewing 15 posts - 1 through 15 (of 72 total)