Tag Info

New answers tagged

0

I solved this by creating a updateable VIEW to the table. The view displays every column but the primary key LNEr is converted to a string with the HEX() function: CREATE VIEW v_ereignisse AS SELECT HEX(LNEr) AS LNEr, Datum, StatNr, ... In MS Access instead of creating a link to the table I created a link to the view. Because the view has no primary key, ...


1

I think Binaya Regmi is correct. When deleting in SQL-Server explicitly name the table you want to delete the rows from - especially necessary when using a join. So in your case change the top row from DELETE category.* to DELETE category


1

To reinforce what Jon says - a single DB to which all clients connect all the time, with the schema designed accordingly, will be a much better solution. You only need replication in a few circumstances. One is if a client machine must be able to work while disconnected. Another will be if there are huge latency issues between your various sites. ...


1

MS Access Vs MySQL MS Access works only on Windows whereas MySQL works on almost all platforms. MS Access does not support Partitioning feature whereas MySQL has composite, Range partitioning support. MySQL is opensource so no cost involved. Performance in MySQL is way better than MS Access MS Access database is more suitable for desktop use with a small ...


1

As well as PostgreSQL (which I recommend), you could also look at Firebird (another excellent choice). What is your development environment? If you're replacing spreadsheets, another good option might be Oracle's APEX with Oracle XE. If you do decide to go down the MySQL route, try to avoid non-standard data types like SET and ENUM (porting becomes ...


0

Take a look at http://www.mysql.com/why-mysql/windows/excel/ MS Access has limitations, data types, storage size, users access control (since you're going to have it accessed by more than a user). i think using MySQL will be more useful as your database grows up. it is a powerful dbms and will open doors for future enhancements and migrations.


1

This will do the trick in recent versions of SQL Server and Oracle: SELECT ID, Flag, LAG(Flag) OVER(ORDER BY id) AS ShiftFlag FROM tab ORDER BY id; If you don't have LAG(), for example in MS SQL Server 2008, you can use ROW_NUMBER() like this: ;WITH num AS ( SELECT ID, Flag, ROW_NUMBER() OVER(ORDER BY id) AS n FROM tab ) SELECT t1.ID, t1.Flag, ...


1

Unfortunately the only solution I found was to write a program (I used C#, but anything would work) to go through the file and enter more line breaks between the different invoices. I then wrote some VBA code in Access that exported the query to a file and then ran the formatting program over the file, thus making it appear seamless to the end user.



Top 50 recent answers are included